text_plain_output_1.png
import matplotlib.pyplot as plt

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

df = pd.read_csv('../input/BRAZIL_CITIES.csv', sep=';', decimal=',')

df.fillna(0.0, inplace=True)

mask1 = df['LONG'] != 0
mask2 = df['LAT'] != 0
mask3 = df['CAPITAL'] == 1
plt.figure(figsize=(10, 10))
plt.title('Cities Latitude and Longitude')
plt.xlabel('Longitude')
plt.ylabel('Latitude')
plt.scatter(df[mask1 & mask2 & mask3]['LONG'], df[mask1 & mask2 & mask3]['LAT'], s=20, alpha=1, label='Capital city')
plt.scatter(df[mask1 & mask2 & ~mask3]['LONG'], df[mask1 & mask2 & ~mask3]['LAT'], s=1, alpha=1, label='Other')
plt.legend()
plt.show()