1.write
f = open('test.txt','w')
f.write('test')
f.close()
with open('test.txt','w') as f:
f.write('test')
import json
data = {'test':1}
with open('test.json','w+') as f:
json.dump(data, f)
d = json.loads('{"test":1,"age":2}')
print(d['test'])
i = json.dumps({'test':'1','age':1})
print(type(i))
2.read
with open('test.txt','r') as f:
d = f.read()
print(d)
f = open('test.txt', 'r', encoding='ascii')
f = open('test.txt', 'r', encoding='ascii', errors='ignore')
with open('test.json','r') as f:
d = json.load(f)
print(d)
3.常見問題
import json
with open('test.json','r') as f:
d = json.load(f)
print(d)
>>> JSONDecodeError: Expecting value: line 1 column 1 (char 0)
4.parse JSON to CSV
data = '{"test":[{"name": "josh", "email": "[email protected]"},{"name": "andy", "email": "[email protected]"},..]}'
import json
import csv
data_parsed = json.loads(data)
personal_data = data_parsed ['test']
with open('personal.csv', 'w') as csv_data:
csvwriter = csv.writer(csv_data)
count = 0
for per in personal_data:
if count == 0:
header = per.keys()
csvwriter.writerow(header)
count += 1
csvwriter.writerow(per.values())