Skip to content

Instantly share code, notes, and snippets.

@joncasdam

joncasdam/pandas_csv_excel_conversion

Created September 18, 2015 03:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save joncasdam/cf6828726596110d1485 to your computer and use it in GitHub Desktop.
Save joncasdam/cf6828726596110d1485 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pandas_csv_excel_conversion
#!/usr/bin/env python
# coding: utf-8
import pandas as pd
if conversion_type == 'csv_to_excel':
input_file = pd.read_csv(input_file)
input_file.to_excel(output_file)
elif conversion_type == 'excel_to_csv';
input_file = pd.read_excel(input_file)
input_file.to_csv(outpu_file)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment