Python pandas read_csv with " delimiter

Question

I am trying to read in a csv file of stock data which is set out as follows:

        Date           "Open           "High           "Low            "Close          "Volume         "Open Interest  "Ticker

  1999-1-21"       33.07198"       33.60028"       32.96632"       33.07198"          36201"             39"             CS
  1999-1-22"       32.01537"       32.22669"       32.01537"       32.01537"           3667"             38"             CS
  1999-1-25"       32.12103"       32.75499"       32.12103"       32.12103"           2366"             38"             CS
  1999-1-26"       32.01537"       32.01537"       32.01537"       32.01537"          14315"             38"             CS

etc

The delimiter is clearly " but when I run the below code it just reads it in as one column and includes the " in the data.

import pandas as pd

stock1 = 'CS.csv'

x = pd.read_csv(stock1, delimiter='"')

Any help would be appreciated.

cs95 · Accepted Answer · 2018-09-30 02:24:31Z

2

The python parser can parse CSVs with complex regex patterns as the delimiter.

df = pd.read_csv(filename, sep=r'\s*"\s*', engine='python')
print(df)
        Date      Open      High       Low     Close  Volume  Open Interest Ticker
0  1999-1-21  33.07198  33.60028  32.96632  33.07198   36201             39     CS
1  1999-1-22  32.01537  32.22669  32.01537  32.01537    3667             38     CS
2  1999-1-25  32.12103  32.75499  32.12103  32.12103    2366             38     CS
3  1999-1-26  32.01537  32.01537  32.01537  32.01537   14315             38     CS

answered Sep 30, 2018 at 2:24

cs95

406k106 gold badges744 silver badges797 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python pandas read_csv with " delimiter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related