Python Pandas – Propagate non-null values forward

Use the “method” parameter of the fillna() method. For forward fill, use the value ‘ffill’ as shown below −

fillna(method='ffill')

Let’s say the following is our CSV file opened in Microsoft Excel with some NaN values −

At first, import the required library −

import pandas as pd

Load data from a CSV file into a Pandas DataFrame −

dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\SalesData.csv")

Example

Following is the complete code −

import pandas as pd

# Load data from a CSV file into a Pandas DataFrame
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\SalesData.csv")
print("DataFrame...\n",dataFrame)

# propagate non null values forward
res = dataFrame.fillna(method='ffill')
print("\nDataFrame after forward fill...\n",res)

Output

This will produce the following output −

DataFrame...
       Car   Reg_Price   Units
0      BMW        2500   100.0
1    Lexus        3500     NaN
2     Audi        2500   120.0
3   Jaguar        2000     NaN
4  Mustang        2500   110.0

DataFrame after forward fill...
       Car   Reg_Price   Units
0      BMW        2500   100.0
1    Lexus        3500   100.0
2     Audi        2500   120.0
3   Jaguar        2000   120.0
4  Mustang        2500   110.0

AmitDiwan

Published on 01-Oct-2021 11:35:29

• Related Questions & Answers
• Python Pandas – Propagate non-null values backward
• Python Pandas – Check for Null values using notnull()
• Looping in JavaScript to count non-null and non-empty values
• How does COALESCE order results with NULL and NON-NULL values?
• Python – Display only non-duplicate values from a DataFrame
• Store – and – Forward Packet Switching
• Python - Remove a column with all null values in Pandas
• Fetch maximum value from multiple columns with null and non-null values?
• Python Pandas – Find unique values from multiple columns
• Display first non-null values with coalesce() in MySQL?
• Perform mathematical calculations in a MySQL table with NULL and NON-NULL values
• Python – Pandas Dataframe.rename()
• Python Pandas – Find unique values from a single column
• Return only the non-empty and non-null values from a table and fill the empty and NULL values with the corresponding column values in MySQL?
• Update all the fields in a table with null or non-null values with MySQL