Removing Duplicates
To remove the duplicate rows, simply use function drop_duplicates(). To change the current dataframe, add inplace=True.
9
1
2
3
new_data = data.drop_duplicates() # data is not modified
# or
data.drop_duplicates(inplace=True) # data is modified
123new_data = data.drop_duplicates() # data is not modified # or data.drop_duplicates(inplace=True) # data is modified
Tarefa
Swipe to start coding
The planets dataset is given to you. Remove the duplicates and then check the new shape of dataframe. Compare it with the original shape.
Note that dataframe may have only distinct records, in this case, the shape will remain the same.
Solução
9
1
2
3
4
5
6
7
8
import pandas as pd
import numpy as np
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/10db3746-c8ff-4c55-9ac3-4affa0b65c16/planets.csv')
print(data.shape)
data.drop_duplicates(inplace=True)
print(data.shape)
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 2. Capítulo 7
9
1
2
3
4
5
import pandas as pd
import numpy as np
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/10db3746-c8ff-4c55-9ac3-4affa0b65c16/planets.csv')
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
