text_html_output_1.png
import pandas as pd #for data wrangling

noise_complaints_data = pd.read_csv('../input/Noise_Complaints.csv')

noise_complaints_data.isna().sum()

noise_complaints_data.drop(['Status', 'Due Date', 'Agency', 'Agency Name', 'Landmark', 'Facility Type', 'Status', 'Due Date', 'Resolution Description', 'Community Board', 'Park Facility Name', 'Park Borough', 'Vehicle Type', 'Taxi Company Borough', 'Taxi Pick Up Location', 'Bridge Highway Name', 'Bridge Highway Direction', 'Road Ramp', 'Bridge Highway Segment'], axis=1)

comp_type = noise_complaints_data['Complaint Type'].value_counts()
comp_type