Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
write to csv file problem
#9
(Nov-07-2023, 03:55 PM)deanhystad Wrote: What is "flights" when there are no matching flights? When you know that you should know why your code does not identify that case.

sometimes flights doesnt even get executed because the return of the save_ent function is of type None. i have tried checking the variable that i write to the csv file and sometimes it is None. I have tried writing it using pandas Dataframe as below

d_f=pd.DataFrame(new_list)
d_f.to_csv("flight_data.csv",index=False,mode="a")
i have also tried using the csv framework like

wth open("flight_data.csv","a")as file:
    writer=csv.writer(file)
    writer.writerrows(new_list)
in either occassion does it write or print out a message. In most situations i had a

Output:
0 ""
being appended to my csv file or no ouput whatsoever. I have also tried both writer.writerows or writer.writerow to no avail. the weird thing is that the names of my rows are always there its the values that never get written
Reply


Messages In This Thread
write to csv file problem - by jacksfrustration - Nov-03-2023, 03:55 PM
RE: write to csv file problem - by noisefloor - Nov-03-2023, 05:05 PM
RE: write to csv file problem - by deanhystad - Nov-03-2023, 05:54 PM
RE: write to csv file problem - by deanhystad - Nov-03-2023, 10:22 PM
RE: write to csv file problem - by jacksfrustration - Nov-03-2023, 10:47 PM
RE: write to csv file problem - by deanhystad - Nov-04-2023, 05:43 AM
RE: write to csv file problem - by jacksfrustration - Nov-07-2023, 02:31 PM
RE: write to csv file problem - by deanhystad - Nov-07-2023, 03:55 PM
RE: write to csv file problem - by jacksfrustration - Nov-07-2023, 04:32 PM
RE: write to csv file problem - by deanhystad - Nov-07-2023, 06:30 PM
RE: write to csv file problem - by jacksfrustration - Nov-07-2023, 08:58 PM
RE: write to csv file problem - by deanhystad - Nov-09-2023, 01:56 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  What does .flush do? How can I change this to write to the file? Pedroski55 3 331 Apr-22-2024, 01:15 PM
Last Post: snippsat
  Last record in file doesn't write to newline gonksoup 3 512 Jan-22-2024, 12:56 PM
Last Post: deanhystad
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,633 Nov-09-2023, 10:56 AM
Last Post: mg24
  How do I read and write a binary file in Python? blackears 6 7,382 Jun-06-2023, 06:37 PM
Last Post: rajeshgk
  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
  Read text file, modify it then write back Pavel_47 5 1,728 Feb-18-2023, 02:49 PM
Last Post: deanhystad
  how to read txt file, and write into excel with multiply sheet jacklee26 14 10,507 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  How to write in text file - indented block Joni_Engr 4 6,583 Jul-18-2022, 09:09 AM
Last Post: Hathemand
  Upgrading from 2 to 3 and having file write problems KenHorse 2 1,547 May-08-2022, 09:47 PM
Last Post: KenHorse
  Cursor write 3rd file empty paulo79 3 1,939 Mar-10-2022, 02:51 PM
Last Post: DeaD_EyE

Forum Jump:

User Panel Messages

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