Python script to parse CSV file data (via json) into a sqlite database. Table schemas names based on pre set filenames, headers, and data types.
completions.csv parsed into json data as follows
"Application_Number": "16251227 2184",
"Parish": "Alstonefield",
"Description": "Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur",
"Address": "Ap #949-9453 Non, Street",
"Occupancy_Type": "Agricultural or Holiday",
"Application_Type": "VAR",
"FY": "2007/08",
"ISSUEDATE": "21/01/2008",
"District": "SMDC",
"Dwellings": "1"
| Num | Application_Number | FY | Quantity | Occupancy_Type | Build_Type |
|---|---|---|---|---|---|
| 0 | 16030428 | 1991/92 | 1 | Ancillary | COU |
| 1 | 16440708 | 1993/94 | 1 | Local Need | New |
| 2 | 16180117 | 2019/20 | 5 | Open Market | NEW |
| 3 | 16180116 | 1998/99 | -1 | Holiday | COU |
| 4 | 16730127 | 1991/92 | 1 | Holiday | CON |