jeudi 18 juillet 2019

how to check the two rows based on condition and club into single row in python

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