Skip to content

Instantly share code, notes, and snippets.

@veeenu

veeenu/csv_reader_test.py

Last active October 24, 2018 10:04
Show Gist options
  • Save veeenu/b3f46e802e4da884b8f7880e030e9995 to your computer and use it in GitHub Desktop.
Save veeenu/b3f46e802e4da884b8f7880e030e9995 to your computer and use it in GitHub Desktop.
Download ZIP
Pandas `read_csv` C engine exception
Raw
csv_reader_test.py
import pandas as pd
pd.read_csv('ok.csv', header=[0, 1], index_col=0)
pd.read_csv('not_ok.csv', header=[0, 1], index_col=0)
Raw
not_ok.csv
SPX INDEX SPX INDEX SPX INDEX SPX INDEX SPX INDEX SPX INDEX
date open high low close volume open_interest
Raw
ok.csv
SPX INDEX SPX INDEX SPX INDEX SPX INDEX SPX INDEX SPX INDEX
date open high low close volume open_interest
2018-10-24 10.000 12.000 8.000 10.000 NaN NaN
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment