Count the Number of Rows with a Condition
Suppose you are working with a pandas DataFrame in Python. You are doing some EDA (exploratory data analysis) […]
dataframe
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 […]
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 […]
Sorting a pandas DataFrame
You can sort a pandas DataFrame by one or multiple (one or more) columns using sort_values() method and […]
Filtering a pandas DataFrame
How do you filter or select rows from a pandas DataFrame and have the output produce a filtered […]
Pandas Series from a DataFrame
Can you create a pandas Series from a pandas DataFrame? Yes. A column in a DataFrame can be […]
Pandas DataFrame Insert Column
The Pandas insert method allows you to insert a column in a DataFrame. loc: loc is an integer […]
Find Unique Values in a pandas Column
How do you find unique values in a pandas DataFrame? You can use the unique() function. Let’s look […]
Cleaning Categories in pandas
You have a dataset in pandas represented as a DataFrame. One of the columns has categories in it. […]
Loop Through pandas DataFrame
How would we iterate (loop) through the rows of a pandas DataFrame? What’s the context? Why would we […]
A Planets Dataset in Python & R
Here is a very small sample dataset for practicing your coding skills in Python and pandas. It’s just […]