# Class 12 Informatics Practices 065 Ch 4 Importing Exporting Data Between CSV Files MySQL and Pandas Sumita Arora Book Exercise Solution

#### Type B: Application-Based Questions

##### 1. Predict the output of following code fragments one by one. For every next code fragment, consider that the changes by previous code fragment are in place. That is, for code fragment (b), changes made by code fragment (a) are persisting; for (c), changes by (a) and (b) are persisting and so on.

(a) import pandas as pd

columns=[ 2015 ‘ , ‘2016’ , ‘2017’ , ‘2018’ ]

index=[ ‘Messi% Ronaldo’, ‘Neymar’, ‘Hazard’]

df = pd.DataFrame(columns = columns, index=index)

print (df)

df.to_csv(“c:\one.csv”)

Ans: Output

(b) df[‘2015’][‘Messi’]  = 12

df[‘2016’][‘Ronaldo’] = 11

df[‘2017’][‘Neymar’] = 8

df[‘2018’][‘Hazard’] = 16

print (df)

df.to_csv( “c:\two.csv”, sep = ‘@’ )

Ans: Output

(c) new_df = pd.read_csv(‘c:\one.csv’, index_col= 0)

print(new_df)

Ans: Output

print(new_df)

Ans: Output

(e) new_df = pd. read_csv( ‘c:\two.csv’)

print(new_df)

Ans: Output

(f) new_df = pd. read_csv( ‘c:\two.csv’, sep=’@’)

print(new_df)

Ans: Output

##### 2. Are the following two statements same? Why/Why not?

Ans: Yes, both are same, because by default in csv file the value of sep is comma , only.

##### 3. How are the following two codes similar or different? What output will they produce?

(i) df = pd.read_csv(“data.csv”, nrows = 5)

print(df)

print(df)

Ans: The first statement (i) reads only first five rows from csv file and store it in DataFrame df. While second statement (ii) reads all the rows from csv and store the same in the DataFrame df.

##### 4. What is the difference between following two statements?

(i) df.to_sql( ‘houses’, con = conn, if_exists = ‘replace’)

(ii) df.to_sql(‘houses ‘, con = conn, if_exists = ‘replace’, index = False)

Ans: Statement (i), creates a table named houses having one extra column named index, while Statement (ii), creates table named houses which does not have index column.

##### 5. Consider the following code when conn is the name of established connection to MySQL database.

Cars = { ‘Brand’ : [ ‘Alto’,’Zen’, ‘City’, ‘Kia’ ],

‘Price’ : [22000, 25000, 27000, 35000] }

df  = DataFrame(Cars, columns = [ ‘Brand’, ‘Price’])

df.to_sql(‘CARS’, conn, if_exists’ = replace’,  index = False)

What will be the output of following query if executed on MySQL.

SELECT * from CARS ;

Ans:  The table CARS haiving

##### 6. Consider following code when conn is the name of established connection to MySQL database.

sql = SELECT * from Sales where zone = “central”