Informatics Practices
(i) Consider the dataframe "EMP":
Name Basic Da Hra
E1 Sanya 9500 3000 2000
E2 Krish 7000 5000 1900
E3 Rishav 9650 1500 2100
E4 Deepak 7500 2000 2700
E5 Kriti 9200 1800 500
Give the output
EMP.iloc[1, 2]=8000
EMP.Hra = EMP.Hra + 200
print(EMP)
(ii) Write a Python statement to change the name 'Rishav' to 'Rishab' in the above dataframe.
Or
(Option for part ii only)
Write a Python statement to calculate the sum of Basic, Da, and Hra and assign it to the column 'Salary'.
Python Pandas
1 Like
Answer
Output
Name Basic Da Hra
E1 Sanya 9500 3000 2200
E2 Krish 7000 8000 2100
E3 Rishav 9650 1500 2300
E4 Deepak 7500 2000 2900
E5 Kriti 9200 1800 700
(ii)
EMP.loc[EMP['Name'] == 'Rishav', 'Name'] = 'Rishab'
Or
(Option for part ii only)
EMP['Salary'] = EMP['Basic'] + EMP['Da'] + EMP['Hra']
Output
Name Basic Da Hra Salary
E1 Sanya 9500 3000 2200 14700
E2 Krish 7000 8000 2100 17100
E3 Rishab 9650 1500 2300 13450
E4 Deepak 7500 2000 2900 12400
E5 Kriti 9200 1800 700 11700
Answered By
2 Likes
Related Questions
Consider the dataframe SHOP given below:
Item Qty City Price 101 Biscuit 100 Delhi 10 102 Jam 110 Kolkata 25 103 Coffee 200 Kolkata 55 104 Sauce 56 Mumbai 55 105 Chocolate 170 Delhi 25Write commands to:
(i) Write short code to show the information having city = "Delhi".
(ii) Calculate Qty * Price and assign to column 'Net_Price'.
(iii) Display Items of all rows.
Consider the following table named "Student":
RollNo Name Marks Grade Fees Stream 1 Mishra 30 C 6000 Commerce 2 Gupta 48 B 15000 Arts 3 Khan 66 A 4800 Science 4 Chaddha 24 C 12500 Commerce 5 Yadav 23 A 10000 Arts Write the SQL functions which will perform the following operations:
(i) To show the sum of fees of all students.
(ii) To display maximum and minimum marks.
(iii) To count different types of grades available.
(iv) Write a query to count grade-wise total number of students.
Consider the following table named "GARMENT".
GCODE GNAME SIZE COLOUR PRICE 111 T-Shirt XL Red 1400.234 112 Jeans L Blue 1600.123 113 Skirt M Black 1100.65 115 Trousers L Brown 1500.50 116 Ladies Top L Pink 1200.25 Write SQL queries using SQL functions to perform the following operations:
(i) Display the name and price after rounding off to one decimal place.
(ii) Display all Gname in upper case.
(iii) Display the last three characters from Gname.
(iv) Display the highest Gcode from the table GARMENT.
(v) Display the sum of all prices of size 'L'.
Write the SQL functions which will perform the following operations:
(i) To return the summation of all non-NULL values of a data set.
(ii) To extract a substring starting from a position with a specific length.
(iii) To convert a string to uppercase.
(iv) To return the year for a specified date.
(v) To round off a number to a specified number of decimal places.