Skip to content

Instantly share code, notes, and snippets.

@sagarnanduunc

sagarnanduunc/Making to_csv and read_csv consistent for pandas

Created March 28, 2018 03:37
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save sagarnanduunc/b88a8fdf6dd535f0d1c466936aac97d5 to your computer and use it in GitHub Desktop.
Save sagarnanduunc/b88a8fdf6dd535f0d1c466936aac97d5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Making to_csv and read_csv consistent for pandas
# This works in MACs
# Dataframe can also be used in R
df.to_csv("PATH WHERE YOU WANT TO SAVE YOUR FILE/filename.csv",quoting=csv.QUOTE_NONNUMERIC, date_format='%Y-%m-%d %H:%M:%S', encoding='utf-8',line_terminator = '\n')
df = pd.read_csv("PATH WHERE YOUR FILE IS SAVED/filename.csv", encoding='utf-8',lineterminator = '\n',index_col=0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment