Anjeev Singh Academy

Anjeev Singh Academy

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

Type C: Programming Practice/Knowledge-based Questions

1. Write a program to read details such as Items, and Sales made in a DataFrame and then store this data in a CSV file.


#Que – 1

import pandas as pd

Cars = {‘Item’:[‘Alto’, ‘Zen’, ‘Kia’, ‘Breeza’],

        ‘Sales_Made’ : [30000, 12000, 25000, 1500]}

df = pd.DataFrame(Cars)


df.to_csv(“D:\\PythonProg\\Class 12 IP\\Item.csv”)

2. Write a program to read data from a CSV file where separator character is ‘@’. Make sure that:
  • the top row is used as data, not as column headers.
  • only 20 rows are read into dataframe.


#Que – 2

import pandas as pd

df = pd.read_csv(“D:\\PythonProg\\Class 12 IP\\two.csv”, header = None, sep=’@’)


3. Write a program to get the following data in two DataFrame:
dfl df2   
Roll noNameRoll noMarks 1Marks 2Marks 3      
    1ABC    170    8075
     2DEF  260    6570 
. .   
. .   

Store these DataFrames as two separate tables in the same database.


#Que 3

import pandas as pd

import pymysql

from sqlalchemy import create_engine

stud = {‘RollNo’ : [1, 2, 3],

        ‘Name’ : [‘ABC’, ‘DEF’, ‘GHI’]}

marks = {‘RollNo’: [1, 2, 3],

         ‘Marks1’: [70, 60, 50],

         ‘Marks2’: [45, 65, 85],

         ‘Marks3’: [75, 85, 80]}

df1 = pd.DataFrame(stud)

df2 = pd.DataFrame(marks)

engine = create_engine(‘mysql+pymysql://root:MyPass@localhost/School’)

mycon = engine.connect()

df1.to_sql(‘Student’, mycon, if_exists = ‘replace’, index = False)

df1.to_sql(‘Marks’, mycon, if_exists = ‘replace’, index = False)

4. You have a database on MySQL namely school having three tables in it — Student, Subject, Teacher. Write a program to store these tables in three dataframes.


5. The Dataframe SDF stores the sales records of 100 salesmen. Write a program to store this as a table in the database namely “company” on MySQL.


6. Consider the SDF dataframe storing the sales records of 100 salesmen, write a program that stores only the first 25 rows of the dataframe in a table on MySQL database.


7. The sales table of the company database of MySQL stores the sales records of 100 salesmen. Write a program to load only those records in the dataframe which have made sales more than Rs 50000/-.


Sorry! You cannot copy content of this page. Please contact, in case you want this content.

Scroll to Top