Python Tutorial: CSV Module – How to Read, Parse, and Write CSV Files

Hi, would i have to do csv_file.close()

Great video, good job!!

Changed in version 3.8 of Python: Returned rows are now of type dict

How would you perform formatting for the csv file, and how would you save it to a specific file?

When I feel lost in code I search in YouTube "Corey <my question>". It always helps. Thanks a lot.

Sir,
in this code

import csv

with open("new_data.csv", "w") as new_file:

csv_writer = csv.writer(new_file, delimiter=".")

csv_writer.writerow(["hi", "bye"])

csv_writer.writerow(["yes", "no"])

csv_writer.writerow(["good", "bad"])

print("see the file")

—————————————————–
file new_data.csv

hi.bye

yes.no

good.bad

👆👆👆👆👆👆👆

the new line is coming after each writerow()
why . . .. it should come like this
👇👇👇👇👇👇👇👇

hi.bye

yes.no

good.bad

When ever i write a csv file using python spaces get generated between the different list i write. How to fix?

So, a quick question..

Why dont we use regex for reading whole doc here (by .*? Etc)
if we can reach whole data in this way, why do we need csv methods?

amazing

Hi all, At 15.16, Corey talks about creating a new dict only for first name and last name. I didn't quite get that, Can someone please elaborate. Thank you

I have a CSV File with an extra column that has no Title. When I use the CSV.DictWrites, it throws me an error at fieldnames. How do i go about handling this.

Thank you AJ Styles 🙂

thanks brother <3 love from sri lanka

What to do when we only want say first 50 data not the whole.

I have a question. What if I want to create a new csv file from blank with randomly generated users ? Is it doable through modifying the lines of code of this tutorial ?

VERY NICE!

You are Awesome i used thes codes as a mad man .. I loved it

Gebze Teknik Üniversitesinden Selamlar…..

what can i do if the delimiter is in the string i want to save example:

delimiter = ,

and the email is = test,test@gmx.com

and I want to save it now = test,test@gmx.com,name,alter

then the test will be separated from test,test@gmx.com

How can I modify some data of my csv searching for key entered by keyboard?

Great video training. just what I was looking. What about a video on collecting frequencies from a csv file

When I write the code out you have at 15:42 I get a new csv file except, that there are new lines added in between every old line. So the amount of columns have doubled but every other one is empty.
I'm using Pycharm – community edition btw.

hi, can you help explain how to append new line into existing csv from python?

If you got an error, just put —> encoding="utf8"

why the " with open write file" has to be written intended with "with open read file"
thanks in Advance
a fan

Hey Corey, How're you doing?

I'm doing a csv generator for some performance tests. My code works fine for thousands of users, but when I try the same for millions of users execution becomes infinite.

Can you help me please?

can you make a video about pulling a CSV file data to fill a registration page?

Thank you so much!!
Very great way of teaching, however while trying the same approach i observed that my "csv file" is not read completely (Out of 800 rows around 300 rows are missing). following is the code

with open('BPU-A-073-00-upconversion.csv', 'r', newline='n') as input_data:

csv_reader = csv.DictReader(input_data, delimiter = 't')

for line in csv_reader:

x_axis = line['Wavelength']

y_axis = line['Intensity']

print(line)

Can anyone help me with this ? please!!

Thank you , Thank you , Thank you , … , Thank you

I am taking Harvard University's online CS50 course and I could understand JACK about CSV file till I saw this vid 😂 …. Thanks a lot man 👍

I need to write in the same file csv_reader but just needed to add new data on the last column with the same word each row. How?

Thank you for this video, it was amazing.
Can you please let me know how to write one element of row at one time in CSV file and not whole row at one go?

I would sell my soul to have you as a teacher for a day.

Some exercises you may insterested:
https://www.w3resource.com/python-exercises/csv/index.php#EDITOR

Thank you for the tutorial.Helped me a lot in my miniproject.