https://github.com/cured-plus/csvw-duckdb
Convert a CSVW document (CSV metadata) to a DuckDB query to load a CSV file into a database.
Science Score: 13.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
○CITATION.cff file
-
✓codemeta.json file
Found codemeta.json file -
○.zenodo.json file
-
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (8.0%) to scientific vocabulary
Keywords
Repository
Convert a CSVW document (CSV metadata) to a DuckDB query to load a CSV file into a database.
Basic Info
Statistics
- Stars: 0
- Watchers: 0
- Forks: 0
- Open Issues: 0
- Releases: 0
Topics
Metadata Files
README.md
CSVW DuckDB tool
Convert a CSVW document (CSV metadata) to a DuckDB query to load a CSV file into a database.
See also: Python csvw package.
Installation
bash
pip install csvw-duckdb
Usage
To use this tool, call it from the command line and provide the path of the CSVW document. The SQL code will be written to the screen.
bash
csvw-duckdb --help
```
usage: csvw-duckdb [-h] [--loglevel {DEBUG,INFO,WARNING,ERROR,CRITICAL}] [--version] csvw_path
Load a CSVW document and generate simple SQL SELECT statements. One SQL file will be generated per table in the CSVW table group.
positional arguments: csvw_path CSVW file
options: -h, --help show this help message and exit --loglevel {DEBUG,INFO,WARNING,ERROR,CRITICAL}, -l {DEBUG,INFO,WARNING,ERROR,CRITICAL} --version show program's version number and exi ```
Examples
bash
csvw-duckdb my_metadata.csvw
Owner
- Name: CUREd-Plus
- Login: CUREd-Plus
- Kind: organization
- Repositories: 1
- Profile: https://github.com/CUREd-Plus
GitHub Events
Total
- Release event: 2
- Push event: 11
- Create event: 4
Last Year
- Release event: 2
- Push event: 11
- Create event: 4
Packages
- Total packages: 1
-
Total downloads:
- pypi 16 last-month
- Total dependent packages: 0
- Total dependent repositories: 0
- Total versions: 2
- Total maintainers: 1
pypi.org: csvw-duckdb
Convert CSVW metadata to DuckDB SQL syntax.
- Homepage: https://pypi.org/p/csvw-duckdb
- Documentation: https://csvw-duckdb.readthedocs.io/
- License: MIT License
-
Latest release: 0.0.1
published about 1 year ago