Class 11 IP Chapter 11 Python Pandas II Dataframes and Other Operations Solutions Sumita Arora New Syllabus

/ Uncategorized / By

Exercise 11.1

Back Exercise Part A Solutions

3. How would you add a new column namely ‘val’ to a dataframe df that has 10 rows in it and has columns as ‘Item’, ‘Qty’, ‘Price’ ? You can choose to put any values of you choice.
1. Given a dataframe df as shown below :
...
click here for answer
2. Write code statements to list the following, from a dataframe namely sales.
import pandas ...
click here for answer
4. Write code statements for a dataframe df for the following :
...
click here for answer
5. Give two identical dataframes Salesl6 and Salesl7. But Salesl7 has some values missing. Write code so that Salesl7 fills its missing values from corresponding entries of Salesl6.
import pandas ...
click here for answer
6. Write code that just produces single True/False as a result for the presence of missing values in whole dataframe namely df.
...
click here for answer
7. A dataframe Stu stores details like ‘Name’, ‘Class’, ‘Subject_ld’ for 10 students and another dataframe Marks stores details like ‘Subject_Id’ and ‘Avgmarks’. Write code so that two dataframes combine data on the basis of common Subject id.
import pandas ...
click here for answer
8. Write code to print information about a series object.
...
click here for answer
9. Write code to get summary details about a dataframe object for all its columns including numeric and string columns.
...
click here for answer
10. The head( ) and tail( ) extract rows or columns from a dataframe. Explain.
...
click here for answer
11. Why does Python change the datatype of a column as soon as it stores an empty value (NaN) even though it has all other values stored as integer ?
...
click here for answer

Back Exercise Part B Solutions

3. From the dataframes created in previous question, write code to
1. What advantages does dataframe offer over series datastructure ? If you have similar data stored in multiple series and a single dataframe, which one would you prefer and why ?
...
click here for answer
2. Given :
...
click here for answer
4. Predict the output of following code (it uses above given dictionary my_di)
...
click here for answer
5. Consider the same dictionary my_di in previous question, what will be the output produced by following code ?
...
click here for answer
7. Assume that required libraries (panda and numpy) are imported and dataframe df2 has been created as per questions 4 and 5 above. Predict the output of following code fragment :
df2["IQ"] = ...
click here for answer
6. Assume that required libraries (panda and numpy) are imported and dataframe df2 has been created as per questions 4 and 5 above. Predict the output of following code fragment :
print(df2["weight"]) print(df2.weight[’Tim’]) ...
click here for answer
8. Assume that required libraries (pandas and numpy) are imported and dataframe df2 has been created as per questions 4 and 5 above. Predict the output produced by following code fragment :
df2["College"] = ...
click here for answer
9. Assume that required libraries (pandas and numpy) are imported and dataframe df2 has been created as per questions 4 and 5 above. Predict the output produced by following code fragment :
print(df2.loc["Jiya"]) print(df2.loc ...
click here for answer
10. Assume that required libraries (panda and numpy) are imported and dataframe df2 has been created as per questions 4 and 5 above. Predict the output produced by following code fragment :
print(df2[df2["age"] > ...
click here for answer
11. What will be the output produced by following code ?
...
click here for answer
12. Predict the output of the script given below:
...
click here for answer
13. Predict the output of the script given below :
...
click here for answer
14. Why does following code cause error ?
import pandas ...
click here for answer
15. Given the two dataframes as :
...
click here for answer
16. Four series objects Tempi, Temp2, Temp3 and Temp4 store the temperatures of week1, week2, week3 and week4 respectively. Create a dataframe from these four series objects where the indexes should be ‘Sunday’, ‘Monday’, … , ‘Saturday’, and columns should be ‘Week1’, ‘Week2’, ‘Week3’ and ‘Week4’.
import pandas ...
click here for answer
17. From the dataframe object created in previous question, write a script to calculate :
...
click here for answer
18. What will the output produced by following code considering a dataframe object mem whose contents are shown below :
...
click here for answer
19. Consider following code that creates two dataframes :
import pandas ...
click here for answer
20. Consider the orel and ore2 dataframes given in previous questions. What will the result produced by following statements ?
...
click here for answer
21. Consider following dataframes, namely Sprices1 and Sprice2 storing prices closing 1 year apart.
...
click here for answer

Back Exercise Part C Solutions

[pt_view id=”da617c2pd1″