Reading .csv file

[doug2019]

Hi! Could someone give me a hand? I'm having trouble creating code to read a .csv file in pandas. With .xlsx file I know how to create it. Below is the print of the script and csv example.

   

   

Larz60+ write Apr-28-2022, 06:31 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Please use BBCode tags for code, not images.

[deanhystad]

Backslash is the start of an escape character. You can use "\\", use a "raw" string for the filename, or better yet, not specify the file path at all.

from io import StringIO
import pandas as pd

stringdata = StringIO("""
Start Date;End Date
2019-10-01;2019-10-05
2019-12-15;2020-01-05
2020-02-20;2020-02-25
""")

# Change comment to use string dta or data file
#df = pd.read_csv(stringdata)
df = pd.read_csv("data.csv")
print(df)

Output:
     Start Date;End Date
0  2019-10-01;2019-10-05
1  2019-12-15;2020-01-05
2  2020-02-20;2020-02-25

Notice that there is only 1 column. You'll need to specify the separator is ";" to get two columns.

[doug2019]

Nothing worked. I tried with import csv, I put r before the path file, \\ as a separator, encoding: "utf-8" and sep: ";", but it didn't work. Could it be some VS Code configuration?

[snippsat]

The error in your image is clear,can make the error as a example.

>>> path = 'C:\Users'
  File "<interactive input>", line 1
    path = 'C:\Users'
                     ^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

Can not use \ in path because escape character(problem here is \U).
So to fix all this works.

>>> path = r'C:\Users'
>>> path = 'C:\\Users'
>>> path = 'C:/Users'

[deanhystad]

VSCode is an editor. Your problem is your code. Please post some of the things you tried.