How to read a csv file in Python
In this article you will learn the best ways to read a csv file in Python – so you can use the data structure as you wish to!
Hey you programmer, ok? Let’s learn more about the csv structure in Python!
The csv structure has become predominant in data files
Especially when we are talking about Data Science, data set files usually come in the csv extension
Therefore, learning how to read and handle these files with Python is of great help.
So with csv library we can read csv files with Python
Let’s see a practical example:
import csv with open('flights.csv', newline='') as csvfile: spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|') for row in spamreader: print(', '.join(row))
This way you will be able to print all your lines from the csv file
The ”with” statement tries to open the file, which here in the example we use flights.csv
We assign the file to the csv file variable, and then use the reader method on it, so that the file can be read
In the for loop structure, we print each line of the csv file
Or rather, we print the lines according to the delimiter
In this article we learned how to read a csv file in Python
We use the csv library, which is from Python itself and helps a lot when reading files that have the comma-separated values pattern
It is important to remember that the library is very complete, I suggest you look at its documentation to learn the other methods, which are essential
Do you want to learn more about Python? Click here!