Informatics Practices
Consider the given DataFrame 'Genre' :
| No | Type | Code |
|---|---|---|
| 0 | Fiction | F |
| 1 | Non-fiction | NF |
| 2 | Drama | D |
| 3 | Poetry | P |
Write suitable Python statements for the following :
(i) Add a column called Num_Copies with the following data : [300, 290, 450, 760].
(ii) Add a new genre of type 'Folk Tale' having code as "FT" and 600 number of copies.
(iii) Rename the column 'Code' to 'Book_Code'.
Python Pandas
8 Likes
Answer
(i)
Genre['Num_Copies'] = [300, 290, 450, 760]
(ii)
Genre = Genre.append({'Type': 'Folk Tale', 'Code': 'FT', 'Num_Copies': 600}, ignore_index=True)
(iii)
Genre.rename(columns = {'Code': 'Book_Code'}, inplace = True)
Answered By
3 Likes
Related Questions
What is the output of the following code ?
d = {'col1': [1, 4, 3 ], 'col2': [6, 7, 8], 'col3': [9, 0, 1]} df = pd.DataFrame(d) print("Original DataFrame") print(df) print("New DataFrame :") dfn = df.drop(df.index[[1, 2]]) print(dfn)What is the output of the following code ?
data = {'age': [20, 23, 22], 'name': ['Ruhi', 'Ali', 'Sam']} df1 = pd.DataFrame(data, index=[1, 2, 3]) print("Before") print(df1) df1['Edu'] = ['BA', 'BE' , 'MBA'] print('After') print(dfl)Write a program in Python Pandas to create the following DataFrame batsman from a Dictionary :
B_NO Name Score1 Score2 1 Sunil Pillai 90 80 2 Gaurav Sharma 65 45 3 Piyush Goel 70 90 4 Karthik Thakur 80 76 Perform the following operations on the DataFrame :
(i) Add both the scores of a batsman and assign to column "Total".
(ii) Display the highest score in both Score1 and Score2 of the DataFrame.
(iii) Display the DataFrame.
Consider the following dataframe, and answer the questions given below:
import pandas as pd df = pd.DataFrame( { "Quarter1": [2000, 4000, 5000, 4400, 10000], "Quarter2": [5800, 2500, 5400, 3000, 2900], "Quarter3": [20000, 16000, 7000, 3600, 8200], "Quarter4": [1400, 3700, 1700, 2000, 6000]})(i) Write the code to find mean value from above dataframe df over the index and column axis.
(ii) Use sum() function to find the sum of all the values over the index axis.