We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1
Practical file questions
1. Create a panda’s series from a dictionary ,list and a ndarray.
2. Given a Series, print all the elements that are above the 75th percentile. 3. Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category. 4. Create a data frame for examination result and display row labels, column labels, data types of each column and the dimensions. 5. Filter out rows based on different criteria such as duplicate rows. 6. Importing and exporting data between pandas and CSV file. 7. Create a Pandas DataFrame from a dictionary of lists. 8. Given a DataFrame, print all rows where a specific column’s value is greater than 50. 9. Create a DataFrame and rename all the columns. 10. Given a DataFrame, calculate the sum of a specific column. 11. Create a DataFrame and drop a specific column. 12. Create a DataFrame and sort it by a specific column in descending order. 13. Add a new column to a DataFrame that contains the result of multiplying two existing columns. 14. Given a DataFrame, reset its index. 15. Group a DataFrame by a column and calculate the mean for each group. 16. Given a DataFrame, drop rows and columns 17. Extract the top 3 rows of a DataFrame where a specific column has the highest values. 18. Use head(),tail() function with Series and Dataframe 19. Slicing in Datafram and Series 20. Create Dataframe with all methods 21. Create a Series and print its index,vaues,dtype,shape,size,empty,name attribute. 22. Create series using list ,dictionary ,mathematical expression and ndarray. 23. Create a DataFrame and print its columns ,index,size shape,axis and ndim attribute. 24. Use iloc[],iat[] in dataframe, 25. Add new row and columns in dataframe.