Method 2 : Using csv.writerows()
To write a dictionary of list to CSV files, the necessary functions are csv.writer(), csv.writerows(). This method writes all elements in rows (an iterable of row objects as described above) to the writer’s file object.
Syntax
csvwriter.writerows(rows)
Example 1:
Python3
# import the csv package import csv # create a file called test.csv # and store it in a temporary variable with open ( 'test.csv' , 'w' ) as testfile: # pass the temp variable to csv.writer # function csvwriter = csv.writer(testfile) # pass the row values to be stored in # different rows csvwriter.writerows([[ 'row1' ], [ 'row2' ], [ 'row3' ], [ 'row4' ], [ 'row5' ], [ 'row6' ]]) |
Output:
Example 2:
Here we are going to create a csv file test.csv and store it in a variable as outfile.
Python3
# create a dictionary of list test = { 'Age' : [ 52 , 24 , 31 , 47 , 51 , 61 ], 'Sex' : [ 'F' , 'M' , 'M' , 'F' , 'F' , 'M' ], 'height' : [ 143 , 163 , 144 , 154 , 174 , 177 ], 'weight' : [ 77 , 66 , 59 , 53 , 71 , 63 ], } # create a csv file test.csv and store # it in a variable as outfile with open ( "test.csv" , "w" ) as outfile: # pass the csv file to csv.writer function. writer = csv.writer(outfile) # pass the dictionary keys to writerow # function to frame the columns of the csv file writer.writerow(test.keys()) # make use of writerows function to append # the remaining values to the corresponding # columns using zip function. writer.writerows( zip ( * test.values())) |
Output:
Python – Write dictionary of list to CSV
In this article, we will discuss the practical implementation of how to write a dictionary of lists to CSV.
We can use the csv module for this. The csvwriter file object supports three methods such as csvwriter.writerow(), csvwriter.writerows(), csvwriter.writeheader().
Syntax:
csv.writer(csvfile, dialect='excel')
Parameters:
- csvfile: A file object with write() method.
- dialect (optional): Name of the dialect to be used.