Interpolation on DataFrame in pandas

by

You can use DataFrame.interpolate to get a linear interpolation. 

In : df = pandas.DataFrame(numpy.random.randn(5,3), index=['a','c','d','e','g'])

In : df
Out:
          0         1         2
a -1.987879 -2.028572  0.024493
c  2.092605 -1.429537  0.204811
d  0.767215  1.077814  0.565666
e -1.027733  1.330702 -0.490780
g -1.632493  0.938456  0.492695

In : df2 = df.reindex(['a','b','c','d','e','f','g'])

In : df2
Out:
          0         1         2
a -1.987879 -2.028572  0.024493
b       NaN       NaN       NaN
c  2.092605 -1.429537  0.204811
d  0.767215  1.077814  0.565666
e -1.027733  1.330702 -0.490780
f       NaN       NaN       NaN
g -1.632493  0.938456  0.492695

In : df2.interpolate()
Out:
          0         1         2
a -1.987879 -2.028572  0.024493
b  0.052363 -1.729055  0.114652
c  2.092605 -1.429537  0.204811
d  0.767215  1.077814  0.565666
e -1.027733  1.330702 -0.490780
f -1.330113  1.134579  0.000958
g -1.632493  0.938456  0.492695

For anything more complex, you need to roll-out your own function that will deal with a Series object and fill NaN values as you like and return another Series object.

More Related Contents:

  1. Selecting a row of pandas series/dataframe by integer index
  2. pandas: merge (join) two data frames on multiple columns
  3. How do I find the closest values in a Pandas series to an input number?
  4. How to display custom values on a bar plot
  5. How do I count the NaN values in a column in pandas DataFrame?
  6. Dummy variables when not all categories are present
  7. getting the index of a row in a pandas apply function
  8. Recursive definitions in Pandas
  9. Tilde sign in pandas DataFrame
  10. Drop columns whose name contains a specific string from pandas DataFrame
  11. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  12. Move non-empty cells to the left in pandas DataFrame
  13. Python Numpy TypeError: ufunc ‘isfinite’ not supported for the input types
  14. How to json_normalize a column with NaNs
  15. Convert Pandas Series to DateTime in a DataFrame
  16. Expanding pandas data frame with date range in columns
  17. Stacked bar chart in Seaborn
  18. Why is np.where faster than pd.apply
  19. Improve subplot size/spacing with many subplots
  20. Extract column value based on another column in Pandas
  21. Change the color of text within a pandas dataframe html table python using styles and css
  22. pandas – scatter plot with different color legend for each point
  23. Pandas: parse merged header columns from Excel
  24. Remove substring from column based on another column
  25. How to use sklearn fit_transform with pandas and return dataframe instead of numpy array?
  26. Changing certain values in multiple columns of a pandas DataFrame at once
  27. Round float columns in pandas dataframe
  28. Converting PANDAS dataframe from monthly to daily
  29. Pandas datetimes with different formats in the same column
  30. Get max value from row of a dataframe in python [duplicate]

Leave a Comment