Informatics Practices
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)
Python Pandas
2 Likes
Answer
Before
age name
1 20 Ruhi
2 23 Ali
3 22 Sam
After
age name Edu
1 20 Ruhi BA
2 23 Ali BE
3 22 Sam MBA
Working
The code utilizes the pandas library in Python to create a DataFrame named df1 using a dictionary data. The df1 DataFrame is printed, showing the initial data. Then, a new column 'Edu' is added to the DataFrame using df1['Edu'] = ['BA', 'BE' , 'MBA']. The updated DataFrame is printed.
Answered By
3 Likes
Related Questions
Assume that required libraries (panda and numpy) are imported and dataframe df2 has been created as per questions 17 and 18 above. Predict the output produced by following code fragment :
print(df2.loc["Jiya"]) print(df2.loc["Jiya", "IQ"]) print(df2.loc["Jiya":"Tim", "IQ":"College"]) print(df2.iloc[0]) print(df2.iloc[0, 5]) print(df2.iloc[0:2, 5:8])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)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'.
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.