�� : Liza Sukhankina
��

import pandas as pd
df = pd.read_csv('antibiotics_list.csv')
fungal_antibiotics = df[df['Usage'] == 'Fungal infections']
cleaned_df = df.drop_duplicates()
duplicates_substance = cleaned_df[cleaned_df.duplicated('Name', keep=False)]
unique_families = cleaned_df.groupby('Family')['Name'].nunique().nlargest(5)
most_popular_brand = cleaned_df['Popular Brand Name'].mode()[0]
grouped_by_family = cleaned_df.groupby('Family')
print("������� ������������ ��� Fungal infections:")
print(fungal_antibiotics)
print("\n�������� ��� ������������� �������� � ����������� ���������:")
print(duplicates_substance)
print("\n���� ����� ������������ � ����������� ������� ������������ ����������:")
print(unique_families)
print("\n�������� ���������� �����:", most_popular_brand)
print("\n����������� ������ �� ����� �����������:")
for family, group in grouped_by_family:
    print(family)
    print(group)
��
antibiotics_list.csv
��
��������

��
