Informatics Practices
Ekam, a Data Analyst with a multinational brand has designed the DataFrame df that contains the four quarters' sales data of different stores as shown below :
| Store | Qtr1 | Qtr2 | Qtr3 | Qtr4 | |
|---|---|---|---|---|---|
| 0 | Store1 | 300 | 240 | 450 | 230 |
| 1 | Store2 | 350 | 340 | 403 | 210 |
| 2 | Store3 | 250 | 180 | 145 | 160 |
Answer the following questions :
(i) Predict the output of the following Python statement :
(a) print(df.size)
(b) print(df[1:3])
(ii) Delete the last row from the DataFrame.
(iii) Write Python statement to add a new column Total_Sales which is the addition of all the 4 quarter sales.
Answer
(i)
(a) print(df.size)
15
Working
The size attribute of a DataFrame returns the total number of elements in the DataFrame df.
(b) print(df[1:3])
Store Qtr1 Qtr2 Qtr3 Qtr4
1 Store2 350 340 403 210
2 Store3 250 180 145 160
Working
This statement uses slicing to extract rows 1 and 2 from the DataFrame df.
(ii)
df = df.drop(2)
Store Qtr1 Qtr2 Qtr3 Qtr4
0 Store1 300 240 450 230
1 Store2 350 340 403 210
(iii)
df['Total_Sales'] = df['Qtr1'] + df['Qtr2'] + df['Qtr3'] + df['Qtr4']
Store Qtr1 Qtr2 Qtr3 Qtr4 Total_Sales
0 Store1 300 240 450 230 1220
1 Store2 350 340 403 210 1303
2 Store3 250 180 145 160 735
Related Questions
A series object (say T1) stores the average temperature recorded on each day of a month. Write code to display the temperatures recorded on :
(i) first 7 days
(ii) last 7 days.
Series objects Temp1, Temp2, Temp3, Temp4 store the temperatures of days of week1, week2, week3, week4 respectively.
Write a script to
(a) print the average temperature per week.
(b) print average temperature of entire month.
Consider the following DataFrame df and answer any four questions from (i)-(v):
rollno name UT1 UT2 UT3 UT4 1 Prerna Singh 24 24 20 22 2 Manish Arora 18 17 19 22 3 Tanish Goel 20 22 18 24 4 Falguni Jain 22 20 24 20 5 Kanika Bhatnagar 15 20 18 22 6 Ramandeep Kaur 20 15 22 24 Write down the command that will give the following output :
roll no 6 name Tanish Goel UT1 24 UT2 24 UT3 24 UT4 24 dtype : object(a) print(df.max)
(b) print(df.max())
(c) print(df.max(axis = 1))
(d) print(df.max, axis = 1)
Consider the following DataFrame df and answer any four questions from (i)-(v):
rollno name UT1 UT2 UT3 UT4 1 Prerna Singh 24 24 20 22 2 Manish Arora 18 17 19 22 3 Tanish Goel 20 22 18 24 4 Falguni Jain 22 20 24 20 5 Kanika Bhatnagar 15 20 18 22 6 Ramandeep Kaur 20 15 22 24 The teacher needs to know the marks scored by the student with roll number 4. Help her identify the correct set of statement/s from the given options:
(a) df1 = df[df['rollno'] == 4]
print(df1)(b) df1 = df[rollno == 4]
print(df1)(c) df1 = df.[df.rollno = 4]
print(df1)(d) df1 = df[df.rollno == 4]
print(df1)