After some search I did not find any way to select unique values in function of another variable.I have a dataframe of two variables (ID, score). In this df, some ID are duplicates, and some scores a
I have an input Pandas Series like this:I would like to remove duplicates in each row. For example, change M,S,S to M,S.I triedfifa22[‘player_positions’] = fifa22[‘player_positions’].str.split(‘,’).
This is how my dataset looks:| hhid | food_code | consumed |…..||———-|————–|————–|…..|| 479 | 01.1.1.1.0.3 | 0.66666667 |…..|| 479 | 01.1.1.2.1
My data frame has different dates as rows. Every unique date occurs appr. 500 times. I want to make a new data frame where every column is a unique date and where the rows are all the observations of