mirror of
https://github.com/hastagAB/Awesome-Python-Scripts.git
synced 2024-12-19 00:30:13 +00:00
32 lines
752 B
Python
32 lines
752 B
Python
|
import csv
|
||
|
|
import json
|
||
|
|
|
||
|
|
file_name = input("Provide the CSV filename without extension>> ")
|
||
|
|
|
||
|
|
try:
|
||
|
|
|
||
|
|
with open(file_name+'.csv') as f:
|
||
|
|
|
||
|
|
reader = csv.reader(f, delimiter=',')
|
||
|
|
titles = []
|
||
|
|
temp_data = {}
|
||
|
|
|
||
|
|
for heading in reader:
|
||
|
|
titles = heading
|
||
|
|
break
|
||
|
|
|
||
|
|
i = 1
|
||
|
|
for row in reader:
|
||
|
|
current_row = "row{}".format(i)
|
||
|
|
temp_data['{}'.format(current_row)] = {}
|
||
|
|
for col in range(len(titles)):
|
||
|
|
temp_data[current_row][titles[col]] = row[col]
|
||
|
|
i+=1
|
||
|
|
|
||
|
|
with open(file_name+'.json', 'w') as f_j:
|
||
|
|
json.dump(temp_data, f_j, indent=4)
|
||
|
|
|
||
|
|
except:
|
||
|
|
print("Please provide correct filename")
|
||
|
|
|
||
|
|
print("File converted successfully :)")
|