How To Blog

The blogs below outline some routine types of problems that can be encountered in your career as an analyst of any sort. Feel free to take whatever you need from these blogs. Some of the blogs shown here are part of a larger series of creating a custom python package that houses functions and routines that you commonly use.

Posts tagged data formatting

Using Python to Read a Range in Excel

Using Python to Read a Range in Excel

Using pandas to read the range of an excel file.

Python, ExcelDaniel KorponMarch 31, 2022data analysis, data science, data formatting

Find the Date for n.xx Days Ago

Find the Date for n.xx Days Ago

A brief overview on how to find the date for a given number of years ago. This practice can be used to determine someone’s birthdate.

PythonDaniel KorponMarch 23, 2022data formatting, data analysis, data science

Move the last column to the first column in a DataFrame

Move the last column to the first column in a DataFrame

This post shows you how to move the last n number of columns from the right most side of a DataFrame to the first two columns of a DataFrame.

PythonDaniel KorponMarch 15, 2022data engineering, data formatting, data analysis

Append DataFrames to each other

Append DataFrames to each other

A quick how to on the process of appending two DataFrames to each other.

PythonDaniel KorponMarch 3, 2022data analysis, data engineering, data formatting, etl