How to read an csv file in python

Installing pandas and its dependencies in Anaconda is done as shown below:. With the installation of the pandas library complete, let us now learn how to read and write csv files in this library. Reading a csv file in the pandas library is very easy compared to other libraries because of its compact code structure.

Filename: students. Printing the DataFrame gives the desired output. We can see the difference in output when we use the methods as mentioned earlier. Also, the result obtained using the pandas library has the index starting from '0' rather than '1'.

The code for writing data into a CSV file is as shown below:. Moreover, the print df command changes to df. CSV files have tremendous use in the current data and information exchange scenario. Hence, if you understand their structure, composition, and usage, then you are ready to rule the programming world. The application of CSV files to assess data makes the operation increasingly efficient. When incorporated with programming languages like Python, the efficiency of these files increases manifolds in data manipulation, assessment and application.

There are other libraries available as well for the processing of CSV files in Python. Still, the most efficient and compact ones have been discussed in this article for the programmer to have the most efficient program.

Raghav Ganesh. Easy Normal Medium Hard Expert. Writing code in comment? Please use ide. Load Comments. What's New. Most popular in Python. More related articles in Python. After that we used the iterator object with for loop to iterate over remaining rows of the csv file. For each row it fetches the contents of that row as a dictionary and printed that list.

DictReader class has a member function that returns the column names of the csv file as list. Iterate over all the rows of students. As in this dictionary keys are column names and values are cell values for that column. So, for selecting specific columns in every row, we used column name with the dictionary object. Read specific columns by column Number in a csv file while iterating row by row. Iterate over all rows students. Python MongoDB. Python OpenCV.

Python Selenium. Python Tkinter. Python Kivy. Data Visualization. Python Examples and Quiz. Table of Contents. Improve Article. Save Article. Like Article. DictReader file.