Array into table in Python

Question

So I converted a CSV that has names in one column and values in the second column into two arrays, one array for the name and one array for the values. I want to convert this into a table that equates the two, so the first item in the name array is linked to the first item in the value. How do I go about doing this?

import csv

data = csv.reader(open('C:\\Users\\Grant\\Documents\\finalproject\\centers.csv', 'r'), delimiter=",", quotechar='|')
names, values = [], []

for row in data:
    names.append(row[0])
    values.append(row[1])

I've tried to turn it into a dictionary, using dict(zip(column1, zip(*column2))) but when i try and return the dictionary, nothing shows up, so i'm not sure if that is working. this is my code thus far import csv data = csv.reader(open('C:\\Users\\Grant\\Documents\\finalproject\\centers.csv', 'r'), delimiter=",", quotechar='|') column1, column2 = [], [] for row in data: column1.append(row[0]) column2.append(row[1]) centers = dict(zip(column1, zip(*column2))) print(centers) — meforprez2032
– meforprez2032, Commented Dec 2, 2017 at 20:09
comments don't format well for code, edit your question and put code in there, highlight the code and press {} to format — chickity china chinese chicken
– chickity china chinese chicken, Commented Dec 2, 2017 at 20:11

paho · Accepted Answer · 2017-12-02 20:10:12Z

2

names = ["a", "b", "c"]
values = [1, 2, 3]
for n, v in zip(names, values):
    print("{} = {}".format(n, v))

answered Dec 2, 2017 at 20:10

paho

1,27210 silver badges13 bronze badges

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

2 Comments

meforprez2032 Over a year ago

Ah this is what I was looking for. Thank you! sorry for my poor asking of the question, i'm super new to the site and coding in general

paho Over a year ago

Don't worry about it. Everyone has to start somehow :). (Would you mind accepting my answer as correct? ^^)

Sayan Sil · Accepted Answer · 2017-12-02 20:19:25Z

2

Since you say table I would suggest you go with dataframes by pandas.

Assuming your name list to be names and value list to be values,

You could have something like:

data = {'names': names, 'values': values}
df = pandas.DataFrame(data=data)

Of course you have to import pandas first.

Which will give you a "table" (or dataframe?) like:

         names          values
0      Byakuya           500
1     Kenpachi           600
2          Kon           50

Further read here.

edited Dec 2, 2017 at 20:19

answered Dec 2, 2017 at 20:11

Sayan Sil

6,1153 gold badges20 silver badges32 bronze badges

Collectives™ on Stack Overflow

Array into table in Python

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related