Data with Charles

Back to Basics - Python 03

Charles De Barros, Apr 23, 2024, Back to basics Python

Better than sliced bread String slicing allows us to extract specific portions of a string by specifying a start and an end indices. We can even skip characters! How about...

Back to Basics - Pandas 02

Charles De Barros, Apr 16, 2024, Back to basics Pandas

One of the most common tasks we perform with Pandas is data indexing and selection. We do that pretty much daily. Let’s delve into the world of Pandas and explore...

Back to Basics - Python 02

Charles De Barros, Apr 10, 2024, Back to basics Python

The Numeric data type There are eight major data types in Python: Description Type Text str Numeric int, float, complex Sequence list, tuple, range Mapping dict Set set, frozenset Boolean...

Back to Basics - Pandas 01

Charles De Barros, Apr 09, 2024, Back to basics Pandas

Introduction to Pandas Pandas Official Documentation. What is Pandas? As per the Pandas Official Documentation website: Pandas is an open source, BSD-licensed library providing high-performance, easy-to-use data structures and data...

Back to Basics - Python 01

Charles De Barros, Apr 09, 2024, Back to basics Python

Intro It’s March 2024 and I have joined a Level 4 Data Analytics Bootcamp! Hurray! Technically lessons will only start at the beginning of April but I am already very...

SQL-for-Data-Analysis. Beginner-MySQL-Business-Intelligence-certification

Charles De Barros, Nov 17, 2023, Training Certification

I’m happy to share that I’ve obtained a new certification: SQL for Data Analysis: Beginner MySQL Business Intelligence from Udemy (Maven Analytics). See the certificate on Udemy here. COURSE OUTLINE: SQL Intro...

Mocking data for Data Analysis and Testing

Charles De Barros, Oct 23, 2023, Resources Data analytics Testing

Have you ever needed to quickly generate mock data to exercise your data analytics skills or test your app? Try Mockaroo. It is an easy and quick way to create...

Jupyter Notebook Shortcuts

Charles De Barros, Oct 05, 2023, Resources Jupyter notebook

If you, like me, use Jupyter Notebook for Data Analysis, these Jupyter Notebook shortcuts might come in very handy. #jupyterNotebook #dataanalsys #python #numpy #pandas #shortcuts Jupyter Notebook tips and shortcuts...

UK Road Safery 2021-2022

Charles De Barros, Jul 05, 2023, Projects Portfolio

I have based my research on the UK’s Department for Transport data. I investigated and found patterns and trends in Road Safety in various Local Authorities across the country. Analysing...

Data Analysis with Pandas - a playlist

Charles De Barros, Jun 21, 2023, Resources Data analysis Pandas

If you are learning Data Analysis and have just started with Python Pandas, check this Pandas playlist from Corey M Schafer. It is truly excellent, very comprehensive, and a very...

It is finally here

Charles De Barros, Jun 20, 2023, Training Certification

It is finally here! My Level 3 - Data Citizen Skills Bootcamp Certificate of Completion. Level 3 - Data Citizen Skills Bootcamp I cannot express enough how much this certificate...

Data Preparation and Data Cleaning

Charles De Barros, May 23, 2023, Data analytics

It is Week 10, our last week, at the Cambridge Spark Data Citizen Bootcamp. It is also project week. We are putting to practice all the new skills we have...

Intro to Python for Data Analysis

Charles De Barros, May 19, 2023, Data analysis Python

This week, Week 9 of our Data Citizen Bootcamp at Cambridge Spark, was a gentle intro to Python for Data Analysis, including an intro to the Pandas data analysis library....

Markdown Cheatsheet on Github

Charles De Barros, May 16, 2023, Markdown

A very thorough guide on Markdown markup language. Very useful if one needs to add some markdown structure to their blog posts. Markdown Cheatsheet

ELT vs ETL

Charles De Barros, May 13, 2023, Data analytics

Confused by the difference between ETL and ELT when dealing with data? Which one is the most appropriate? Is one better than the other? Take a look at this nice...

Data Storytelling

Charles De Barros, May 09, 2023, Data analytics

Today we started Week 8 of our Data Citizen Bootcamp at Cambridge Spark and it was all about Data Storytelling. Finally, we are wrapping up all the last 7 weeks...

Dashboard with Power Bi

Charles De Barros, May 02, 2023, Data analytics Power bi

Today was a Visualisation/Building Power BI dashboards on our Cambridge Spark Data Citizen Bootcamp lesson. Really good fun, by the way! I am from a “less is more” school when...

Clearning your Data

Charles De Barros, Apr 10, 2023, Data analytics

A very instructive Microsoft article on “Top ten ways to clean your data” found by my colleague Bryan, from our Cambridge Spark Data Citizen Bootcamp. We have just finished Week...

Welcome to Jekyll!

Charles De Barros, Aug 08, 2020, Travels

You’ll find this post in your _posts directory. Go ahead and edit it and re-build the site to see your changes. You can rebuild the site in many different ways,...