Writing a CSV with multiple variables

Question

I currently have two lists:

lat = [34.78, 34.82, 34.86, 34.92]
lon = [-86.02, -86.06, -86.10, -86.14]

I am trying to write a csv file that outputs them as lat/lon:

34.78, -86.02
34.82, -86.06
34.86, -86.10
34.92, -86.14

I tried using:

with open('lat_lon', 'w') as csvfile:
    writer=csv.writer(csvfile, delimiter=',')
    writer.writerow(lat)
    writer.writerow(lon)

But this gives me the lat values all in one row and the lon values in a separate row. Any ideas on how to correct this? Thanks!

Padraic Cunningham · Accepted Answer · 2016-03-27 21:01:08Z

5

You just need to zip and use writerows instead of writerow:

with open('lat_lon', 'w') as csvfile:
    writer=csv.writer(csvfile, delimiter=',')
    writer.writerows(zip(lat, lon))

answered Mar 27, 2016 at 21:01

Padraic Cunningham

181k30 gold badges264 silver badges327 bronze badges

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

Comments

DevShark · Accepted Answer · 2016-03-27 21:03:59Z

2

You're almost there, do this:

with open('lat_lon', 'w') as csvfile:
    writer = csv.writer(csvfile, delimiter=',')
    for la, lo in zip(lat, lon):
        writer.writerow([la, lo])

Or more concise (as pointed out above):

with open('lat_lon', 'w') as csvfile:
    writer = csv.writer(csvfile, delimiter=',')
    writer.writerows(zip(lat, lon))

edited Mar 27, 2016 at 21:03

answered Mar 27, 2016 at 20:58

DevShark

9,18810 gold badges36 silver badges68 bronze badges

2 Comments

user530873 Over a year ago

You snatched my answer while I was typing it!

DevShark Over a year ago

Sorry, this happens! :)

dark · Accepted Answer · 2016-03-27 21:02:31Z

1

import pandas as pd
lat = [34.78, 34.82, 34.86, 34.92]
lon = [-86.02, -86.06, -86.10, -86.14]

output = pd.DataFrame(lat, columns=['lat'])
output['lon'] = lon
output.to_csv('lat_lon', index=False)

answered Mar 27, 2016 at 21:02

dark

2562 silver badges13 bronze badges

Comments

Hun · Accepted Answer · 2016-03-27 21:06:20Z

0

The key point is zip(lat, lon). You can make the above answers more compact like this.

import csv
with open('lat_lon', 'w') as csvfile:
    csv.writer(csvfile).writerows(zip(lat, lon))

answered Mar 27, 2016 at 21:06

Hun

3,9972 gold badges17 silver badges16 bronze badges

Comments

Pawan Kumar · Accepted Answer · 2022-08-24 14:47:31Z

0

Please try this readymade example:

import csv
fileName = './fileName.csv' # modify both file name and path if required
def WriteToCSV(fileName, col_1, col_2, col_3):
    row = [col_1, col_2, col_3]
    with open(fileName, 'a', newline='') as f:  # create and/ or opening the csv file in append mode
        writer = csv.writer(f)
        writer.writerow(row)


col_1 = 'col_1'
col_2 = 'col_2'
col_3 = 'col_3'
WriteToCSV(fileName, col_1, col_2, col_3) # calling the function

Good luck.

edited Aug 24, 2022 at 14:47

answered Aug 24, 2022 at 14:44

Pawan Kumar

3791 gold badge2 silver badges12 bronze badges

Collectives™ on Stack Overflow

Writing a CSV with multiple variables

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related