How to Perform Sum Product Function in Python

An Example of creating a sumproduct function in python.

Python, ExcelDaniel KorponApril 12, 2023python, math

Performing Numeric Integration

A quick write up on how to perform numerical integration and differentiation using python.

PythonDaniel KorponMarch 1, 2023math, python, integration, derivatives

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 index of the iterator of a list

A brief note on how to find the index of a list when using the enumerating function in python.

PythonDaniel KorponMarch 25, 2022coding

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

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

Finding Lattitude and Longitude of an Address using Python

In this blog, python code for determining the latitude and longitude of a specific address is explored.

PythonDaniel KorponMarch 12, 2022geography

Convert Numerical String Characters to Float Using Python

This blog briefly explains how to convert a string of numerical characters into a float data type.

PythonDaniel KorponMarch 8, 2022pandas

Model Orbiting Around a Center Point

In this write up we briefly explore how to model orbiting around a center point.

Daniel KorponMarch 4, 2022

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

Turn an Integer into Word Form

A few lines of code to turn an integer into a word - for example 1 into One.

PythonDaniel KorponFebruary 21, 2022data analysis, data science, nlp, natural language processing

Determine the Sample Size Needed For an Experiment Using t-tests

A brief overview of how to find the sample size needed to determine a give level of power for a t-test.

PythonDaniel KorponFebruary 18, 2022math, statistics, data analysis, data science, experiment design

Remove All Numbers From Cells in Excel

Excel functions to remove special characters are explored. Several different methods including a VBA macro are included.

ExcelDaniel KorponFebruary 12, 2022

Create Datetime Column from Two Columns using Python

How to create a datetime column using two columns one of which is a date, the other is a time.

PythonDaniel KorponFebruary 11, 2022pandas

How To Blog

Stellar Grove