Data visualization with Matplotlib

Python
Data Viz

Matplotlib is a great python library for data viz. It's flexibility allows to create powerful visualizations, that can be highly customized.

In this article, I show how to get started with Matplotlib and present some of its key features for proper customization.

Parsing XML data with Python

Python
XML

Working with semi-structured data is not uncommon. XML data used a lot in web-services, e-commerce applications and even databases.

In this article, I explain what XML is, cover some key concepts around it and explore data parsing with XML ElementTree python module.

SQL injection and how to prevent it

Python
SQL
Security

SQL injections were a significant threat in the early 2000s. Companies are still exposed today because of legacy IT applications, shadow IT and the non implementation of good security practices by users.

In this article, I describe what a SQL injection is, the risks it poses and how to prevent from it.

Query SQLite database with Python

Python
SQL

As part of my Football Analytics series. Querying data from a SQLite database with python.

SQL and Python integrate well. In this article, I explore how to connect to a SQLite database with Python, extract data and share some advices for aspiring data analysts.

Reading PDF files with Python

Reading PDF files with python

Python

One of my first personal python projects: parsing data out of PDF bank statements.

A classic for aspiring data analysts: analyzing your own financials. While it is often available in csv format, sometimes, all you have are PDF files that you need to parse.
I have discovered Camelot, a powerful python library to read PDF files.

Pierre Marionneau's website on a desktop interface

pierremarionneau.dev

Building my professional website

HTML
CSS
JavaScript

My first project to be published had to be my professional website!

I wanted to have my own space to showcase my projects and share my insights on the industry. Furthermore, being familiar with web-design (HTML, CSS, eventually JavaScript) is a very useful skill for aspiring data analysts, whether it is to build custom visualizations in Power BI or to do web scraping.