NCERT solutions for इन्फोर्मेटिक्स प्रैक्टिसिज़ [इंग्रजी] इयत्ता १२ chapter 3 - Data Handling using Pandas - II [Latest edition]

Can you write a shortened code to get the output of the program?

>>> dfRaman[['Maths','Science','S. St','Hindi','Eng']].sum()

>>> dfRaman[['Maths','Science','S. St','Hindi','Eng']].sum(axis=1)

Write the python statements to print the sum of the english marks scored by Mishti.

Try to write a short code to get the above output. Remember to print the relevant headings of the output.

Slicing of the DataFrame to get only the marks

Average of marks obtained by Zuhaire in all Unit Tests

Find the median of the values of the rows of the DataFrame.

Calculate the mode of marks scored in Maths.

Find the variance and standard deviation of the following scores on an exam: 92, 95, 85, 80, 75, 50.

Write the python statements to print average marks in Science by all the students in each UT.

Consider the data of unit test marks given at program, write the python statements to print name wise UT marks in mathematics.

Write the statement to install the python connector to connect MySQL i.e. pymysql.

Explain the difference between pivot() and pivot_ table() function?

What is SQLAlchemy?

Can you sort a DataFrame with respect to multiple columns?

What are missing values?

What are the strategies to handle missing values?

Define the following term.

Median

Define the following term.

Standard

Define the following term.

Deviation

Define the following term.

variance

What do you understand by the term MODE? Name the function which is used to calculate it.

Write the purpose of data aggregation.

Explain the concept of GROUP BY with help on an example.

Write the steps required to read data from a MySQL database to a DataFrame

Explain the importance of reshaping of data with an example.

Why estimation is an important concept in data analysis?

Assuming the given table: Product. Write the python code for the following:

1. To create the data frame for the above table.
2. To add the new rows in the data frame.
3. To display the maximum price of LG TV.
4. To display the Sum of all products.
5. To display the median of the USD of Sony products.
6. To sort the data according to the Rupees and transfer the data to MySQL.
7. To transfer the new dataframe into the MySQL with new values.

Write the python statement for the following question on the basis of given dataset:

1. To create the above DataFrame.
2. To print the Degree and maximum marks in each stream.
3. To fill the NaN with 76.
4. To set the index to Name.
5. To display the name and degree wise average marks of each student.
6. To count the number of students in MBA.
7. To print the mode marks BCA.

Solved Case Study based on Open Datasets.

Following are the exercises to analyse the data.

1. Load auto-mpg.data into a DataFrame autodf.
2. Give description of the generated DataFrame autodf.
3. Display the first 10 rows of the DataFrame autodf.
4. Find the attributes which have missing values. Handle the missing values using following two ways:
   1. Replace the missing values by a value before that.
   2. Remove the rows having missing values from the original dataset.
5. Print the details of the car which gave the maximum mileage.
6. Find the average displacement of the car given the number of cylinders.
7. What is the average number of cylinders in a car?
8. Determine the no. of cars with weight greater than the average weight.