123456789101112131415161718192021222324252627282930313233 |
- import csv
- import json
- if __name__ == '__main__':
-
- csv_file = r'device_monitor_80.csv'
- json_list_8 = []
- json_list_9 = []
-
- with open(csv_file, 'r') as file:
- reader = csv.reader(file)
- next(reader)
- for row in reader:
- json_data_8 = json.loads(row[7])
- json_data_9 = json.loads(row[8])
- for item in json_data_8:
- if 'record' in item['name']:
- json_list_8.append(item)
- for item in json_data_9:
- if 'record' in item['name']:
- json_list_9.append(item)
-
- print("Json List from column 8:")
- for record in json_list_8:
- print(record)
- print("\nJson List from column 9:")
- for record in json_list_9:
- print(record)
|