Class 11 IP Chapter 11 Back Exercise Part A Solutions Sumita Arora New Syllabus

/ Listing11IPSA, Uncategorized / By
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