<jupyter_start><jupyter_text>Data Input and OutputReading DataFrames from external sources using pd.read functions<jupyter_code>import numpy as np
import pandas as pd<jupyter_output><empty_output><jupyter_text>CSV CSV Input<jupyter_code>dataframe = pd.read_csv('train.csv')<jupyter_output><empty_output><jupyter_text>CSV Output<jupyter_code>dataframe.to_csv('train2.csv',index=False)    #If index=FALSE then csv does not store index values<jupyter_output><empty_output><jupyter_text>ExcelUsing Pandas, one can read excel files, however it can only import data. It does not fetch formulae or any formatting/images/macros and having such things in excel files can crash the python function to crash and not execute successfully.  Excel Input<jupyter_code>pd.read_excel('Consumer.xlsx',sheet_name='Data1')<jupyter_output><empty_output><jupyter_text>Excel Output<jupyter_code>dataframe.to_excel('Consumer2.xlsx',sheet_name='Sheet1')<jupyter_output><empty_output>
StarcoderdataJupyterStructuredCleanDedup