CSCE489 Data Science Spotlight

Kickstarter Projects Analysis

Instructor: Dr. James Caverlee¶

Student: Yuan-Peng Yu¶

Introduction¶

For many start-up companies, crowdfunding has become an important way to raise initial capital. Kickstarter is a fast growing platform to turn small projects into a mass production. Project creators can present their novelty, get funding, and create successful products. However, there are tons of projects on Kickstarter. How do project creators distinguish their project to catch people’s attentions? What are the buzzwords in popular projects? How do creators set a reachable funding goal? What are the key elements in a successful project?

This spotlight notebook are going to analyze current Kickstarter projects and Kickstarter projects that successfully got funding. The use data mining skills and data visualization to find valuable insights.

Kickstarter 101¶

Kickstarter https://www.kickstarter.com/

Backers = people who support projects and give money to turn

Pledge = the money you give to support project creators realize their product. After the product turning into mass production, you will be reward to get the product.

1. Read dataset and cleaning¶

Data Sources¶

The datasets are scraped from Kickstarter.com and are shared by Kaggle.com. https://www.kaggle.com/socathie/kickstarter-project-statistics

The most_backed.csv contains top 4000 finished projects that have the highest number of backers.
The live.csv contains the current projects that are still seeking people's support.

import pandas as pd
import csv
import warnings
 
# warnings.simplefilter(action = "ignore", category = SettingWithCopyWarning)
warnings.simplefilter("ignore", pd.core.common.SettingWithCopyWarning)  # ignore SettingWithCopyWarning

rawData = pd.read_csv('most_backed.csv', sep=',', index_col=None) # index_col =False: ignore index
print rawData.shape
rawData.head()

(4000, 13)

mostBacked = rawData[['title','blurb','category','by','goal','amt.pledged','num.backers','pledge.tier','num.backers.tier','location','currency','url']]
new_name = ['name','intro','category','creator','goal','pledge_amount','num_backers','pledge_tiers','num_backers_tier','location','currency','url']
mostBacked.columns = new_name
mostBacked.intro = mostBacked.intro.str.replace('\n','')  # replace \n
mostBacked.head()

print mostBacked.dtypes

name                 object
intro                object
category             object
creator              object
goal                float64
pledge_amount       float64
num_backers           int64
pledge_tiers         object
num_backers_tier     object
location             object
currency             object
url                  object
dtype: object

rawCurrent = pd.read_csv('live.csv', sep=',', index_col=None) # index_col =False: ignore index
print rawCurrent.shape
rawCurrent.head()

(4000, 13)

currentProj = rawCurrent[['title','blurb','by','amt.pledged','currency','percentage.funded','end.time','location','country','state','type','url']]
new_name2 = ['name','intro','creator','pledge_amount','currency','percentage_funded','end_time','location','country','state','type','url']
currentProj.columns = new_name2
currentProj.intro = currentProj.intro.str.replace('\n','')  # replace \n
print currentProj.shape
currentProj.head()

(4000, 12)

Data cleaning:¶

First, we have to unify the unit of currency to 'usd'.

### Data cleaning 
### Unify currency to 'usd'

# Find currency !=USD 
currency = mostBacked.groupby(['currency']).sum()
currency2 = currentProj.groupby(['currency']).sum()

print 'Types of currency in the successful projects: \n',currency.index
print '\nTypes of currency in the current projects: \n',currency2.index
currency2

Types of currency in the successful projects: 
Index([u'aud', u'cad', u'chf', u'dkk', u'eur', u'gbp', u'nzd', u'sek', u'usd'], dtype='object', name=u'currency')

Types of currency in the current projects: 
Index([u'aud', u'cad', u'chf', u'dkk', u'eur', u'gbp', u'hkd', u'nok', u'nzd',
       u'sek', u'sgd', u'usd'],
      dtype='object', name=u'currency')

# Clean mostBacked
print type(mostBacked['pledge_amount'])

# currency exchange in the mostBacked projects     
mostBacked.loc[ mostBacked.currency == 'aud' , 'pledge_amount'] = mostBacked.pledge_amount * 0.759288       
mostBacked.loc[ mostBacked.currency == 'cad' , 'pledge_amount'] = mostBacked.pledge_amount * 0.740975
mostBacked.loc[ mostBacked.currency == 'chf' , 'pledge_amount'] = mostBacked.pledge_amount * 1.01280
mostBacked.loc[ mostBacked.currency == 'dkk' , 'pledge_amount'] = mostBacked.pledge_amount * 0.146245
mostBacked.loc[ mostBacked.currency == 'eur' , 'pledge_amount'] = mostBacked.pledge_amount * 1.08834
mostBacked.loc[ mostBacked.currency == 'gbp' , 'pledge_amount'] = mostBacked.pledge_amount * 1.25450
mostBacked.loc[ mostBacked.currency == 'nzd' , 'pledge_amount'] = mostBacked.pledge_amount * 0.720357
mostBacked.loc[ mostBacked.currency == 'sek' , 'pledge_amount'] = mostBacked.pledge_amount * 0.110457       
mostBacked['pledge_amount'] = mostBacked.pledge_amount.astype(int)  # turn into integer

# update goal vaule if the currency is not 'usd'
mostBacked.loc[ mostBacked.currency == 'aud' , 'goal'] = mostBacked.goal * 0.759288       
mostBacked.loc[ mostBacked.currency == 'cad' , 'goal'] = mostBacked.goal * 0.740975
mostBacked.loc[ mostBacked.currency == 'chf' , 'goal'] = mostBacked.goal * 1.01280
mostBacked.loc[ mostBacked.currency == 'dkk' , 'goal'] = mostBacked.goal * 0.146245
mostBacked.loc[ mostBacked.currency == 'eur' , 'goal'] = mostBacked.goal * 1.08834
mostBacked.loc[ mostBacked.currency == 'gbp' , 'goal'] = mostBacked.goal * 1.25450
mostBacked.loc[ mostBacked.currency == 'nzd' , 'goal'] = mostBacked.goal * 0.720357
mostBacked.loc[ mostBacked.currency == 'sek' , 'goal'] = mostBacked.goal * 0.110457       
mostBacked['goal'] = mostBacked.goal.astype(int)  # turn into integer
#mostBacked[ mostBacked.currency == 'aud']  # check the correctness of currency exchange
# mostBacked[['pledge_amount','goal','currency']]

# mostBacked = mostBacked.drop('currency', axis=1) 
print mostBacked.shape
mostBacked

<class 'pandas.core.series.Series'>
(4000, 12)

# Clean current project
print type(currentProj['pledge_amount'])

# currency exchange in the mostBacked projects     
currentProj.loc[ currentProj.currency == 'aud' , 'pledge_amount'] = currentProj.pledge_amount * 0.759288       
currentProj.loc[ currentProj.currency == 'cad' , 'pledge_amount'] = currentProj.pledge_amount * 0.740975
currentProj.loc[ currentProj.currency == 'chf' , 'pledge_amount'] = currentProj.pledge_amount * 1.01280
currentProj.loc[ currentProj.currency == 'dkk' , 'pledge_amount'] = currentProj.pledge_amount * 0.146245
currentProj.loc[ currentProj.currency == 'eur' , 'pledge_amount'] = currentProj.pledge_amount * 1.08834
currentProj.loc[ currentProj.currency == 'gbp' , 'pledge_amount'] = currentProj.pledge_amount * 1.25450
currentProj.loc[ currentProj.currency == 'nzd' , 'pledge_amount'] = currentProj.pledge_amount * 0.720357
currentProj.loc[ currentProj.currency == 'sek' , 'pledge_amount'] = currentProj.pledge_amount * 0.110457       

currentProj.loc[ currentProj.currency == 'hkd' , 'pledge_amount'] = currentProj.pledge_amount * 0.128889       
currentProj.loc[ currentProj.currency == 'nok' , 'pledge_amount'] = currentProj.pledge_amount * 0.119013       
currentProj.loc[ currentProj.currency == 'sgd' , 'pledge_amount'] = currentProj.pledge_amount * 0.707506       
currentProj['pledge_amount'] = currentProj.pledge_amount.astype(int)  # turn into integer

currentProj[ currentProj.currency == 'sgd']

<class 'pandas.core.series.Series'>

2. Analyze data¶

To begin with, I would like to show some amazing statistics in the successful Kickstarter projects.

mostBacked.head()

print 'Important numbers in the top 4000 most backed projects:\n'
funding_goal = mostBacked.goal.sum()
total_received = mostBacked.pledge_amount.sum()
ratio = total_received / (funding_goal *1.0)
print "Creators' funding goal: ", format(funding_goal,',') 
print 'Total pledge amount : ',format(total_received,',') # total pledge amount
print 'Ratio = ',ratio 
print
print 'Total number of backers: ',format(mostBacked.num_backers.sum(), ',') 
print 'Total number of creators: ', mostBacked['creator'].nunique()  # unique number of creator
print 'Total number of categories: ', mostBacked['category'].nunique()

