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
Завдання
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.
Рішення
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)
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 2. Розділ 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')
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
