text_plain_output_1.png image_output_1.png
import pandas as pd

import pandas as pd
import numpy as np
import squarify
import matplotlib.pyplot as plt
pd.options.display.float_format = '{:,}'.format

data = pd.read_csv('../input/kickstarter-projects/ks-projects-201801.csv', index_col='ID')

data.sample(5)

data['deadline'] = pd.to_datetime(data['deadline'])
data['launched'] = pd.to_datetime(data['launched'])
data['launched'] = data['launched'].dt.date
data['launched'] = pd.to_datetime(data['launched'])

data.isnull().sum()

data = data[pd.notna(data['usd pledged'])]

data[data.duplicated(keep=False)]

data = data.drop_duplicates(subset=['name', 'category', 'deadline', 'launched'], keep='last')
data = data.drop(columns=['usd pledged', 'pledged'])

print('Days with the most launched projects (top 20):')
data['launched'].value_counts().nlargest(20)