Important numbers in the top 4000 most backed projects:

Creators' funding goal:  244,117,549
Total pledge amount :  1,140,176,331
Ratio =  4.67060371395

Total number of backers:  14,331,503
Total number of creators:  3137
Total number of categories:  115

Important Numbers in the most backed projects¶

Total number of backers: 14,331,503
Total number of creators: 3137
Total number of categories: 115

The numbers imply that the Kickstarter platform is very popular. People are willing to support the Kickstarter projects.

### Setup for data visualization
import plotly.plotly as py
import plotly.graph_objs as go
import plotly

### You need to create a plotly account.
### Use the username API key

trace1_why = go.Bar(
    x=['Total funding goal'],
    y=funding_goal,
    name='Total funding goal'
)
trace2_why = go.Bar(
    x=['Total received pledge amount'],
    y=total_received,
    name='Total received pledge amount'
)

data_why = [trace1_why, trace2_why]

layout = go.Layout(
    title='Why use Kickstarter to raise initial capital? <BR> <BR> 4.6 times than expectation!',
    yaxis=dict(title='USD'),
    annotations=[
        dict(
            x='Total funding goal',
            y=funding_goal,
            xref='x',
            yref='y',
            yanchor = 'top',
            text=format(funding_goal,','),
            showarrow=False, 
            font=dict(family='Arial', size=14,color='rgba(245, 246, 249, 1)')
        ),
        dict(
            x='Total received pledge amount',
            y=total_received,
            xref='x',
            yref='y',
            yanchor = 'top',
            text= format(total_received,','),
            showarrow=False,
            font=dict(family='Arial', size=14,color='rgba(245, 246, 249, 1)')
        )
    ]    
)
fig_why = go.Figure(data=data_why, layout=layout)
py.iplot(fig_why, filename='why_use')

What can we learn from the figure?¶

The received pledge is 4.6 times than creators' expectation. The power of crowdfunding is amazing.
You can easily reach the funding goal as long as your product is good.
The number is from the most backed projects. Although the number will be lower when we include all Kickstarter projects, it still shows that Kickstarter is a good funding platform.

### Top projects that earned a high number of the pledge and backers.

top_projects = mostBacked[['name','pledge_amount','num_backers']]
top_projects = top_projects.sort_values(['pledge_amount','num_backers'], ascending=[False,False])
top20_projects = top_projects.iloc[0:20]
top20_projects

# FIGURE: Top Projects
trace0 = go.Scatter(
    x= top20_projects.name,
    y= top20_projects.pledge_amount,
    name='pledge_amount',
    marker=dict(color='#1f77b4')
)
trace1 = go.Scatter(
    x= top20_projects.name,
    y= top20_projects.num_backers, 
    name='num_backers',
    yaxis='y2',
    marker=dict(color='#d62728')
)

data = [trace0, trace1]
layout = go.Layout(
    title='Top 20 Projects with a High Amount of the Pledge and Backers',
    xaxis=dict(
        tickangle=45,
        tickfont=dict(size=10),
    ),
    yaxis=dict(
        title='Amount of Pledge',
        titlefont=dict(color='#1f77b4'),
        tickfont=dict(color='#1f77b4')
    ),
    yaxis2=dict(
        title='Number of Backers',
        titlefont=dict(color='#d62728'),
        tickfont=dict(color='#d62728'),
        anchor='x',         
        overlaying='y',
        side='right'
    ),
    margin=dict(b=160),
)

fig_top = go.Figure(data=data, layout=layout)
py.iplot(fig_top)

What can we learn from the figure?¶

The number of backers is related to the pledge price of the project. Also, some easy but creative ideas can gain much popularity.
- For example, the Exploging Kittens has the highest number of backers, but its total pledge is not the highest. One copy of Exploding Kittens is only $20. https://www.kickstarter.com/projects/elanlee/exploding-kittens
- Another example is the Fidget Cube, the early-bird price is only $14. https://www.kickstarter.com/projects/antsylabs/fidget-cube-a-vinyl-desk-toy
- In contrast, the highest amount of pledge is brought by the Pebble Time. The reason is that its pledge price is high. Its early-bird price still cost $159. https://www.kickstarter.com/projects/597507018/pebble-time-awesome-smartwatch-no-compromises

# What kind of projects can contribute to the amount of the pledge? 
# That is, people are willing to pay to support the Kickstart projects.

grouped = mostBacked[['category','pledge_amount','num_backers']]
groupby_category = grouped.groupby(['category']).sum()
groupby_category_pledge = groupby_category.sort_values(['pledge_amount'], ascending=[False])
print groupby_category_pledge.shape
groupby_category_pledge

(115, 2)

# Figure: Categories vs. the Amount of Pledge
fig_category = {
    'data': [{'labels': groupby_category_pledge.index,
              'values': groupby_category_pledge.pledge_amount,
              'type': 'pie'}],
    'layout': {'title': '115 Categories <br>vs.<br> the Amount of Pledge<br>'}
     }

py.iplot(fig_category)

What can we learn from the figure?¶

From "115 Categories vs. the Amount of Pledge," the figure shows the following points.

Almost 25% of the pledge are contributed by the "Product design category.
Then, the second highest is the "TableTop Games" category. The third highest is the "Video Games." The sum of the two categories is about 30%. It infers that game design projects are money making projects on Kickstarter.
Successful Kickstarter projects are very diversified. There are total 115 categories in the dataset. These diversified projects still contribute to more than 25% in total amount of the pledge.

# What kind of projects are popular to people? 
# That is, people are willing to pay to support the Kickstart projects.

groupby_category_backers = groupby_category.sort_values(['num_backers'], ascending=[False])
print groupby_category_backers.shape
# groupby_category_backers

(115, 2)

# Figure: Categories vs. Number of Backers
fig_category2 = {
    'data': [{'labels': groupby_category_backers.index,
              'values': groupby_category_backers.num_backers,
              'type': 'pie'}],
    'layout': {'title': '115 Categories <br>vs.<br> the Number of Backers<br>'}
     }

py.iplot(fig_category2)

What can we learn from the figure?¶

From "115 Categories vs. the Number of Backers," the figure shows the following points.

The most popular categories become video games, but the percentage is close to the second popular categories, product design.
The sum of the video games and table top games is about 38.1%. It infers that people willing to support if they feel fun.
In the figure, the contribution of diversified categoried increases. The contribution is larger than 25%.

# What kind of Kickstarter projects are popular among backers? 
groupby_category_backers = groupby_category.sort_values(['num_backers'], ascending=[False])
print groupby_category_backers.shape
groupby_category_backers10 = groupby_category_backers.iloc[0:10]
groupby_category_backers10 # top 20 categories with the highest number of backers

(115, 2)

backers_x = groupby_category_backers10.index
backers_y = groupby_category_backers10.num_backers

trace_backers = go.Bar(
    x= backers_x,
    y= backers_y,
    marker=dict(
        color='rgba(55, 128, 191, 0.7)',
        line=dict(color='rgba(55, 128, 191, 1.0)',width=2)),
        
)

data = [trace_backers]
layout = go.Layout(
    title='Categories vs. Number of Backers',
    font=dict(family='Arial', size=18,color='rgb(0, 0, 0)'),
    xaxis=dict(
        title='Categories',
        titlefont=dict(
            size=16,
            color='rgb(15, 15, 15)'
        ),
        tickfont=dict(
            size=14,
            color='rgb(107, 107, 107)'
        )
    ),
    yaxis=dict(
        title='Number of Backers',
        titlefont=dict(
            size=16,
            color='rgb(15, 15, 15)'
        ),
        tickfont=dict(
            size=14,
            color='rgb(107, 107, 107)'
        )
    ),
    bargap=0.15,
    annotations = [dict(
            x=xi,
            y=yi,
            text=str(format(yi,',')),
            font=dict(family='Arial', size=14,color='rgba(66, 119, 244, 1)'),
            xanchor='auto',
            yanchor='bottom',
            showarrow=False,
        ) for xi, yi in zip(backers_x, backers_y)]
)

fig = go.Figure(data=data, layout=layout)
py.iplot(fig, filename='cat_vs_backer')

What can we learn from the figure?¶

The figure, "Categories vs. Backers," shows the following points.

People are willing to support Kickstarter projects that are belong to the game category.
People are willing to support projects that have concreate prototypes. Projects in the product design usually combine existing product with creative ideas.
There is a huge gap between the first three categories and others.

# 
fig = {
    'data': [
        {
            'x': mostBacked[ mostBacked['category'] == directory ]['pledge_amount'],
            'y': mostBacked[ mostBacked['category'] == directory ]['num_backers'],
            'name': directory, 'mode': 'markers',            
        } for directory in groupby_category_backers.index
    ],
    'layout': {
        'title': 'The distribution of the Pledge & Backers in 4000 Projects <br> (Colors annotates categories)',
        'xaxis': {'title': 'The Amount of the Pledge '},
        'yaxis': {'title': "Number of Backers"}
    }
}
py.iplot(fig)

Notes for the figure.¶

