Pandas reindex dates in Groupby

by

There’s probably a slicker way to do this but this works:

def reindex_by_date(df):
    dates = pd.date_range(df.index.min(), df.index.max())
    return df.reindex(dates).ffill()

df.groupby('id').apply(reindex_by_date).reset_index(0, drop=True)

More Related Contents:

  1. how to calculation cost time [closed]
  2. GroupBy pandas DataFrame and select most common value
  3. String concatenation of two pandas columns
  4. Reshape wide to long in pandas
  5. How do I create test and train samples from one dataframe with pandas?
  6. pandas groupby sort within groups
  7. How to create a large pandas dataframe from an sql query without running out of memory?
  8. How do convert a pandas dataframe to XML?
  9. How to add hovering annotations to a plot
  10. Sort a pandas dataframe series by month name
  11. Count frequency of values in pandas DataFrame column
  12. Strip / trim all strings of a dataframe
  13. How to iterate over consecutive chunks of Pandas dataframe efficiently
  14. How to flatten multilevel/nested JSON?
  15. Neural Network LSTM input shape from dataframe
  16. Joining pandas DataFrames by Column names
  17. Diff of two Dataframes
  18. Apply function to pandas DataFrame that can return multiple rows
  19. Write to StringIO object using Pandas Excelwriter?
  20. Scikit Learn OneHotEncoder fit and transform Error: ValueError: X has different shape than during fitting
  21. “Anti-merge” in pandas (Python)
  22. Pandas – write Multiindex rows with to_csv
  23. Writing to a file on SFTP server opened using Paramiko/pysftp “open” method is slow
  24. Select row from a DataFrame based on the type of the object(i.e. str)
  25. How to annotate a seaborn barplot with the aggregated value
  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