Tutorials
Multi-Day Battery Arbitrage Analysis
Simulate a full year of constrained battery operation to understand profit variability and realistic annual expectations.
Stories
Explore comprehensive technical tutorials, programming guides, and insights from live coding sessions. Learn Python, data science, and modern web development.
Tutorials
Finding Arbitrage Opportunities in Electricity Markets
Analyze electricity prices to identify profitable charge/discharge windows for battery storage systems.
Tutorials
Fetching Electricity Prices from OMIE with Python
Access real-time and historical day-ahead electricity prices from the Spanish electricity market operator—no API key required.
Showcase
python-eia: US energy data smooth downloads
A new Python library to quickly access and preprocess US energy data from the EIA API—perfect for making real-world charts and forecasts.
Showcase
Pandas vs Polars: practical example
"Kernel died" when using pandas; that's when polars comes in handy.
Tutorials
Run scripts on autopilot every day to update database with GitHub Actions
Having a database that needs to be updated with new data published every day, how to automate script execution with GitHub Actions?
Tutorials
Normalized database for querying I90 files from REE
Understand the process of creating a normalized database to query historical information of energy programming units in the Spanish electrical system with practical examples.
Showcase
Tailored database systems for your business
Build robust database systems tailored to your business needs for seamless data storage, retrieval, and scalability.
Tutorials
Automate preprocessing of I90 Excel files (REE) in Python
Understand the steps to automate the preprocessing of I90 Excel files, detailing the operation of energy facilities according to daily generation programs.
Showcase
Excel Automations
Transform your Excel calculations into robust, scalable Python scripts and pipelines with Excel Automations.
Showcase
AI Agents to automatically execute your data processes
Explore how AI Agents can automate script organization, handle inputs/outputs seamlessly, and execute commands through a chatbot interface, making your workflow more efficient and effortless.
Courses
PT-ES-1: AI Agents in Trading
New edition of the course "AI Trading Agents Integrated with News and ML Models".
Courses
DF-ES-12: Spain Energy
New edition of the course "Applied Python: Data Manipulation and Visualization".
Reports
FAERS 2024 Q1 Drug Frequency and Adverse Reactions Analysis
An in-depth analysis of the FAERS Q1 2024 data, focusing on drug frequency and adverse reactions.
Courses
SP-ES-1: Pharmacovigilance
New edition of the course "Applied Statistical Programming: Academic Projects", in collaboration with the Salamanca Association of Pharmacy Students (ASEF).
Tutorials
How to download EUDRA data on drug safety surveillance
Learn how to access the European Medicines Agency's (EMA) European Union Drug Safety Surveillance (EUDRA) data through quarterly reports and APIs for post-market drug surveillance.
Tutorials
How to download FAERS data on drug safety surveillance
Learn how to access the FDA’s Adverse Event Reporting System (FAERS) data through quarterly reports and APIs for post-market drug surveillance.
Courses
DF-ES-11: Applied Data Visualization and Analysis in Python
Saturday, October 5, 2024.
Courses
Season packed with immersive live programming courses
This year, I will be collaborating with student associations from universities to organize live courses on the application of Data Analysis, Machine Learning and AI models using Python/R programming.
Tutorials
Structuring energy billing data with OpenAI for later BI
An quick example on how to use ChatGPT programmatically with Python.
Reports
Housing prices in Spain by autonomous communities since 2020 according to INE
Housing prices in Spain by Autonomous Communities since 2020 according to the National Statistics Institute (INE). Includes indices, quarterly variations, annual variations, and year-to-date changes.
Tutorials
How to calculate optimal power for solar self-consumption
Learn how to calculate the components of a solar self-consumption simulation to find the optimal power of solar panels to install.
Tutorials
Visually comparing contracts from Iberian gas market MIBGAS
Discover how to analyze and visualize MIBGAS contract prices using Pandas and Matplotlib. This tutorial guides you through data filtering, date handling, and interpolation techniques.
Reports
Market price spread
Weekly report (July 15 - July 21, 2024) of the market price spread in OMIE markets.
Opinion
ML models in the notebook are worthless
If you've invested valuable time developing your Machine Learning model, why not take advantage of it and put it to work calculating predictions in a web calculator?
Opinion
You don't understand, you just grasp it
How to differentiate technical professionals who truly understand from those who just grasp concepts: charlatans.
Tutorials
Main differences between matplotlib, seaborn, and plotly
Which library should you use for data visualization in Python? Matplotlib, Seaborn, or Plotly? Learn the main differences between them and when to use each one.
Tutorials
Reporting annual cumulative returns on multiple assets in Python
Learn how to process multiple financial assets and include them in a report highlighting each asset's annual performance.
Tutorials
Bollinger Bands with Python applied to the S&P500
Using Bollinger Bands, we can create a trading strategy to buy and sell stocks based on the market's moving volatility.
Tutorials
Explaining anomalies in energy markets with Machine Learning models
Discover how to explain the influence of explanatory variables in a Machine Learning model that detects anomalies using SHAP values.
Tutorials
Program trading orders with Alpaca API in Python
Learn how to automate trading strategies by programming buy and sell orders with Python using the Alpaca API.
Tutorials
Preprocess and analyze stock returns with Python
Learn to statistically analyze the stock performance of a company with Python.
Tutorials
ENTSO-E API in Python: European energy data analysis
Automate your European energy analyses with Python and the ENTSO-E API. We explain step by step with practical examples.
Tutorials
Backtesting with ML-based investment strategies
Learn to integrate a Machine Learning model into an investment strategy and evaluate its performance using the backtesting.py library with Python.
Tutorials
Working with temporal properties using pandas Datetime Index
Leverage the properties of DatetimeIndex in Pandas for more efficient time series analysis, from formatting the column to creating reports with pivot tables.
Tutorials
Isolation Forest to detect anomalies in time series data
Learn to detect anomalies in time series with Python, using advanced techniques and Machine Learning algorithms.
Tutorials
Unstack data frame after grouping to create heat matrix
Python tutorial to unstack the row categories into columns (long to wide table) to later create a heat matrix.
Tutorials
Style pivot table to create heat matrix
Learn how to highlight the most valuable cells in a Pandas pivot table that summarizes information on billionaires by country and industry.
Tutorials
ESIOS API in Python: Spain energy data analysis
Step by step, you'll learn how to download, preprocess, and visualize data from the Spanish Electric Grid's API using Python.
Tutorials
EIA API in Python: Automatic download of US energy data
Understand the structure of the EIA API and learn how to use it with Python to automate the downloads and exports into an Excel.
Tutorials
FRED API in Python: Automated US Federal Reserve Economic Data
A step-by-step guide to automatically download, export and visualize economic data from the St. Louis Fed using their API with Python.
Tutorials
Discretizing time to improve econometric analysis
Processing a new variable to distinguish the periods of the 2008 financial crisis improves the statistical relationship between Mortgage Rates (MR) and Inflation (CPI).