The goal of the figure is to show the distribution of pledge and backers for the 4000 most backed projects.
It use the amount of the pledge as Y axis and the number of backers as X axis.
4000 points display in the figure.
The color of points means the cagetory that the project is belonged to.

What can we learn from the figure?¶

Although the 4000 projects are successful, the figure shows that there is a limitation.
- threshold of pledge = 5 million USD
- threshold of backers = 50,000 people

### Find the location distribution of most backed projects.
import re

def IsInUS(item):
    states = ['IA', 'KS', 'UT', 'VA', 'NC', 'NE', 'SD', 'AL', 'ID', 'FM', 'DE', 'AK', 'CT', 'PR', 'NM', 'MS', 'PW', 'CO', 'NJ', 'FL', 'MN', 'VI', 'NV', 'AZ', 'WI', 'ND', 'PA', 'OK', 'KY', 'RI', 'NH', 'MO', 'ME', 'VT', 'GA', 'GU', 'AS', 'NY', 'CA', 'HI', 'IL', 'TN', 'MA', 'OH', 'MD', 'MI', 'WY', 'WA', 'OR', 'MH', 'SC', 'IN', 'LA', 'MP', 'DC', 'MT', 'AR', 'WV', 'TX']
    pattern = re.compile(r'\b(' + '|'.join(states) + r')\b', re.IGNORECASE)
    match = pattern.search(item)
    if match:
        flag = 'US'
    else:
        flag = item
    return flag

mostBacked_US = mostBacked[ mostBacked.currency == 'usd']
mostBacked_US = mostBacked_US[['name','location']]
mostBacked_US['city'] = mostBacked_US.location.str.split(',').str[0]
mostBacked_US['state'] = mostBacked_US.location.str.split(',').str[1]
mostBacked_US['coutry'] = mostBacked_US.state.apply(IsInUS)

US_only = mostBacked_US[ mostBacked_US['coutry'] == 'US']
US_only['occurrence'] = 1
print US_only.shape
US_only

(3039, 6)

occurrence = US_only.groupby(['city','state']).sum()
occurrence.reset_index(inplace = True)
occurrence['city_s'] = occurrence['city'] +','+ occurrence['state']
occurrence = occurrence.sort_values(['occurrence'], ascending=[False])
occurrence20 = occurrence.iloc[0:20]
occurrence20 = occurrence20.sort_values(['occurrence'], ascending=[True])
occurrence20

# Top 20 cities that create Kickstarter projects

source1 = occurrence20.city_s
source2 = occurrence20.occurrence
trace1 = go.Bar(
    y= source1,
    x= source2,
    orientation = 'h',
    marker = dict(
        color = 'rgba(50, 171, 96, 0.6)',
        line = dict(color = 'rgba(50, 171, 96, 1.0)',width = 2)
    )
)
# annotations = []
# for ydn, yd, xd in zip(y_nw, y_s, x_saving):
# # labeling the bar value
#     annotations.append(dict(xref='x1', yref='y1',
#                             y=xd, x=yd + 3,
#                             text=str(yd) + '%',
#                             font=dict(family='Arial', size=12,
#                                       color='rgb(50, 171, 96)'),
#                             showarrow=False))
data = [trace1]
layout = go.Layout(
    title='Top 20 cities that created successful Kickstarter projects ',
    bargap=0.2,
    margin=dict(l=160),
    annotations=[
        dict(x=xi,
             y=yi,
             text=str(xi),
             xanchor='left',
             yanchor='middle',
             showarrow=False,
             font=dict(family='Arial', size=12,color='rgb(50, 171, 96)')
        ) for xi, yi in zip(source2, source1)]
)

fig = go.Figure(data=data, layout=layout)
py.iplot(fig, filename='marker-h-bar')

What can we learn from the figure?¶

In the top 20 cities that created suffessful Kickstarter projects, San Francisco generates the highest number of ideas for Kickstarter projects.

California has 5 cities on the list.
Then, New York ranks the second place. Seattle ranks the third.

occurrence20.groupby(['state','city']).sum()

import numpy as np
### find creators that create more than one projects and receive lots of pledges.
creator_related = mostBacked[['name','creator']].groupby('creator').count()
count = creator_related.name
new = pd.DataFrame(count)
new = new.rename(columns = {'name':'proj_count'})
# new.reset_index(inplace = True)
good_creators = new[new.proj_count >= 5 ]  # creators that have created 5 successful projects
print good_creators.shape
good_creators

(42, 1)

# value_list = ['Cheapass Games']
value_list = good_creators.index
creator_pl_num = mostBacked[['creator','pledge_amount','num_backers','name']]
creator_pl_num = creator_pl_num[ creator_pl_num.creator.isin(value_list)]
creator_pl_num = creator_pl_num.sort_values(['creator','pledge_amount','num_backers','name'], ascending=[False,False,False,False])
creator_pl= creator_pl_num.groupby('creator').sum()
creator_pl['proj_count'] = good_creators['proj_count'] 
creator_pl.reset_index(inplace = True)
print creator_pl.shape
creator_pl

(42, 4)

# FIGURE: Find good project creators.

trace0 = go.Bar(
    x= creator_pl.creator,
    y= creator_pl.pledge_amount,
    name='$ pledge',
    marker=dict(color='#1f77b4')
)
trace1 = go.Scatter(
    x= creator_pl.creator,
    y= creator_pl.proj_count, 
    name='# of Created Projects',
    yaxis='y2',
    marker=dict(color='#d62728')
)

data = [trace0, trace1]
layout = go.Layout(
    title='Pledges and the Number of Finished Projects for  Creators',
    xaxis=dict(
        title="Creators' Name",
        tickangle=45,
        tickfont=dict(size=10),
    ),
    yaxis=dict(
        title='Amount of Pledges',
        titlefont=dict(color='#1f77b4'),
        tickfont=dict(color='#1f77b4')
    ),
    yaxis2=dict(
        title='Number of Created Projects',
        titlefont=dict(color='#d62728'),
        tickfont=dict(color='#d62728'),
        anchor='x',         
        overlaying='y',
        side='right'
    ),
    margin=dict(b=160),
)

fig_top = go.Figure(data=data, layout=layout)
py.iplot(fig_top)

The purpose of the figure is to find successful leaders in these start-up projects. We can find good targets for capital investment. I set 5 as the threshold value for the number of created projects. That is, these selected created have created at least 5 successful projects and has gained the back-up from people.

What can we learn from the figure?¶

CoolMiniOrNot is definitely a good investment target. The company has created 24 projects. It also earned beyond 25 million USD.
The company, Peak Design, only have 6 projects. However, these projects are lucrative and bring a high amount of pledges. This company is also a good investment target.
Michael Mindes has created 20 projects. Richard Thomas has created 17 projects. It means that they are smart and creative. However, the total pledge is not high enough. They might need a help from marking and financial teams in order to make more money.

Conclusion:¶

Kickstarter provide a good platform for project creators and small companies. They can turn their creative projects to product.
Gaming related products are popular on Kickstarter.
If you would like to earn more pledge or popularity, the product should not just an idea, or prototype.
The drawback is that Kickstarter projects are hard to get 5 million USD and 50,000 backers, based on the analysis of history.

	Unnamed: 0	amt.pledged	blurb	by	category	currency	goal	location	num.backers	num.backers.tier	pledge.tier	title	url
