- Read csv files into a SQLite database. - SQLite does NOT have a built-in COPY-from-CSV like DuckDB. We create tables using SQL, then load CSV data using Python. - Use Python to automate SQL scripts ...
Hello, let's build it! "I wonder how many books I've read without realizing it?" Have you ever thought that? You tried keeping a reading journal but couldn't keep it ...
**Data Cleaning & Quality Automation Tool** Preprocessing the data typically consumes most of the time of analysts. This led me to develop a fully automated data quality pipeline in Python that ...
flight-delay/ │ ├── src/ │ ├── pipeline/ │ │ ├── data_generator.py # Synthetic dataset generation (100K records) │ │ ├── data_cleaner.py # IQR clipping, imputation, deduplication │ │ ├── ...
Code Sensai @CodeNinjas | Passionate Software Developer | ReactNative | Node.js | MongoDB | JavaScript/TypeScript | Kotlin | Express.js | SAAS | C++ | Python | SQL ...
做开发这么多年,数据库客户端真是换了一茬又一茬。 DBeaver 功能全但启动慢,Navicat 好用但价格劝退,TablePlus 体验好却只伺候 macOS 用户。更别提那些国产和新兴数据库,很多工具压根没驱动。 最近在 GitHub 上发现了一个叫 DBX的项目,着实让我眼前一亮。
我转头把这个只有15MB的数据库工具安装包,丢给了隔壁工位天天骂 Navicat 死贵的阿强,他半信半疑地打开,三秒启动,连上公司的测试库,看着那流畅的表格滚动,脱口而出:“这得卖多少钱?”我笑着敲了下他屏幕上的 GitHub 地址,他盯着 LICENSE 文件里的“AGPL ...