Python Forum
Thread Rating:
  • 1 Vote(s) - 2 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Issue with reading CSV file
#9
nnsatpute Wrote:I can't paste exact file.
You can do this
with open(datafile) as csvfile:
    s = csvfile.read(4096)
    print(repr(s))
Then paste the output in the forum.

nnsatpute Wrote:But when i am opening same file in Excel it is comma separated
If the file is comma separated, there is a problem with Number(10,2) because the comma must not be interpreted as a separating comma. Normally csv files avoid this by quoting "Number(10,2)". You need to know which quoting strategy is used and declare this in the dialect.
Reply


Messages In This Thread
Issue with reading CSV file - by nnsatpute - Dec-10-2018, 11:38 AM
RE: Issue with reading CSV file - by Gribouillis - Dec-10-2018, 12:46 PM
RE: Issue with reading CSV file - by nnsatpute - Dec-10-2018, 01:08 PM
RE: Issue with reading CSV file - by Gribouillis - Dec-10-2018, 03:19 PM
RE: Issue with reading CSV file - by woooee - Dec-10-2018, 04:34 PM
RE: Issue with reading CSV file - by nnsatpute - Dec-11-2018, 04:36 AM
RE: Issue with reading CSV file - by Gribouillis - Dec-11-2018, 06:01 AM
RE: Issue with reading CSV file - by nnsatpute - Dec-11-2018, 06:23 AM
RE: Issue with reading CSV file - by Gribouillis - Dec-11-2018, 06:35 AM
RE: Issue with reading CSV file - by nnsatpute - Dec-19-2018, 07:44 AM
RE: Issue with reading CSV file - by Gribouillis - Dec-19-2018, 08:39 AM
RE: Issue with reading CSV file - by nnsatpute - Dec-19-2018, 10:58 AM
RE: Issue with reading CSV file - by Gribouillis - Dec-19-2018, 12:08 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
Sad problems with reading csv file. MassiJames 3 731 Nov-16-2023, 03:41 PM
Last Post: snippsat
  Reading a file name fron a folder on my desktop Fiona 4 1,008 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,168 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Reading a file JonWayn 3 1,158 Dec-30-2022, 10:18 AM
Last Post: ibreeden
  Reading Specific Rows In a CSV File finndude 3 1,038 Dec-13-2022, 03:19 PM
Last Post: finndude
  Excel file reading problem max70990 1 931 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Replace columns indexes reading a XSLX file Larry1888 2 1,032 Nov-18-2022, 10:16 PM
Last Post: Pedroski55
  Failing reading a file and cannot exit it... tester_V 8 1,867 Aug-19-2022, 10:27 PM
Last Post: tester_V
  I have an issue with Netmiko Error reading SSH protocol banner omarhegazy 2 3,638 May-16-2022, 06:05 PM
Last Post: omarhegazy
  Reading .csv file doug2019 4 1,769 Apr-29-2022, 09:55 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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