TECHONESPOT

All Tech at one spot

Assignement 2 

1. Write a program to generate a series of float numbers from 41.0 to 60.0 with an increment of 2.5 each.

2. Write a program to generate a series of 10 numbers with a scalar value of 44.
3. Create a data frame for examination results and display row labels, column labels data types of each column and the dimensions.
4. To display the shape (number of rows and columns) of the CSV file.
5. To display the first 5 and last 5 records from ‘student_result.csv’ file.
6. To modify the Percentage of student below 40 with NaN value in dataframe.
7. Write the statement in Pandas to find the highest percentage and also print the student’s name and percentage.
8. Find the sum of each column, or find the column with the lowest mean.
9. Locate the three largest values in a data frame.
10. Given a Series, print all the elements that are above the 75th percentile.
11. Create a dataframe quarterly sales where each row contains the item category,item name and expenditure.
12. Create a dataframe on e-commerce data and generate descriptive statistics.
13. Replace all negative values in a dataframe with a 0.