Tutorials — Data, Architecture & Cloud
Practical technical tutorials on Power BI, DAX, Azure, Databricks and much more.
Python para dados
How to convert text to dates with pandas in Python
Learn how to convert text to dates with pandas in Python: pd.to_datetime, the right format, handling err…
How to use environment variables with python-dotenv in Python
Learn how to use environment variables in Python with the python-dotenv library and a .env file to keep …
How to Export a DataFrame to Excel with pandas in Python
Learn how to export a DataFrame to Excel with pandas in Python using to_excel and ExcelWriter, with mult…
How to group data with pandas groupby: step by step
Learn to group and aggregate data in Python with pandas groupby: sum, mean and count per category, with …
How to connect Python to SQL Server with pyodbc
Learn how to connect Python to SQL Server with pyodbc: install the ODBC driver, build the connection, ru…
How to Join Two DataFrames with pandas in Python
Learn how to join two DataFrames with pandas merge: join types (how), columns with different names, and …
Need expert implementation?
Our team delivers end-to-end data projects — BI, cloud architecture and AI.
Book a free meeting →