GBG Analytics Blog
Welcome to my blog! I am pleased to have you here. This platform is dedicated to a wide array of topics, providing insightful and engaging articles aimed at informing and inspiring. I invite you to explore the content, and I look forward to hearing your feedback. I trust that you will find the information both valuable and thought-provoking.
2024
Statistics for Data Science and Analytics
This project analyzes a modified autism dataset of children's attributes, focusing on data preprocessing, univariate statistics, and visualizations. Structured as a Q&A tutorial, it guides users through data cleaning, descriptive statistics, visualizations, and hypothesis testing using R and Python. The goal is to explore and interpret the dataset, addressing key questions related to autism diagnosis and associated factors.
Export Multiple Data Frames to Different Excel Worksheets in R
In this tutoral you will learn how to export multiple dataframes in R to an Excel workbook, with each Excel worksheet corresponding to a distint dataframe.
How to fetch API data in R and Python
This tutorial will teach you how to fetch data from an external source using HTTP requests and parse the data into a usable format.
2023
Every Scientist Should Have a Website
How putting yourself out there helps you show your research, expand your network, control your own content, reach an audience, and enhance your opportunities.
Create Your Website with Quarto: Complete Tutorial and Template
This tutorial and template will help you build your own personal website with Quarto. It is a full guide with step-by-step instructions for your personal or academic homepage.
2022
Data Consolidation: Automatically Merge Excel Sheets with Python
Learn how to dynamically consolidate data from multiple Excel sheets into a single pandas DataFrame using Python. This tutorial covers automating sheet retrieval, merging data efficiently, and tracking source sheets—all while simplifying your data processing workflow. Perfect for streamlining recurring reports and handling complex datasets!
Data Consolidation: How to Efficiently Merge Multiple CSV Files in Python
In this quick tutorial, you'll learn how to easily merge several CSV files into one using Python. Whether you're working with a few small files or large datasets, this guide shows you how to use Pandas for simple tasks or `Dask` when your data is too big to handle. It's a practical, straightforward approach for anyone looking to combine CSV files efficiently.
