Data Analysis Journal

Data Analysis in Python: A Guide to Working With Dates in Pandas - Issue 211

A quick datetime reference guide for handling and parsing dates in Python Pandas.

Jul 3, 2024 • Olga Berezovsky

3

August 2023

SQL And Python Mistakes To Avoid - Issue 155

Don’t repeat my mistakes. Learning from common errors and how to avoid them

Aug 2, 2023 • Olga Berezovsky

8

December 2022

Python For Data Science: The Difference Between Merge, Join, And Concat - Issue 124

Ways to join and merge datasets in Python Pandas. How to know which method to pick for which use case.

Dec 21, 2022 • Olga Berezovsky

4

November 2022

How To Pass A Technical Assignment For Senior Data Scientist Position - Issue 118

A case study challenge breakdown for a senior data scientist position at one of the biggest Bay Area companies completed in Python

Nov 9, 2022 • Olga Berezovsky

9

October 2022

Getting Started With Python Plots - Issue 115

An introduction to creating visualizations in Python and a consolidated reference guide for building plots in Python Pandas

Oct 19, 2022 • Olga Berezovsky

3

June 2022

Python Pandas DateTime Reference Guide - Issue 97

A short guide to solutions and tips for handling DateTime cases in Python Pandas

Jun 8, 2022 • Olga Berezovsky

5

March 2022

SQL vs Python For Data Cleaning - Issue 84

What is better for data cleaning - SQL or Python? How to use them for data transformation, analysis, and refactoring.

Mar 2, 2022 • Olga Berezovsky

6

September 2021

A Selection Of Python Tutorials for Analysts - Issue 61

A roundup of my favorite tutorials for data analysts to either get started with or upkeep existing Python skills

Sep 15, 2021 • Olga Berezovsky

11

How To Pass A Take-Home Python Assignment - Issue 59

A case study challenge for a senior analyst position at one of the biggest Bay Area companies completed in Python

Sep 1, 2021 • Olga Berezovsky

4

July 2021

Currency Conversion In SQL and Python - Issue 53

How to approach conversion rates for multiple currencies in SQL for revenue reporting

Jul 21, 2021 • Olga Berezovsky

6

How To Install And Set Up Python - Issue 52

How to get started with Python basics and its environments for data science and analysis

Jul 14, 2021 • Olga Berezovsky

7

May 2021

Python Questions For A Data Analyst Interview - Issue 44

Some common Python interview questions for hiring data analysts and data scientists

May 19, 2021 • Olga Berezovsky

5