If you ask me what an engineer does? Writing C++? Writing Java? Writing Python?
I’ll say an engineer is who can solve the question in front of herself/himself.
And recently, I face a challenge that I need to parse a long long word file table into my customized JSON file.
SO, it looks reasonable to write some python to help me deal with this problem.
Input:A long long word file table.
Output:A customized JSON file.
Python version:2.7
And the best way for python to access the table data would be excel, so my first step is to paste the table to the excel and clean the unnecessary part(like some duplicate title etc.)
These two imports for accessing excel file:
import xlrd
import xlwt
These two for JSON format:
import json
import collections
And this one is because I need to deal with some Latin language, so I’m gonna need this to assign the decoding and encoding:
import io
Usage of Collection:
len() & zfill():Can help you to fill some 0’s with specific lengh
The encoding for Latin words: