python: Reading and Writing JSON to a File

 

python.exe -m pip install --upgrade pip

pip install pymssql

pip install pymysql
pip install pyodbc

pip install SQLAlchemy

pip install xlrd
pip install xlwt
pip install xlutils
pip install xlwings
pip install XlsxWriter
pip install openpyxl
pip install pandas
pip install pandasql

pip install win32com

pip install pyspark

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

#import json jsondata = {     'sqlserver': [         {             "server": "DESKTOP-NQK85G5\GEOVIN2008",             "useid": "sa",             "password": "geovindu",             "database": "Student"         }     ],     'mysql':[         {             "server": "loacalhost",             "useid": "root",             "password": "geovindu",             "database": "Student"         }     ] } json_string = json.dumps(jsondata) print(json_string) # Using a JSON string with open('json_data.json', 'w') as outfile:     outfile.write(json_string)   # Directly from dictionary with open('json_data2.json', 'w') as outfile:     json.dump(json_string, outfile)   with open('json_data.json') as json_file:     readdata = json.load(json_file)     print(type(readdata))     print(readdata['sqlserver'])   dictionary = {     "server": "DESKTOP-NQK85G5\GEOVIN2008",     "useid": "sa",     "password": "geovindu",     "database": "Student" } with open("databaseconfig.json", "w") as outfile:     json.dump(dictionary, outfile)   with open('databaseconfig.json', 'r') as openfile:       # Reading from json file     json_object = json.load(openfile)   print(json_object) print(type(json_object))

　　

JSON encoder and decoder

Serialize and Deserialize