PinnedAlexandre Stamm·Mar 11How We Reduced a Large Spark ETL Job Runtime by 80%: A Practical Databricks Optimization GuideLarge-scale Spark pipelines rarely fail suddenly. Instead, they degrade slowly as data volume grows, until one day a job that used to run…A response icon1A response icon1
PinnedAlexandre Stamm·Jul 24, 2022Data visualization with Python & PlotlyHow to make beautiful charts & dashboards using Plotly
PinnedAlexandre Stamm·Jun 11, 2022Importing data from a PostgreSQL database to a Pandas DataFrameIn this article, we’ll go over how to create a pandas DataFrame using a simple connection and query to fetch data from a PostgreSQL…A response icon1A response icon1
Alexandre Stamm·Nov 26, 2022Automating reports with Google Sheets API & Jupyter Notebook connectionHello everyone!
Alexandre Stamm·Sep 9, 2022Useful SQL Window functions for Business/Data AnalystsToday, I’m going to talk about some of the functions that I often use when I’m working with SQL to query information for my analysis and…
Alexandre Stamm·Jun 19, 2022Checking and cleaning data in Python with PandasHello everyone! In my previous articles, we learned about how to load into a Pandas DataFrame, and how to Import data from a PostgreSQL…
Alexandre Stamm·Jun 16, 2022How to load data into a Pandas DataFrameIn this article, we’ll go over some ways you can load your data into a Pandas DataFrame!