pd.read_csv('file.csv'): Reads data from a CSV file into a DataFrame. pd.read_excel('file.xlsx'): Reads data from an Excel file. df.to_csv('output.csv', index=False): Writes DataFrame to a CSV file.

This cheat sheet gets you up to speed on the features ... If you want to summarize your spreadsheet data using a PivotTable, for example, type in something like summarize with pivot table.

1 Day GOOG -0.24% DJIA 0.28% S&P 500 0.40% Technology -0.21% ...

1 Day JPM -0.24% DJIA -0.01% S&P 500 0.40% Financial Services -0.37% ...