Python: write data to specific cell

Question

I need some data and I need write it to one column but to different string

df = pd.DataFrame()
list1 = ['111', '333', '555', '777', '8888']
list2 = [1, 5, 56, 44, 2]
with open('hh1.csv', 'a') as f:
    writer = csv.writer(f)
    for (elem1, elem2) in zip(list1, list2):
        writer.writerow([elem1])

I want to write elem1 to cell with number elem2, i mean 111 in A1, 333 in A5 etc. How can I do that?

@Jean-FrançoisFabre it will be empty, but I need to write it in loop and numbers may be not in order — Petr Petrov
– Petr Petrov, Commented Feb 4, 2017 at 13:27

Jean-François Fabre · Accepted Answer · 2017-02-04 16:39:26Z

1

So initialize your list with empty values according to list2 max index. Then, fill it according to list1,list2 indexes/values tuples using zip as you did in your attempt.

list1 = ['111', '333', '555', '777', '8888']
list2 = [1, 5, 56, 44, 2]
rows_to_write = [[""] for _ in range(max(list2))]
for i,v in zip(list2,list1):
    rows_to_write[i-1][0] = v

At this point rows_to_write is worth:

[['111'], ['8888'], [''], [''], ['333'], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], ['777'], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], [''], ['555']]

then write the rows in 1 instruction (don't append)

with open('hh1.csv', 'w',newline='') as f: # python 3
    csv.writer(f).writerows(rows_to_write)

This creates a single-row "sparse" csv file. (open('hh1.csv', 'wb') as f for python 2)

edited Feb 4, 2017 at 16:39

answered Feb 4, 2017 at 13:34

Jean-François Fabre♦

141k24 gold badges179 silver badges246 bronze badges

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

6 Comments

Petr Petrov Over a year ago

It write 111 to cell 1, 113, 225

Jean-François Fabre Over a year ago

it's not even possible. Those values are not in list2 range... oh, you have to use w mode not a !! rewrite the file from zero.

Petr Petrov Over a year ago

Can you say, but if I don't have a list with numbers, but get it in loop, can i write like this in loop?

Petr Petrov Over a year ago

I try to do that, but it don't write that

Jean-François Fabre Over a year ago

probably a newline issue. Check my edit on open of the .csv file

|

Collectives™ on Stack Overflow

Python: write data to specific cell

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related