Skip to content

Instantly share code, notes, and snippets.

@kaddynator

kaddynator/Making to_csv and read_csv consistent for pandas

Forked from sagarnanduunc/Making to_csv and read_csv consistent for pandas
Last active May 24, 2018 20:11
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kaddynator/f6ff272450754fb07063eca8136f8a02 to your computer and use it in GitHub Desktop.
Save kaddynator/f6ff272450754fb07063eca8136f8a02 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
import pandas as pd
##reading a csv file
df = pd.read_csv("PATH WHERE YOUR FILE IS SAVED/filename.csv", encoding='utf-8',lineterminator = '\n',index_col=0)
##writing a csv file
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')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment