Python Forum
Helps with reading csv file - 3 methods
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Helps with reading csv file - 3 methods
#1
Hi Everyone,
I try 3 different ways to read csv data and only 1 works.
Can you please help to fix the not working code?
Thank you so much.
HHC

#Working
import pandas as pd
df1 = pd.read_csv (r'C:\temp\text.csv')
print(df1)

#Not working
with open("C:\temp\text.csv", "r") as text:
    print(text)

#Not working
f = open("C:\temp\text.csv", "r")
print(f.read())
Reply
#2
What does "not working" mean? What do you expect it to do? What does it do instead? Do you get error messages? What is the output?

The second two should just show you the content of file.
Reply
#3
One additional note to add to bowlofred's list.
Please include a small sample of the CSV data.
Reply
#4
Hi,
The text.csv has 2 columns:
id info
1, From: abc to xyz
2, From abc yxz

I want to print the data out.

The second code error is:
with open("C:\temp\text.csv", "r") as text:
OSError: [Errno 22] Invalid argument: 'C:\temp\text.csv'

The third code error is:
f = open("C:\temp\text.csv", "r")
OSError: [Errno 22] Invalid argument: 'C:\temp\text.csv'
Reply
#5
note the escape sequence \t in the file name. use raw string like in the first snippet, escape the back-slash, e.g. \\ or use forward slash.

Also, in the second snippet you want to print(text.read()). Instead you can iterate over file and print line by line
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Sad problems with reading csv file. MassiJames 3 558 Nov-16-2023, 03:41 PM
Last Post: snippsat
  Reading a file name fron a folder on my desktop Fiona 4 851 Aug-23-2023, 11:11 AM
Last Post: Axel_Erfurt
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,046 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Reading a file JonWayn 3 1,057 Dec-30-2022, 10:18 AM
Last Post: ibreeden
  Reading Specific Rows In a CSV File finndude 3 936 Dec-13-2022, 03:19 PM
Last Post: finndude
  Excel file reading problem max70990 1 865 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Replace columns indexes reading a XSLX file Larry1888 2 951 Nov-18-2022, 10:16 PM
Last Post: Pedroski55
  Failing reading a file and cannot exit it... tester_V 8 1,752 Aug-19-2022, 10:27 PM
Last Post: tester_V
  Reading .csv file doug2019 4 1,658 Apr-29-2022, 09:55 PM
Last Post: deanhystad
Question Pandas : How to create an algorithm that helps me improve results and creating new co Smordy 8 2,199 Apr-10-2022, 10:28 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020