boto s3 - write a csv file using array

Question

I want to upload a file to s3 without writing the file on my local system, so I am using set_contents_from_string of boto library. I am able to upload this file back to s3.

But how to write an array to a csv file using boto library.

arrlist = [[2, 'jack'], [3, 'john'], [4, 'robert']]
file_name = "test.csv" 
k = Key(bucket, file_name)
k.set_contents_from_string(arrlist)

Its not accepting array, any help how can I achieve this?

Shuwn Yuan Tee · Accepted Answer · 2018-03-13 06:48:24Z

2

First, turn the array into multi-lines string.

arrlist = [[2, 'jack'], [3, 'john'], [4, 'robert']]

i = 0
multiLine = ""

for item in arrlist:
    newLine = ','.join(map(str, item))

    if (i > 0) {
        multiLine = multiLine + '\n'
    }
    multiLine = multiLine + newLine
    i++

file_name = "test.csv" 
k = Key(bucket, file_name)
k.set_contents_from_string(multiLine)

The output multiLine, which is written to file will be like:

2,jack
3,john
4,robert

Hope this help!

answered Mar 13, 2018 at 6:48

Shuwn Yuan Tee

5,8086 gold badges34 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

boto s3 - write a csv file using array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related