0	0	8782571.0	\nThis is a card game for people who are into ...	Elan Lee	Tabletop Games	usd	10000.0	Los Angeles, CA	219382	[15505, 202934, 200, 5]	[20.0, 35.0, 100.0, 500.0]	Exploding Kittens	/projects/elanlee/exploding-kittens
1	1	6465690.0	\nAn unusually addicting, high-quality desk to...	Matthew and Mark McLachlan	Product Design	usd	15000.0	Denver, CO	154926	[788, 250, 43073, 21796, 41727, 21627, 12215, ...	[1.0, 14.0, 19.0, 19.0, 35.0, 35.0, 79.0, 79.0...	Fidget Cube: A Vinyl Desk Toy	/projects/antsylabs/fidget-cube-a-vinyl-desk-toy
2	2	5408916.0	\nBring Reading Rainbow’s library of interacti...	LeVar Burton & Reading Rainbow	Web	usd	1000000.0	Los Angeles, CA	105857	[19639, 14343, 9136, 2259, 5666, 24512, 4957, ...	[5.0, 10.0, 25.0, 30.0, 35.0, 50.0, 75.0, 100....	Bring Reading Rainbow Back for Every Child, Ev...	/projects/readingrainbow/bring-reading-rainbow...
3	3	5702153.0	\nUPDATED: This is it. We're making a Veronica...	Rob Thomas	Narrative Film	usd	2000000.0	San Diego, CA	91585	[5938, 8423, 11509, 22997, 23227, 1865, 7260, ...	[1.0, 10.0, 25.0, 35.0, 50.0, 75.0, 100.0, 150...	The Veronica Mars Movie Project	/projects/559914737/the-veronica-mars-movie-pr...
4	4	3336371.0	\nAn adventure game from Tim Schafer, Double F...	Double Fine and 2 Player Productions	Video Games	usd	400000.0	San Francisco, CA	87142	[47946, 24636, 1090, 11530, 900, 148, 100, 10, 4]	[15.0, 30.0, 60.0, 100.0, 250.0, 500.0, 1000.0...	Double Fine Adventure	/projects/doublefine/double-fine-adventure

	name	intro	category	creator	goal	pledge_amount	num_backers	pledge_tiers	num_backers_tier	location	currency	url
0	Exploding Kittens	This is a card game for people who are into ki...	Tabletop Games	Elan Lee	10000.0	8782571.0	219382	[20.0, 35.0, 100.0, 500.0]	[15505, 202934, 200, 5]	Los Angeles, CA	usd	/projects/elanlee/exploding-kittens
1	Fidget Cube: A Vinyl Desk Toy	An unusually addicting, high-quality desk toy ...	Product Design	Matthew and Mark McLachlan	15000.0	6465690.0	154926	[1.0, 14.0, 19.0, 19.0, 35.0, 35.0, 79.0, 79.0...	[788, 250, 43073, 21796, 41727, 21627, 12215, ...	Denver, CO	usd	/projects/antsylabs/fidget-cube-a-vinyl-desk-toy
2	Bring Reading Rainbow Back for Every Child, Ev...	Bring Reading Rainbow’s library of interactive...	Web	LeVar Burton & Reading Rainbow	1000000.0	5408916.0	105857	[5.0, 10.0, 25.0, 30.0, 35.0, 50.0, 75.0, 100....	[19639, 14343, 9136, 2259, 5666, 24512, 4957, ...	Los Angeles, CA	usd	/projects/readingrainbow/bring-reading-rainbow...
3	The Veronica Mars Movie Project	UPDATED: This is it. We're making a Veronica M...	Narrative Film	Rob Thomas	2000000.0	5702153.0	91585	[1.0, 10.0, 25.0, 35.0, 50.0, 75.0, 100.0, 150...	[5938, 8423, 11509, 22997, 23227, 1865, 7260, ...	San Diego, CA	usd	/projects/559914737/the-veronica-mars-movie-pr...
4	Double Fine Adventure	An adventure game from Tim Schafer, Double Fin...	Video Games	Double Fine and 2 Player Productions	400000.0	3336371.0	87142	[15.0, 30.0, 60.0, 100.0, 250.0, 500.0, 1000.0...	[47946, 24636, 1090, 11530, 900, 148, 100, 10, 4]	San Francisco, CA	usd	/projects/doublefine/double-fine-adventure

	Unnamed: 0	amt.pledged	blurb	by	country	currency	end.time	location	percentage.funded	state	title	type	url
0	0	15823.0	\n'Catalysts, Explorers & Secret Keepers: Wome...	Museum of Science Fiction	US	usd	2016-11-01T23:59:00-04:00	Washington, DC	186	DC	Catalysts, Explorers & Secret Keepers: Women o...	Town	/projects/1608905146/catalysts-explorers-and-s...
1	1	6859.0	\nA unique handmade picture book for kids & ar...	Tyrone Wells & Broken Eagle, LLC	US	usd	2016-11-25T01:13:33-05:00	Portland, OR	8	OR	The Whatamagump (a hand-crafted story picture ...	Town	/projects/thewhatamagump/the-whatamagump-a-han...
2	2	17906.0	\nA horror comedy about a repairman who was in...	Tessa Stone	US	usd	2016-11-23T23:00:00-05:00	Los Angeles, CA	102	CA	Not Drunk Enough Volume 1!	Town	/projects/1890925998/not-drunk-enough-volume-1...
3	3	67081.0	\nThe Johnny Wander autobio omnibus you've all...	Johnny Wander	US	usd	2016-11-01T23:50:00-04:00	Brooklyn, NY	191	NY	Our Cats Are More Famous Than Us: A Johnny Wan...	County	/projects/746734715/our-cats-are-more-famous-t...
4	4	32772.0	\nThe vision for this project is the establish...	Beau's All Natural Brewing Company	RW	cad	2016-11-18T23:05:48-05:00	Kigali, Rwanda	34	Kigali Province	The Rwanda Craft Brewery Project	Town	/projects/beaus/the-rwanda-craft-brewery-proje...

	name	intro	creator	pledge_amount	currency	percentage_funded	end_time	location	country	state	type	url
0	Catalysts, Explorers & Secret Keepers: Women o...	'Catalysts, Explorers & Secret Keepers: Women ...	Museum of Science Fiction	15823.0	usd	186	2016-11-01T23:59:00-04:00	Washington, DC	US	DC	Town	/projects/1608905146/catalysts-explorers-and-s...
1	The Whatamagump (a hand-crafted story picture ...	A unique handmade picture book for kids & art ...	Tyrone Wells & Broken Eagle, LLC	6859.0	usd	8	2016-11-25T01:13:33-05:00	Portland, OR	US	OR	Town	/projects/thewhatamagump/the-whatamagump-a-han...
2	Not Drunk Enough Volume 1!	A horror comedy about a repairman who was in t...	Tessa Stone	17906.0	usd	102	2016-11-23T23:00:00-05:00	Los Angeles, CA	US	CA	Town	/projects/1890925998/not-drunk-enough-volume-1...
3	Our Cats Are More Famous Than Us: A Johnny Wan...	The Johnny Wander autobio omnibus you've all b...	Johnny Wander	67081.0	usd	191	2016-11-01T23:50:00-04:00	Brooklyn, NY	US	NY	County	/projects/746734715/our-cats-are-more-famous-t...
4	The Rwanda Craft Brewery Project	The vision for this project is the establishme...	Beau's All Natural Brewing Company	32772.0	cad	34	2016-11-18T23:05:48-05:00	Kigali, Rwanda	RW	Kigali Province	Town	/projects/beaus/the-rwanda-craft-brewery-proje...

	pledge_amount	percentage_funded
currency
aud	768984.0	6512
cad	1630181.0	20849
chf	293419.0	2232
dkk	1255652.0	2080
eur	3104335.0	25873
gbp	1590632.0	30070
hkd	625431.0	1438
nok	104314.0	1100
nzd	94234.0	811
sek	883509.0	1560
sgd	166325.0	2261
usd	30408050.0	293873

Kickstarter Projects Analysis

Abstract

Conclusions

Development Tools

CSCE489 Data Science Spotlight

Kickstarter Projects Analysis

Instructor: Dr. James Caverlee¶

Student: Yuan-Peng Yu¶

Introduction¶

Kickstarter 101¶

1. Read dataset and cleaning¶

Data Sources¶

Data cleaning:¶

2. Analyze data¶

Important Numbers in the most backed projects¶

What can we learn from the figure?¶

What can we learn from the figure?¶

What can we learn from the figure?¶

What can we learn from the figure?¶

What can we learn from the figure?¶

Notes for the figure.¶

What can we learn from the figure?¶

What can we learn from the figure?¶

What can we learn from the figure?¶

Conclusion:¶

	name	intro	creator	pledge_amount	currency	percentage_funded	end_time	location	country	state	type	url
180	MAG: The wallet made with a touch of magic	Split up for a more organized wallet. Stack th...	Mag wallet	8679	sgd	204	2016-11-25T08:59:22-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/magwallet/mag-the-wallet-made-with-a...
201	Quotidian Pen - The World’s First Magnetic Pro...	A minimal pen with a magnetic mechanism that w...	Quotidian	23368	sgd	825	2016-11-27T23:00:00-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1829030706/quotidian-pen-the-worlds-...
394	Deuce Wallet: The Best 2-in-1 Minimalist Bifol...	Deuce is a discreet slim wallet that carries a...	Alphonso Ngiam	10344	sgd	487	2016-12-16T20:00:12-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1554982336/deuce-wallet-the-best-2-i...
802	PatchWork Cerberus Volume 1	An independent author creating an anime-esque ...	DAINIME	39	sgd	4	2016-10-31T00:28:00-04:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/312732587/patchwork-cerberus-volume-...
1101	Stay STRESS-FREE with Scented Colour Pencil Co...	Coloring book for adults can generate the exac...	Anu Jeane Sugamal	1	sgd	0	2016-11-04T07:29:00-04:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1513577411/stay-stress-free-with-sce...
1362	HALFOLD - Wallet / Card Keeper	A wallet/card keeper, hand-folded from leather...	HALFOLD	705	sgd	66	2016-11-10T12:47:27-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1304787386/halfold-leather-card-keep...
1618	Salt Fever (or the Last Fast Place in Australia)	An intimate, gritty story about passion, the p...	Olivier Maigniez	287	sgd	0	2016-11-29T08:55:39-05:00	Gairdner, AU	AU	WA	Town	/projects/48265689/salt-fever-or-the-last-fast...
1675	STOP HUMAN TRAFFICKING \| DEVADASI	Life is a gift, it should NEVER be on sale. A...	Nishmen Nair	0	sgd	0	2016-11-18T08:44:00-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1493488652/stop-human-trafficking-de...
1772	The Jotternique Campaign: Jotter Book That Is ...	Jot down important notes, creative inspiration...	ClickPress	1	sgd	0	2016-11-09T00:48:43-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1023777138/the-jotternique-campaign-...
1881	Investing Stocks under the Art of War	A sharing of my stock investment experience fr...	Fields in Plenty	1	sgd	0	2016-11-24T09:18:50-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/694142527/investing-stocks-under-the...
1943	2017 Privé Planner: Plan. Organize. Dream.	This isn't just a planner, it's a powerful too...	Privé Planner	403	sgd	19	2016-11-18T23:00:00-05:00	New York, NY	US	NY	Town	/projects/620455599/2017-prive-planner-plan-or...
2386	Singlish Can Lah! – Learn Singlish the fun way	Learn one of the world's most difficult creole...	Benjamin Sun	595	sgd	8	2016-11-21T02:20:09-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/benjaminsun/singlish-can-lah-learn-s...
2418	Murphy’s Law Breaker - CARD Storage & Generator	Unlimited power in your pocket. Credit-card si...	CARD	23987	sgd	226	2016-12-14T06:00:06-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/156937076/murphys-law-breaker-card-s...
2521	Swagalls: Shop Without Any Guilt!	Singapore's first online fashion swapping plat...	Raye Padit	2317	sgd	14	2016-11-13T13:12:10-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/fashionpreneur/swagalls-shop-without...
2575	Demon Espionage	A fast-paced social deduction party game for 3...	JiaJie Tan	4069	sgd	52	2016-11-29T08:01:06-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1887688573/demon-espionage?ref=disco...
2577	Black Rain - weatherproof bag for the true urb...	A tote that doubles as a sling bag. Hardy enou...	BLND	333	sgd	15	2016-10-31T03:10:19-04:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/2131427610/black-rain-weatherproof-b...
2581	PoetryWannabe - My life, if it were a poem	Experiencing life as an average boy and fancif...	Clement Teo	0	sgd	0	2016-11-23T12:09:18-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/825269171/poetrywannabe-my-life-if-i...
2588	Lunar Eclipse, HORROR VR GAME (BETA DL AVAIL)	Stumble into an Ancient Mansion whose Darkest ...	Kaiju Den	5946	sgd	14	2016-11-09T01:40:26-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/kaijuden/lunar-eclipse-mobile-vr-gam...
2729	E-commerce Home Design	The future of Home Designing	Dan & Jim	0	sgd	0	2016-11-13T21:28:46-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1527087401/e-commerce-home-design?re...
2750	PLEXFIT: The Next Generation Arm Sling	PLEXFIT is a patent pending, lightweight sling...	Abhishek D. Mohla and Anthony J. Cooper	19346	sgd	101	2016-10-30T00:57:23-04:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1808489115/plexfit-the-next-generati...
2751	The Record Apps (virtual karaoke & guitar tracks)	Record App Studio features karaoke singing fro...	The Rock Business	0	sgd	0	2016-12-10T04:56:05-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/900411779/the-record-app?ref=discovery
2848	Who Are You	Back us for this groundbreaking horror-comedy ...	Trilogy Productions	0	sgd	0	2016-11-23T11:20:34-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/whoareyou/who-are-you-0?ref=discovery
2893	MEATPOSSIBLE	Deceptively simple, addictive and fun gameplay...	Tan Qi Rong	10	sgd	0	2016-11-29T12:54:36-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1815587166/meatpossible?ref=discovery
2932	Body X - 乡音The Rehearsal	A site-specific and immersive murder-mystery t...	Yeo Kok Siew	2179	sgd	25	2016-11-18T10:59:00-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1382286118/body-x-the-rehearsal?ref=...
3358	WeatherHYDE: an all season life-saving tent	The world's only reversible all season family ...	billionBricks	7832	sgd	8	2016-12-01T17:02:06-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/billionbricks/weatherhyde-an-all-sea...
3442	Screening 声の形 (Koe no Katachi) in Singapore	Support us to make the screening of 声の形 (Koe n...	Daniel Lim	73	sgd	2	2016-11-03T00:29:09-04:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/888516849/screening-koe-no-katachi-i...
3555	Khaloo-World's Most Minimal Phone Holder	Khaloo is a Minimalist and Functional Phone an...	Avarash Design Studio	1574	sgd	34	2016-11-07T08:44:13-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/aliarash/worlds-most-minimal-phone-h...
3831	Blockprinting Workshop	MATTER is bringing our 4th generation artisan ...	MATTER Prints	1627	sgd	46	2016-11-06T11:00:00-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/308655289/blockprinting-workshop?ref...
3866	Tripp's Tipples - Rock and Rye and other spiri...	Creating a line of infusions that will take yo...	Shawn Tripp	3930	sgd	111	2016-11-14T16:34:00-05:00	Singapore, Singapore	SG	Central Singapore	Town	/projects/1247420547/tripps-tipples-rock-and-r...
3893	Vikings X - Gunnar Hamundarson and the Flaming...	A fictional marriage of historically strong vi...	JJ Ang	17	sgd	0	2016-11-01T13:34:59-04:00	Hayward, CA	US	CA	Town	/projects/998072842/vikings-x-gunnar-hamundars...
3929	A Little Help For My Project	A photographic project to capture nature throu...	Mohamed Hafiz Jumain	0	sgd	0	2016-11-26T20:50:54-05:00	Bukit Batok, Singapore	SG	South West	Town	/projects/hafizjumain/a-little-help-for-my-pro...

	name	pledge_amount	num_backers
5	Pebble Time - Awesome Smartwatch, No Compromises	20338986	78471
17	COOLEST COOLER: 21st Century Cooler that's Act...	13285226	62642
13	Pebble 2, Time 2 + All-New Pebble Core	12779843	66673
11	Pebble: E-Paper Watch for iPhone and Android	10266845	68929
21	The World's Best TRAVEL JACKET with 15 Feature...	9192055	44949
0	Exploding Kittens	8782571	219382
16	OUYA: A New Kind of Video Game Console	8596474	63416
40	The Everyday Backpack, Tote, and Sling	6565782	26359
1	Fidget Cube: A Vinyl Desk Toy	6465690	154926
10	Shenmue 3	6333295	69320
68	Pono Music - Where Your Soul Rediscovers Music	6225354	18220
19	Bring Back MYSTERY SCIENCE THEATER 3000	5764229	48270
3	The Veronica Mars Movie Project	5702153	91585
14	Bloodstained: Ritual of the Night	5545991	64867
2	Bring Reading Rainbow Back for Every Child, Ev...	5408916	105857
79	The Everyday Messenger: A Bag For Cameras & Es...	4869472	17029
34	Dark Souls\u2122 - The Board Game	4731314	31178
6	Torment: Tides of Numenera	4188927	74405
58	Zombicide: Black Plague	4079204	20915
7	Pillars of Eternity (formerly Project Eternity)	3986929	73986

	pledge_amount	num_backers
category
Product Design	276407357	2801518
Tabletop Games	199230355	2460853
Video Games	143490771	3000001
Hardware	68620455	624712
Technology	61913898	568784
Gadgets	32977050	355290
Wearables	28372860	203211
Design	20711234	279935
Sound	20300270	105782
Documentary	18447326	290974
3D Printing	17127392	78065
Narrative Film	15801736	217480
Food	14179796	161523
Gaming Hardware	13295440	86568
Fashion	13216560	202598
Animation	11258932	178891
Comics	11204855	211310
DIY Electronics	10946563	139711
Camera Equipment	10913629	59803
Apparel	9583527	85561
Games	9064551	98998
Film & Video	7196489	101835
Web	6385967	127791
Robots	6253036	42547
Television	5764229	48270
Music	5517998	113876
Space Exploration	4926014	69478
Webseries	4482041	82706
Art Books	4428692	71773
Flight	4191194	30771
...	...	...
Spaces	309864	3025
Childrenswear	285755	4635
Thrillers	280607	4294
Print	266944	6252
Vegan	264535	6510
Painting	259641	2712
Audio	204349	3145
Poetry	171182	3131
Movie Theaters	158692	2324
Mobile Games	148003	2406
Dance	146075	4133
Metal	141115	4625
Photo	140602	2502
Conceptual Art	128515	2782
Digital Art	128328	2766
Romance	121084	1334
Calendars	117328	2285
Jewelry	108893	1111
People	107193	2687
Literary Journals	106257	4604
Fabrication Tools	102864	1642
Academic	91474	1461
Food Trucks	85470	1625
Video	85176	1183
Jazz	60526	1287
Zines	60431	1153
Installations	58916	1185
Stationery	47165	1326
Young Adult	35587	1199
Music Videos	33837	1541

	name	location	city	state	coutry	occurrence
0	Exploding Kittens	Los Angeles, CA	Los Angeles	CA	US	1
1	Fidget Cube: A Vinyl Desk Toy	Denver, CO	Denver	CO	US	1
2	Bring Reading Rainbow Back for Every Child, Ev...	Los Angeles, CA	Los Angeles	CA	US	1
3	The Veronica Mars Movie Project	San Diego, CA	San Diego	CA	US	1
4	Double Fine Adventure	San Francisco, CA	San Francisco	CA	US	1
5	Pebble Time - Awesome Smartwatch, No Compromises	Palo Alto, CA	Palo Alto	CA	US	1
6	Torment: Tides of Numenera	Newport Beach, CA	Newport Beach	CA	US	1
7	Pillars of Eternity (formerly Project Eternity)	Irvine, CA	Irvine	CA	US	1
11	Pebble: E-Paper Watch for iPhone and Android	Palo Alto, CA	Palo Alto	CA	US	1
13	Pebble 2, Time 2 + All-New Pebble Core	Redwood City, CA	Redwood City	CA	US	1
15	Joking Hazard	Dallas, TX	Dallas	TX	US	1
16	OUYA: A New Kind of Video Game Console	Los Angeles, CA	Los Angeles	CA	US	1
17	COOLEST COOLER: 21st Century Cooler that's Act...	Portland, OR	Portland	OR	US	1
18	Wasteland 2	Newport Beach, CA	Newport Beach	CA	US	1
19	Bring Back MYSTERY SCIENCE THEATER 3000	Minneapolis, MN	Minneapolis	MN	US	1
20	WISH I WAS HERE	Los Angeles, CA	Los Angeles	CA	US	1
21	The World's Best TRAVEL JACKET with 15 Feature...	Chicago, IL	Chicago	IL	US	1
22	Planetary Annihilation - A Next Generation RTS	Kirkland, WA	Kirkland	WA	US	1
23	Divinity: Original Sin 2	Sacramento, CA	Sacramento	CA	US	1
24	BATTLETECH - Tactical 'Mech Combat Returns to ...	Kirkland, WA	Kirkland	WA	US	1
25	CHIP - The World's First Nine Dollar Computer	Oakland, CA	Oakland	CA	US	1
26	PINE A64, First $15 64-Bit Single Board Super ...	San Francisco, CA	San Francisco	CA	US	1
27	Shadowrun Returns	Bellevue, WA	Bellevue	WA	US	1
29	Secret Hitler	Chicago, IL	Chicago	IL	US	1
30	Star Citizen	Los Angeles, CA	Los Angeles	CA	US	1
31	The Bard's Tale IV	Newport Beach, CA	Newport Beach	CA	US	1
32	Double Fine's MASSIVE CHALICE	San Francisco, CA	San Francisco	CA	US	1
33	Shadowrun: Hong Kong	Kirkland, WA	Kirkland	WA	US	1
35	Million Dollars, But... The Game	Austin, TX	Austin	TX	US	1
36	Pressy - the Almighty Android Button!	New York, NY	New York	NY	US	1
...	...	...	...	...	...	...
3954	Gauntlet of Fools	San Francisco, CA	San Francisco	CA	US	1
3956	JourneyQuest Season 2	Seattle, WA	Seattle	WA	US	1
3957	BattleCON Online - The Fighting Card Game, Now...	Albuquerque, NM	Albuquerque	NM	US	1
3959	Phoenix: Dawn Command - a card based role play...	Portland, OR	Portland	OR	US	1
3960	The World's First Ready to Drink GrassFed Butt...	Los Angeles, CA	Los Angeles	CA	US	1
3961	The Lost Work of Will Eisner	Philadelphia, PA	Philadelphia	PA	US	1
3962	Edge of Space	Raleigh, NC	Raleigh	NC	US	1
3963	Keep Your Shirt Tucked In With Premium Shirt S...	St. Louis, MO	St. Louis	MO	US	1
3965	Ubooly: We're on a quest to build a toy that m...	Boulder, CO	Boulder	CO	US	1
3966	'Submarine Sandwich' \u2014 a film by PES	Santa Monica, CA	Santa Monica	CA	US	1
3967	Bumprz, the most minimal iPhone case. Pre-Orde...	Oakland, CA	Oakland	CA	US	1
3971	Victory Belles	San Diego, CA	San Diego	CA	US	1
3972	Kingdom	Seattle, WA	Seattle	WA	US	1
3973	Midcentury Americana - Awesome Wood Toys	Brooklyn, NY	Brooklyn	NY	US	1
3975	Lono Sprinkler Controller	American Fork, UT	American Fork	UT	US	1
3977	Kiki: toolbox meets key ring!	Wayland, MA	Wayland	MA	US	1
3980	UNFORGETTABLE: Bold Flavors from a Renegade Life	Berkeley, CA	Berkeley	CA	US	1
3981	BADbandanas\u2014100% cotton and 100% bad	Pittsburgh, PA	Pittsburgh	PA	US	1
3982	Grave: Open World Survival Horror	Phoenix, AZ	Phoenix	AZ	US	1
3983	Schlock Mercenary The Board Game	Houston, TX	Houston	TX	US	1
3985	How to Make a Freaking iPhone App - iOS 9 Adve...	Provo, UT	Provo	UT	US	1
3986	Bull & Stash Notebooks	Portland, OR	Portland	OR	US	1
3987	Manual Tea Maker N\xba1	Chicago, IL	Chicago	IL	US	1
3988	A One Year Student Reporting Lab within Homici...	Washington, DC	Washington	DC	US	1
3989	Master Thief	Toledo, OH	Toledo	OH	US	1
3992	B-Squares: Modular Solar Powered Electrics.	Seattle, WA	Seattle	WA	US	1
3993	Boosted Boards - The World's Lightest Electric...	Palo Alto, CA	Palo Alto	CA	US	1
3994	Seed Money: Coins You Can Plant!	Oakland, CA	Oakland	CA	US	1
3995	Savage Worlds: Rippers Resurrected RPG!	Chandler, AZ	Chandler	AZ	US	1
3996	GoBone: The world's first smartbone	Dallas, TX	Dallas	TX	US	1

	city	state	occurrence	city_s
350	Philadelphia	PA	24	Philadelphia, PA
245	Las Vegas	NV	24	Las Vegas, NV
405	San Jose	CA	27	San Jose, CA
73	Cambridge	MA	28	Cambridge, MA
331	Oakland	CA	29	Oakland, CA
495	Washington	DC	30	Washington, DC
445	St. Louis	MO	30	St. Louis, MO
113	Dallas	TX	39	Dallas, TX
31	Atlanta	GA	43	Atlanta, GA
399	Salt Lake City	UT	48	Salt Lake City, UT
55	Boston	MA	56	Boston, MA
33	Austin	TX	60	Austin, TX
403	San Diego	CA	62	San Diego, CA
362	Portland	OR	84	Portland, OR
67	Brooklyn	NY	103	Brooklyn, NY
94	Chicago	IL	121	Chicago, IL
421	Seattle	WA	147	Seattle, WA
315	New York	NY	209	New York, NY
270	Los Angeles	CA	271	Los Angeles, CA
404	San Francisco	CA	278	San Francisco, CA

		occurrence
state	city
CA	Los Angeles	271
	Oakland	29
	San Diego	62
	San Francisco	278
	San Jose	27
DC	Washington	30
GA	Atlanta	43
IL	Chicago	121
MA	Boston	56
MA	Cambridge	28
MO	St. Louis	30
NV	Las Vegas	24
NY	Brooklyn	103
NY	New York	209
OR	Portland	84
PA	Philadelphia	24
TX	Austin	60
TX	Dallas	39
UT	Salt Lake City	48
WA	Seattle	147

	proj_count
creator
Action Phase Games	6
Albino Dragon	6
Ananda Svarupa Das	5
Ares Games	5
Arrowstorm Entertainment	5
Artipia Games	5
Brian @ MGoBlog	5
Cheapass Games	7
Chris Birch, Modiphius	5
CoolMiniOrNot	24
Crash Games	5
Dan Provost & Tom Gerhardt	6
David B. Talton Jr.	8
Dice Hate Me Games	8
Don Moyer	7
FarSight Studios	5
Fred Hicks / Evil Hat Productions	7
Game Salute	12
Gamelyn Games	7
GreaterThanGames	6
IronSpike	7
Jackson Robinson	6
Jamey Stegmaier	6
Lomography	6
LudiCreations	5
Mantic Games	12
Michael Mindes	20
Minion Games	5
Monte Cook Games	7
PLX Devices	5
Peak Design	6
PlayWay	5
Queen Games	10
Richard Thomas	17
Ryan Laukat	5
Sandy Petersen	5
Seth Hiatt	11
Steven Elliot	5
Travis	14
Zachary Weiner	6
chadwick parker & joe huang	6
sekaiproject	10

	creator	pledge_amount	num_backers	proj_count
0	Action Phase Games	620793	12437	6
1	Albino Dragon	992389	20359	6
2	Ananda Svarupa Das	425833	18679	5
3	Ares Games	1187157	9260	5
4	Arrowstorm Entertainment	494190	8230	5
5	Artipia Games	720414	9575	5
6	Brian @ MGoBlog	292932	10329	5
7	Cheapass Games	2194450	30176	7
8	Chris Birch, Modiphius	1688951	14184	5
9	CoolMiniOrNot	26133816	160894	24
10	Crash Games	135578	9057	5
11	Dan Provost & Tom Gerhardt	660156	20728	6
12	David B. Talton Jr.	1334553	15181	8
13	Dice Hate Me Games	719292	15788	8
14	Don Moyer	620984	12331	7
15	FarSight Studios	378201	12569	5
16	Fred Hicks / Evil Hat Productions	1328216	28305	7
17	Game Salute	1069947	19764	12
18	Gamelyn Games	2025857	62051	7
19	GreaterThanGames	2437805	19555	6
20	IronSpike	621360	17737	7
21	Jackson Robinson	721305	11265	6
22	Jamey Stegmaier	3180361	37529	6
23	Lomography	5596997	24843	6
24	LudiCreations	305778	8293	5
25	Mantic Games	7004192	36944	12
26	Michael Mindes	2284586	82343	20
27	Minion Games	442063	10813	5
28	Monte Cook Games	2720312	18659	7
29	PLX Devices	1264024	17797	5
30	Peak Design	13695945	69299	6
31	PlayWay	160473	10735	5
32	Queen Games	1380999	16015	10
33	Richard Thomas	4291617	38944	17
34	Ryan Laukat	858544	13856	5
35	Sandy Petersen	3490297	14661	5
36	Seth Hiatt	800385	23331	11
37	Steven Elliot	532748	21906	5
38	Travis	1392883	47342	14
39	Zachary Weiner	1408581	34584	6
40	chadwick parker & joe huang	1056421	20388	6
41	sekaiproject	1679807	22626	10

	name	intro	category	creator	goal	pledge_amount	num_backers	pledge_tiers	num_backers_tier	location	currency	url
0	Exploding Kittens	This is a card game for people who are into ki...	Tabletop Games	Elan Lee	10000	8782571	219382	[20.0, 35.0, 100.0, 500.0]	[15505, 202934, 200, 5]	Los Angeles, CA	usd	/projects/elanlee/exploding-kittens
1	Fidget Cube: A Vinyl Desk Toy	An unusually addicting, high-quality desk toy ...	Product Design	Matthew and Mark McLachlan	15000	6465690	154926	[1.0, 14.0, 19.0, 19.0, 35.0, 35.0, 79.0, 79.0...	[788, 250, 43073, 21796, 41727, 21627, 12215, ...	Denver, CO	usd	/projects/antsylabs/fidget-cube-a-vinyl-desk-toy
2	Bring Reading Rainbow Back for Every Child, Ev...	Bring Reading Rainbow’s library of interactive...	Web	LeVar Burton & Reading Rainbow	1000000	5408916	105857	[5.0, 10.0, 25.0, 30.0, 35.0, 50.0, 75.0, 100....	[19639, 14343, 9136, 2259, 5666, 24512, 4957, ...	Los Angeles, CA	usd	/projects/readingrainbow/bring-reading-rainbow...
3	The Veronica Mars Movie Project	UPDATED: This is it. We're making a Veronica M...	Narrative Film	Rob Thomas	2000000	5702153	91585	[1.0, 10.0, 25.0, 35.0, 50.0, 75.0, 100.0, 150...	[5938, 8423, 11509, 22997, 23227, 1865, 7260, ...	San Diego, CA	usd	/projects/559914737/the-veronica-mars-movie-pr...
4	Double Fine Adventure	An adventure game from Tim Schafer, Double Fin...	Video Games	Double Fine and 2 Player Productions	400000	3336371	87142	[15.0, 30.0, 60.0, 100.0, 250.0, 500.0, 1000.0...	[47946, 24636, 1090, 11530, 900, 148, 100, 10, 4]	San Francisco, CA	usd	/projects/doublefine/double-fine-adventure
5	Pebble Time - Awesome Smartwatch, No Compromises	Color e-paper smartwatch with up to 7 days of ...	Product Design	Pebble Technology	500000	20338986	78471	[159.0, 179.0, 179.0, 250.0, 250.0, 338.0, 400...	[10000, 22991, 5278, 19999, 6041, 4717, 4998, ...	Palo Alto, CA	usd	/projects/597507018/pebble-time-awesome-smartw...
6	Torment: Tides of Numenera	A story-driven CRPG set in the world of Monte ...	Video Games	inXile entertainment	900000	4188927	74405	[5.0, 20.0, 25.0, 28.0, 35.0, 39.0, 45.0, 50.0...	[317, 14992, 11711, 10995, 4303, 3503, 10271, ...	Newport Beach, CA	usd	/projects/inxile/torment-tides-of-numenera
7	Pillars of Eternity (formerly Project Eternity)	Pillars of Eternity is an isometric, party-bas...	Video Games	Obsidian Entertainment	1100000	3986929	73986	[5.0, 20.0, 25.0, 35.0, 50.0, 65.0, 80.0, 100....	[317, 25000, 20921, 8394, 5727, 3818, 769, 104...	Irvine, CA	usd	/projects/obsidian/project-eternity
8	Yooka-Laylee - A 3D Platformer Rare-vival!	The creative talent behind Banjo-Kazooie and D...	Video Games	Playtonic Games	219537	2622035	73206	[8.0, 15.0, 23.0, 31.0, 46.0, 54.0, 85.0, 85.0...	[1324, 22974, 21683, 6821, 5140, 5859, 149, 49...	Derby, UK	gbp	/projects/playtonic/yooka-laylee-a-3d-platform...
9	ZNAPS - Connection is just a snap away	ZNAPS is a magnetic adapter specially designed...	Technology	ZNAPS	88917	2228385	70122	[9.0, 9.0, 13.0, 15.0, 17.0, 21.0, 24.0, 42.0,...	[11463, 13904, 97, 4699, 22858, 942, 8267, 454...	Toronto, Canada	cad	/projects/1041610927/znaps-the-9-magnetic-adap...
10	Shenmue 3	Yu Suzuki presents the long awaited third inst...	Video Games	Ys Net	2000000	6333295	69320	[5.0, 29.0, 39.0, 60.0, 60.0, 80.0, 100.0, 120...	[2251, 26238, 382, 4671, 14668, 2062, 6539, 17...	Tokyo, Japan	usd	/projects/ysnet/shenmue-3
11	Pebble: E-Paper Watch for iPhone and Android	Pebble is a customizable watch. Download new w...	Product Design	Pebble Technology	100000	10266845	68929	[1.0, 99.0, 115.0, 125.0, 220.0, 235.0, 240.0,...	[2615, 200, 40799, 14350, 3800, 100, 4925, 900...	Palo Alto, CA	usd	/projects/597507018/pebble-e-paper-watch-for-i...
12	Mighty No. 9	Classic Japanese side-scrolling action, evolve...	Video Games	comcept USA, LLC	900000	3845170	67226	[5.0, 20.0, 40.0, 60.0, 60.0, 80.0, 99.0, 120....	[2438, 34059, 6445, 7289, 4472, 1716, 3593, 22...	Tokyo, Japan	usd	/projects/mightyno9/mighty-no-9
13	Pebble 2, Time 2 + All-New Pebble Core	Two affordable, heart rate-enabled smartwatche...	Product Design	Pebble Technology	1000000	12779843	66673	[69.0, 79.0, 99.0, 109.0, 149.0, 169.0, 169.0,...	[5000, 2798, 8546, 234, 679, 9996, 2042, 13446...	Redwood City, CA	usd	/projects/597507018/pebble-2-time-2-and-core-a...
14	Bloodstained: Ritual of the Night	IGAVANIA (n): A gothic, exploration-focused ac...	Video Games	Koji Igarashi	500000	5545991	64867	[5.0, 28.0, 60.0, 60.0, 100.0, 125.0, 150.0, 1...	[913, 20155, 16450, 6569, 8799, 3085, 2920, 14...	Tokyo, Japan	usd	/projects/iga/bloodstained-ritual-of-the-night
15	Joking Hazard	From the creators of Cyanide & Happiness comes...	Tabletop Games	Cyanide And Happiness	10000	3246588	63758	[1.0, 25.0, 35.0, 45.0, 60.0, 75.0, 100.0, 102...	[435, 6491, 26903, 18140, 7395, 1841, 1279, 1,...	Dallas, TX	usd	/projects/cyanideandhappiness/joking-hazard
16	OUYA: A New Kind of Video Game Console	Cracking open the last closed platform: the TV...	Gaming Hardware	OUYA	950000	8596474	63416	[10.0, 25.0, 95.0, 99.0, 140.0, 225.0, 699.0, ...	[1770, 1898, 1000, 46124, 7755, 2500, 600, 226...	Los Angeles, CA	usd	/projects/ouya/ouya-a-new-kind-of-video-game-c...
17	COOLEST COOLER: 21st Century Cooler that's Act...	The COOLEST is a portable party disguised as a...	Product Design	Ryan Grepper	50000	13285226	62642	[5.0, 25.0, 55.0, 165.0, 165.0, 185.0, 185.0, ...	[1078, 311, 133, 50, 20, 50213, 7063, 2455, 31...	Portland, OR	usd	/projects/ryangrepper/coolest-cooler-21st-cent...
18	Wasteland 2	Wasteland 2 has been released to great acclaim...	Video Games	inXile entertainment	900000	2933252	61290	[15.0, 30.0, 50.0, 55.0, 75.0, 100.0, 150.0, 1...	[32778, 8828, 7967, 2274, 1130, 5218, 776, 407...	Newport Beach, CA	usd	/projects/inxile/wasteland-2
19	Bring Back MYSTERY SCIENCE THEATER 3000	You did it: you brought back MYSTERY SCIENCE T...	Television	Joel Hodgson	2000000	5764229	48270	[10.0, 25.0, 35.0, 50.0, 75.0, 85.0, 100.0, 10...	[5319, 3024, 5269, 7452, 1649, 3543, 11148, 8,...	Minneapolis, MN	usd	/projects/mst3k/bringbackmst3k
20	WISH I WAS HERE	"Hell, there are no rules here - we're trying ...	Narrative Film	Zach Braff	2000000	3105473	46520	[10.0, 20.0, 30.0, 40.0, 60.0, 75.0, 100.0, 10...	[9133, 6208, 5706, 9952, 2952, 254, 449, 500, ...	Los Angeles, CA	usd	/projects/1869987317/wish-i-was-here-1
21	The World's Best TRAVEL JACKET with 15 Feature...	TRAVEL JACKET with built-in Neck Pillow, Eye M...	Product Design	BAUBAX LLC	20000	9192055	44949	[5.0, 25.0, 89.0, 99.0, 99.0, 109.0, 109.0, 10...	[319, 334, 100, 200, 970, 50, 1735, 1824, 3559...	Chicago, IL	usd	/projects/597538543/the-worlds-best-travel-jac...
22	Planetary Annihilation - A Next Generation RTS	Planetary Annihilation brings RTS gameplay to ...	Video Games	Uber Entertainment Inc	900000	2229344	44162	[15.0, 20.0, 40.0, 50.0, 90.0, 95.0, 100.0, 14...	[5000, 18720, 5513, 6462, 1543, 1000, 3908, 11...	Kirkland, WA	usd	/projects/659943965/planetary-annihilation-a-n...
23	Divinity: Original Sin 2	An epic RPG with turn-based combat, cooperativ...	Video Games	Larian Studios LLC	500000	2032434	42713	[5.0, 25.0, 26.0, 27.0, 30.0, 40.0, 50.0, 50.0...	[103, 10000, 10000, 3954, 3407, 675, 4109, 466...	Sacramento, CA	usd	/projects/larianstudios/divinity-original-sin-2
24	BATTLETECH - Tactical 'Mech Combat Returns to ...	Missed the Kickstarter? Become a Late Reinforc...	Video Games	Harebrained Schemes LLC	250000	2785537	41733	[1.0, 25.0, 35.0, 50.0, 85.0, 125.0, 275.0, 10...	[574, 18594, 2666, 12114, 2266, 3219, 2140, 52...	Kirkland, WA	usd	/projects/webeharebrained/battletech
25	CHIP - The World's First Nine Dollar Computer	Built for work, play, and everything in betwee...	Hardware	Next Thing Co.	50000	2071927	39560	[9.0, 9.0, 9.0, 9.0, 19.0, 19.0, 24.0, 49.0, 6...	[5000, 5000, 3996, 627, 1272, 2624, 6200, 3297...	Oakland, CA	usd	/projects/1598272670/chip-the-worlds-first-9-c...
26	PINE A64, First $15 64-Bit Single Board Super ...	PINE A64 is the world's first 64-bit expandabl...	Hardware	PINE64 Inc.	31416	1731465	36781	[1.0, 5.0, 5.0, 15.0, 15.0, 15.0, 16.0, 19.0, ...	[144, 66, 10, 1000, 2555, 159, 15, 300, 1000, ...	San Francisco, CA	usd	/projects/pine64/pine-a64-first-15-64-bit-sing...
27	Shadowrun Returns	Shadowrun Returns brings back one of our most ...	Video Games	Harebrained Schemes LLC	400000	1836447	36276	[15.0, 30.0, 50.0, 60.0, 100.0, 125.0, 175.0, ...	[15502, 8478, 1397, 4378, 1128, 4247, 379, 417...	Bellevue, WA	usd	/projects/webeharebrained/shadowrun-returns
28	Kingdom Come: Deliverance	Realistic single-player RPG set in the medieva...	Video Games	Warhorse Studios	376350	1387942	35384	[5.0, 25.0, 33.0, 33.0, 41.0, 41.0, 49.0, 66.0...	[355, 8653, 6331, 765, 8047, 1817, 4944, 994, ...	Prague, Czech Republic	gbp	/projects/1294225970/kingdom-come-deliverance
29	Secret Hitler	A social deduction game for 5-10 players about...	Tabletop Games	Max Temkin	54450	1479046	34565	[25.0, 30.0, 37.0, 42.0, 90.0, 150.0, 225.0, 3...	[8352, 12447, 3368, 10120, 71, 58, 20, 6]	Chicago, IL	usd	/projects/maxtemkin/secret-hitler
...	...	...	...	...	...	...	...	...	...	...	...	...
3970	The Blackout: Wolves E.P.	We're raising money to finance a self released...	Rock	The Blackout	12545	20940	1113	[8.0, 8.0, 12.0, 17.0, 34.0, 34.0, 34.0, 39.0,...	[480, 30, 200, 18, 19, 22, 146, 140, 15, 5, 29...	Merthyr Tydfil, UK	gbp	/projects/1648679145/the-blackout-wolves-ep
3971	Victory Belles	Finally, an era of WW2 shipgirls dawns on our ...	Video Games	Black Chicken Studios	30000	100348	1113	[5.0, 25.0, 50.0, 75.0, 100.0, 150.0, 250.0, 3...	[310, 323, 89, 70, 43, 128, 27, 54, 4, 11, 1, ...	San Diego, CA	usd	/projects/blackchickenstudios/victory-belles
3972	Kingdom	A game about communities by Ben Robbins, creat...	Tabletop Games	Ben Robbins	2500	30303	1113	[10.0, 19.0, 25.0, 35.0, 45.0, 45.0, 50.0, 100...	[311, 225, 261, 61, 228, 3, 7, 3, 2, 4, 0, 0]	Seattle, WA	usd	/projects/lamemage/kingdom
3973	Midcentury Americana - Awesome Wood Toys	Modernist design flair and roadside car cultur...	Product Design	Vlad Dragusin + Candylab Toys	50000	122264	1113	[7.0, 19.0, 20.0, 24.0, 29.0, 30.0, 32.0, 34.0...	[26, 67, 100, 72, 100, 6, 8, 2, 2, 103, 5, 104...	Brooklyn, NY	usd	/projects/candylab/midcentury-americana-awesom...
3974	Rise of the Kage, ninja board game with detail...	A thrilling stealth board game for two to four...	Tabletop Games	GCT Studios	50180	131906	1112	[1.63, 93.0, 98.0, 142.0, 147.0]	[100, 51, 3, 200, 753]	London, UK	gbp	/projects/1207064031/rise-of-the-kage-ninja-bo...
3975	Lono Sprinkler Controller	Now you can control your sprinklers with your ...	Hardware	Lono	75000	155838	1112	[15.0, 25.0, 125.0, 125.0, 139.0, 139.0, 149.0...	[3, 10, 250, 250, 250, 250, 39, 28, 8, 2, 0]	American Fork, UT	usd	/projects/173231925/lono-sprinkler-controller
3976	Midgard Playing Cards	Norse playing cards designed in the heart of S...	Playing Cards	Design Imperator	12430	55386	1112	[13.0, 13.0, 25.0, 43.0, 57.0, 60.0, 94.0, 100...	[82, 96, 545, 128, 78, 107, 20, 31, 17]	Copenhagen, Denmark	dkk	/projects/653481781/midgard-playing-cards
3977	Kiki: toolbox meets key ring!	Laser cut, etched & wrapped in leather, Kiki i...	Product Design	Dave & Calvin Laituri	1000	42901	1112	[18.0, 20.0, 28.0, 30.0, 40.0, 50.0, 60.0, 80....	[30, 301, 30, 493, 54, 44, 100, 19, 18, 3, 6]	Wayland, MA	usd	/projects/onehundred/kiki-toolbox-meets-keyring
3978	Artbook by Otto Schmidt	Toonbox Studio presents the great girls-artboo...	Art Books	Pavel Muntyan	1000	82811	1112	[20.0, 50.0, 70.0, 90.0, 150.0]	[100, 531, 59, 312, 100]	Omsk, Russia	usd	/projects/muntyan/artbook-by-otto-schmidt