Page 259 - Robotics and AI class 10
P. 259
[[201 194 193]
[182 178 175]
[168 165 164]
…
[128 120 117]
[126 116 112]
[124 114 109]]
6. Reading a .csv file into a Pandas DataFrame .
Ans. import pandas as pd
df = pd.read_csv('friends.csv') # Read the CSV file into a DataFrame
print(df) # Display the DataFrame
Output:
SOL Adm No Name Percentage
0 111 Aman Verma 87
1 152 Vartika Sen 89
2 123 Shipra Virmani 80
3 214 Jyoti Batra 78
4 167 Ayana Joshi 92
5 142 Ekta Mishra 76
6 216 Mansi Kapoor 72
7 147 Shivani Monga 81
8 181 Poonam Gupta 67
7. Reading json data into a Pandas DataFrame.
Ans. import pandas as pd
df = pd.read_json('mydata.json') # Read the JSON file into a DataFrame
print(df) # Display the DataFrame
Output:
# Courses Fee Duration
#0 Spark 25000 50 Days
#1 Pandas 20000 35 Days
#2 Java 15000 40 days
8. Basic data analysis on data with info(), tail(), head() commands.
Ans. import pandas as pd
# Sample dataset of student information
data = {
'Name': ['Reena', 'Iqbal', 'Jacob', 'Eshaan', 'Sneha'],
'Age': [15,16,14,17,16],
Assignment 257

