String in for loop Python

Question

I want a string column of location values (for example Amsterdam, London, Paris) included in my dataset that already has 2 columns with only integer values. I don't know how to include it with a for loop.

My code looks like this:

    with open(output_file_path, 'w') as csvfile: 
        csv_writer = csv.writer(csvfile, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
        csv_writer.writerow(['timestamp', 'id', 'integercolumn1', 'integercolumn2'])

        for i in range(100):
            csv_writer.writerow([timestamp, 'demo-{}'.format(i), random.randint(0, 75), random.randint(4, 10), ])

The table/dataset looks now like this:

timestamp | ID | integercolumn1 | integercolumn2 | 
2020-1    | 1  | 32             | 25             |
2020-1    | 2  | 45             | 14             |

But I want something like this. Thus random location also included

timestamp | ID | integercolumn1 | integercolumn2 | location
2020-1    | 1  | 32             | 25             | London
2020-1    | 2  | 45             | 14             | Paris

Questions seeking debugging help ("why isn't this code working?") should include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it as formatted text in the question itself. Questions without a clear problem statement are not useful to other readers. See: minimal reproducible example. — MattDMo
– MattDMo, Commented Dec 10, 2020 at 15:00

Sonia Samipillai · Accepted Answer · 2020-12-10 15:12:18Z

1

can you have a list of locations and randomly select from the list like below.Is this what you looking for?

location = ['Paris','London']

with open('test', 'w') as csvfile: 
        csv_writer = csv.writer(csvfile, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
        csv_writer.writerow(['timestamp', 'id', 'integercolumn1', 'integercolumn2','location'])
for i in range(10):
    csv_writer.writerow(['demo-{}'.format(i), random.randint(0, 75), 
    random.randint(4, 10), location[random.randint(0, 1)]])

answered Dec 10, 2020 at 15:12

Sonia Samipillai

6206 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

String in for loop Python

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