Creating csv file with python code

Question

I'm not too sure how to make a csv file with my current python code. Don't get me wrong, I don't want someone to do all this for me, I just want help getting started on.

My Code

I want the csv file to record the Name, Gender, DOB, Measurement, Weight, Height and their . Just a reminder that I don't want people to do the whole code for me, just want to get started.

Boa · Accepted Answer · 2016-03-10 04:22:06Z

4

If the problem is actually generating the CSV, one variant is the CSV module.

Create a list of column headers. For example:

fieldnames = ['Name', 'Gender', 'DOB', 'Measurement', 'Weight', 'Height']

Get your data into a list of dicts, with each key corresponding to a header field. For example, something like:

data = [{'Name': 'James', 'Gender': 'M', 'DOB': [some DOB], ...},
        {'Name': 'Dave', 'Gender': 'M', 'DOB': [some DOB], ...},
        ...]

Write your header and data:

with open('data.csv', 'w') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    writer.writeheader()

    for cur_dict in data:
        writer.writerow(cur_dict)

edited Mar 10, 2016 at 4:22

answered Mar 10, 2016 at 4:16

Boa

2,7071 gold badge25 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mta · Accepted Answer · 2016-03-10 06:07:49Z

0

Exactly as Diyi Wang said, here is a snippet of that document :

import csv
with open('eggs.csv', 'wb') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=' ', quotechar='|', quoting=csv.QUOTE_MINIMAL)
    spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
    spamwriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])

From: https://docs.python.org/2/library/csv.html#csv.writer

edited Mar 10, 2016 at 6:07

mta

134 bronze badges

answered Mar 10, 2016 at 4:14

Subhransu Majhi

111 bronze badge

Collectives™ on Stack Overflow

Creating csv file with python code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related