Learn Python 100 days (Day 2)

import pandas as pd
import numpy as np
data=pd.DataFrame(np.random.randn(5,3),columns=['A','B','C'])
print(data.head(3))
print(data.tail(2))
data['Index']=['A','B','C','D','E']
data=data.set_index('Index')
data=data.reset_index()
print(data)
grouped_data=pd.DataFrame({
'Category':['A','B','C','D','E'],
'Values':[10,20,30,40,50],
'Price':[20,30,50,69,90]
})
print(grouped_data)
grouped_data.to_csv('/Users/testing/output1.csv', index=False, header=True)
print("csv file saved successfully")

Leave a Reply

Your email address will not be published. Required fields are marked *