pandas – Merge nearly duplicate rows based on column value

by

I think you can use groupby with aggregate first and custom function ', '.join:

df = df.groupby('Name').agg({'Sid':'first', 
                             'Use_Case': ', '.join, 
                             'Revenue':'first' }).reset_index()

#change column order                           
print df[['Name','Sid','Use_Case','Revenue']]                              
  Name   Sid           Use_Case Revenue
0    A  xx01         Voice, SMS  $10.00
1    B  xx02              Voice   $5.00
2    C  xx03  Voice, SMS, Video  $15.00

Nice idea from comment, thanks Goyo:

df = df.groupby(['Name','Sid','Revenue'])['Use_Case'].apply(', '.join).reset_index()

#change column order                           
print df[['Name','Sid','Use_Case','Revenue']]                              
  Name   Sid           Use_Case Revenue
0    A  xx01         Voice, SMS  $10.00
1    B  xx02              Voice   $5.00
2    C  xx03  Voice, SMS, Video  $15.00

More Related Contents:

  1. error when applying function to a series object
  2. How to group dataframe rows into list in pandas groupby
  3. Groupby value counts on the dataframe pandas
  4. Creating dataframe from a dictionary where entries have different lengths
  5. How to print pandas DataFrame without index
  6. Pandas: Chained assignments [duplicate]
  7. Apply pandas function to column to create multiple new columns?
  8. How to delete rows from a pandas DataFrame based on a conditional expression [duplicate]
  9. Reversing ‘one-hot’ encoding in Pandas
  10. Convert pandas DataFrame to a nested dict
  11. Random row selection in Pandas dataframe
  12. converting currency with $ to numbers in Python pandas
  13. groupby weighted average and sum in pandas dataframe
  14. Lookup Values by Corresponding Column Header in Pandas 1.2.0 or newer
  15. How to spread a column in a Pandas data frame
  16. Python Pandas: Boolean indexing on multiple columns [duplicate]
  17. Can Pandas plot a histogram of dates?
  18. group by week in pandas
  19. Executing an SQL query over a pandas dataset
  20. Locate first and last non NaN values in a Pandas DataFrame
  21. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  22. Time Series Analysis – unevenly spaced measures – pandas + statsmodels
  23. Pandas reindex dates in Groupby
  24. matplotlib savefig() size control
  25. Find index of all rows with null values in a particular column in pandas dataframe
  26. Normalize DataFrame by group
  27. Color a scatter plot by Column Values
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment