pandas4.py

import pandas as pd

#df=pd.read_csv("stock_data.csv")

#For reading the csv file
#df=pd.read_csv("stock_data.csv",header=1) #it will skip the first row
#df=pd.read_csv("stock_data.csv",header=None,name=["tickers","eps","revenue","price","people"])
#df=pd.read_csv("stock_data.csv",nrows=3) #for reading only first 3 rows
#df=pd.read_csv("stock_data.csv",na_values=["not available","n.a"]) #replace not available and n.a with NaN


#For writing in the csv file
#df.to_csv("new.csv",index=False)
#print(df.columns)   #shows the column of the table
#df.to_csv("new_csv",columns=['tickers','eps']) #after this it will only contain the rows which are passed as a argument