Python. Here are some advanced things I like to do with pandas DataFrames to take my analysis to the next level. Change the ...

Running Python scripts is one of the most common tasks in automation. However, managing dependencies across different systems can be challenging. That’s where Docker comes in. Docker lets you package ...

When using the DuckDB package in Python to import a CSV file into PostgreSQL, I've observed inconsistent behavior regarding column names: Lower Case Column Titles: if the CSV file's header (column ...

CSV, or Comma Separated Values, are files used for all kinds of things, from managing large datasets to exporting data to move it between web services. You might think CSV files are just spreadsheets, ...

This repository contains a shell script for importing CSV files into a PostgreSQL database. The script automatically creates tables based on CSV headers and imports the data. Ensure the schema is ...

If you have ever found yourself spending hours sifting through piles of PDFs, DOCX files, and CSVs, manually extracting the data you need. It’s tedious, right? I’ve been there, and I know how ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...