This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ./output/ | |
| ├── constituency.gpkg | |
| ├── country.gpkg | |
| ├── district.gpkg | |
| ├── municipality.gpkg | |
| ├── state.gpkg | |
| ├── datapackage | |
| │ └── datapackage.json | |
| ├── LOD | |
| │ ├── 1 |
nesnoj
/ write_db_table_comments_to_jsons.py
Last active
September 23, 2021 14:15
Read all table comments from a database and write to json files
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Read all table comments from a database and write to json files | |
| # * Tables without comment are skipped | |
| # * Output format: <schema>.<table>.json | |
| # | |
| import json | |
| import os | |
| from sqlalchemy import create_engine, inspect, MetaData, Table |
nesnoj
/ edges.csv
Created
November 16, 2021 10:22
— forked from gplssm/edges.csv
Test of Python skills with an example of graph analysis
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| node1 | node2 | |
|---|---|---|
| Source | 1 | |
| 2 | 3 | |
| 1 | 2 | |
| 3 | 10 | |
| 10 | Target | |
| 1 | 4 | |
| 4 | 5 | |
| 5 | Target | |
| 1 | 6 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| region_id | RegioStaR7 | bev_mini | bev_medium | bev_luxury | phev_mini | phev_medium | phev_luxury | |
|---|---|---|---|---|---|---|---|---|
| 71 | SR_Metro | 1690 | 3844 | 1235 | 1047 | 2382 | 765 | |
| 72 | SR_Gross | 1750 | 3676 | 1045 | 1084 | 2278 | 647 | |
| 73 | SR_Mitte | 3548 | 7776 | 2421 | 2197 | 4818 | 1499 | |
| 74 | SR_Klein | 880 | 1958 | 574 | 545 | 1213 | 355 | |
| 75 | LR_Zentr | 816 | 1760 | 511 | 506 | 1090 | 317 | |
| 76 | LR_Mitte | 2050 | 4625 | 1331 | 1269 | 2866 | 824 | |
| 77 | LR_Klein | 2250 | 5230 | 1487 | 1394 | 3241 | 921 |
OlderNewer