Extracting unique consecutive values from a Pandas dataframe

Asked Feb 01 '21 at 01:23

Active Feb 27 '21 at 17:23

Viewed 289 times

I have an Excel file that contains the following information

and I need to extract that data into a dataframe with unique values from column ID and value 1; so that I will end up with something like this:

I have done the following:

df=pd.read_excel(file)
dfUnique=pd.unique(df[["column ID","value1"]]).values.ravel('K')

but I get the following error:

could not broadcast input array from shape (5,2) into shape (5)

edited Feb 27 '21 at 17:23

halfer

asked Feb 01 '21 at 01:23

Little

1

`df.groupby(['column ID','value1']).first()` or `df.groupby(['column ID','value1']).head()` – wwnde Feb 01 '21 at 01:27
1

thank you sir, it worked – Little Feb 01 '21 at 01:45
1

`df.drop_duplicates(['column ID', 'value1'])`. – Quang Hoang Feb 01 '21 at 03:00

0 Answers0