Python in Excel
Python is now inside Microsoft Excel. Really? Python is only in Excel if you have Microsoft 365 on […]
Python
Rename a DataFrame Column in Python
As a data professional do you have a Python dataset that might require some column renaming? Why would […]
Reorder pandas DataFrame Columns
To reorder columns in a Pandas DataFrame, pass into the DataFrame a list of column names in the […]
Groupby Multiple Columns
How do you take a pandas DataFrame of data (dataset) and produce a multi-column bar chart? You can […]
Apply a Custom Function to a DataFrame
How do we apply a custom Python function to a column in a pandas DataFrame? Here we’ll use […]
Python Find Nth Occurrence of Char in a String
In Python, how would you find the Nth occurrence of a character (or substring) in a string? Yes, […]
Change String Case in pandas
There are several ways to change the case in a pandas String. There is upper, lower, title, capitalize […]
Sorting a pandas DataFrame
You can sort a pandas DataFrame by one or multiple (one or more) columns using sort_values() method and […]
Data Type Conversion in pandas
Convert Strings to Floats This post discusses one of the EDA Structuring tasks using Python and pandas. Here […]
Filtering a pandas DataFrame
How do you filter or select rows from a pandas DataFrame and have the output produce a filtered […]
Concatenate pandas DataFrames
What does it mean to concatenate DataFrames? A DataFrame is like a table with rows and columns. To […]
Pandas Series from a DataFrame
Can you create a pandas Series from a pandas DataFrame? Yes. A column in a DataFrame can be […]