python script extract text from json file
Budget: ₹600 – ₹1,500 INR
extract text in content from json file:
input file:
{
"id":"1648450154083",
"displayName":"Grace", <<<<<<<<<<<<<<<<< first column
"originalarrivaltime":"2022-03-28T06:49:12.106Z",
"messagetype":"RichText",
"version":1648450154083.0,
"content":"可以下载的", <<<<<<<<<<<<<<<<< Extract that, second column
"conversationid":"8:live:.cid.abcdefghijklmn123",
"from":"8:live:.cid.abcdefghijklmn123",
"properties":null,
"amsreferences":null
},
output .csv file:
Grace,可以下载的
Grace,请告诉我你可以下载他们
Grace,晴天 眼睛
1- Chinese character sentences (+ option to ignore none Chinese sentence )
2- and order by date, the oldest message display first
1- script need to run on windows or Linux
2- need to to added to this code: https://github.com/dahai0013/HSK_text_process
3- has to be re-usable ( create functions )
4- has to be documented ( + added to the help )
pythong3 main.py --help ( will should how to use this features )
5- usage:
pythong3 main.py --skype --input xxxxxxx.json --output_text_only xxxxx.csv --ignore_none_chinese
( use default / hardcoded names for json and output file .txt )
6- minimum changes to the rest of the code
input file:
{
"id":"1648450154083",
"displayName":"Grace", <<<<<<<<<<<<<<<<< first column
"originalarrivaltime":"2022-03-28T06:49:12.106Z",
"messagetype":"RichText",
"version":1648450154083.0,
"content":"可以下载的", <<<<<<<<<<<<<<<<< Extract that, second column
"conversationid":"8:live:.cid.abcdefghijklmn123",
"from":"8:live:.cid.abcdefghijklmn123",
"properties":null,
"amsreferences":null
},
output .csv file:
Grace,可以下载的
Grace,请告诉我你可以下载他们
Grace,晴天 眼睛
1- Chinese character sentences (+ option to ignore none Chinese sentence )
2- and order by date, the oldest message display first
1- script need to run on windows or Linux
2- need to to added to this code: https://github.com/dahai0013/HSK_text_process
3- has to be re-usable ( create functions )
4- has to be documented ( + added to the help )
pythong3 main.py --help ( will should how to use this features )
5- usage:
pythong3 main.py --skype --input xxxxxxx.json --output_text_only xxxxx.csv --ignore_none_chinese
( use default / hardcoded names for json and output file .txt )
6- minimum changes to the rest of the code