Python csv file to dictionary

I want to save it in finalprojdata. If you want to output python values, you may be better off using a repr rather than str result. Add a comment.

Active Oldest Votes. Improve this answer. Tony Tony 1, 1 1 gold badge 10 10 silver badges 36 36 bronze badges. DictReader csvfile for row in reader: for k,v in row. Alpesh Valaki Alpesh Valaki 1, 1 1 gold badge 12 12 silver badges 36 36 bronze badges. Ed Morton Ed Morton k 17 17 gold badges 66 66 silver badges bronze badges. Mukund he tagged the question with awk - that means he's asking for an awk program.

Just because his failed attempt was a python script doesn't mean that's all he can use. Sign up or log in Sign up using Google. Sign up using Facebook. Python has a csv module that contains all sorts of utility functions to manipulate CSV files like conversion, reading, writing, and insertion. To convert a CSV File into a dictionary, open the CSV file and read it into a variable using the csv function reader , which will store the file into a Python object.

The header parameter specifies that the headers are explicitly passed or declared by another parameter. In this case, the first column of index 0 is the labels. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

CSV raw data is not utilizable in order to use that in our Python program it can be more beneficial if we could read and separate commas and store them in a data structure. We can convert data into lists or dictionaries or a combination of both either by using functions csv. Skip to content. Change Language. Related Articles. Table of Contents. Improve Article.