Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Python Pandas - Fill NaN values using an interpolation method
Use the interpolate() method to fill NaN values. Let’s say the following is our CSV file opened in Microsoft Excel with some NaN values −
Load data from a CSV file into a Pandas DataFrame −
dataFrame = pd.read_csv("C:\Users\amit_\Desktop\SalesData.csv")Fill NaN values with interpolate() −
dataFrame.interpolate()
Example
Following is the 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)
# fill NaN values with interpolate()
res = dataFrame.interpolate()
print("\nDataFrame after interpolation...\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 interpolation... Car Reg_Price Units 0 BMW 2500 100.0 1 Lexus 3500 110.0 2 Audi 2500 120.0 3 Jaguar 2000 115.0 4 Mustang 2500 110.0
Updated on: 28-Sep-2021
1K+ Views
Advertisements