Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 64 of 70

Importing/Exporting Data between CSV Files/MySQL and Pandas — Question 1

Back to all questions
1
Question

Question 1

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

Solution
import pandas as pd
data = {'Item': ['Apple', 'Banana', 'Orange', 'Grapes'],
        'Sales': [100, 150, 80, 120]}
df = pd.DataFrame(data)
df.to_csv('one.csv', index = False)
Output
Item,Sales
Apple,100
Banana,150
Orange,80
Grapes,120
Answer