I have data frame which looks like :
Id survey suvery_link Primary_call alternate call
1 form1 link1 7/18/19
1 form1 link1 8/18/19
2 form1 link1 8/18/19
2 form1 link1 9/18/19
3 form1 link1 8/18/19
3 form1 link1 9/18/19
4 form1 link1 7/18/19
4 form1 link1 8/18/19
1 form2 link2 8/18/19
1 form2 link2 9/18/19
2 form2 link2 7/18/19
2 form2 link2 8/18/19
3 form2 link2 7/18/19
3 form2 link2 8/18/19
4 form2 link2 8/18/19
4 form2 link2 9/18/19
I am trying to get new data frame as following
Id survey suvery_link Primary_call alternate call
1 form1 link1 7/18/19 8/18/19
1 form2 link2 8/18/19 9/18/19
2 form1 link1 8/18/19 9/18/19
2 form2 link2 7/18/19 8/18/19
3 form1 link1 8/18/19 9/18/19
3 form2 link2 7/18/19 8/18/19
4 form1 link1 7/18/19 8/18/19
4 form2 link2 8/18/19 9/18/19
I used the following code but is not code
df.sort_values(['Id','survey',survey_link','Primary_call','alternate call']).drop_duplicate('ID')
its not working
Aucun commentaire:
Enregistrer un commentaire