python - How to loop through a csv file and only when it encountered a specific word save it into a list?

Question

Closed. This question needs to be more focused. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65927438/how-to-loop-through-a-csv-file-and-only-when-it-encountered-a-specific-word-save

Answer 1

You can read this using json.

import json

with open('txtfile1.txt') as input:
    data = input.read()
#Select the part where the dictionary start (after "rows":)
nesteddict = json.loads(data[(data.find('rows')+6):])
finallist = []
for x in nesteddict:
    sublist = []
    sublist.append(x['c'][0]['v'])
    sublist.append(x['c'][2]['f'])
    sublist.append(x['c'][5]['v'])
    finallist.append(sublist)

This will output

[['Albania', '2020-09-01', -0.503875968992248], ['Albania', '2020-09-02', -0.358695652173913], ['Albania', '2020-09-03', -0.302083333333333], ['Albania', '2020-09-04', -0.135922330097087], ['Albania', '2020-09-05', -0.436170212765957]]