Data Introduction

This data contains those large Tech companies, related with their funding records. The profits and funding of those large tech companies are always the focus of the News and papers. When and how much and how many rounds did they get the funding, is clearly shown in this data.

Details about the data

  1. The document is in .csv format
  2. There are 10 variables and 1460 observations, the size is 91.3kb
  3. The useful variables might be only 6, include:
    1. Company: Listed names of the company.
    2. City: the city this company is located
    3. State: the state this company is located
    4. fundedDate: the date that the company is funded
    5. raisedAmt: amount of money this company raised
    6. round: funding round, round a, round b, or round seed, or angel ,etc.

R Code Output

## Loading tidyverse: ggplot2
## Loading tidyverse: tibble
## Loading tidyverse: tidyr
## Loading tidyverse: readr
## Loading tidyverse: purrr
## Loading tidyverse: dplyr
## Conflicts with tidy packages ----------------------------------------------
## filter(): dplyr, stats
## lag():    dplyr, stats
## 
## Attaching package: 'scales'
## The following object is masked from 'package:purrr':
## 
##     discard
## The following object is masked from 'package:readr':
## 
##     col_factor
## 
## Attaching package: 'lubridate'
## The following object is masked from 'package:base':
## 
##     date
## Executing: 
## "C:\PROGRA~1\IMAGEM~1.5-Q\magick.exe -loop 0 -delay 100
##     Rplot1.png Rplot2.png Rplot3.png Rplot4.png Rplot5.png
##     Rplot6.png Rplot7.png Rplot8.png Rplot9.png Rplot10.png
##     Rplot11.png Rplot12.png Rplot13.png Rplot14.png Rplot15.png
##     Rplot16.png Rplot17.png Rplot18.png Rplot19.png Rplot20.png
##     Rplot21.png Rplot22.png Rplot23.png Rplot24.png Rplot25.png
##     Rplot26.png Rplot27.png Rplot28.png Rplot29.png Rplot30.png
##     Rplot31.png Rplot32.png Rplot33.png "output1.gif""
## Output at: output1.gif
##           Group.1         x
## 235      Facebook 495700000
## 182  Demand Media 355000000
## 897       ZeniMax 309900000
## 403         Kayak 214500000
## 548       OverSee 210000000
## 583 Plastic Logic 195700000
## 561        PayPal 194000000
## 841        VMware 150000000
## 769  Tesla Motors 145500000
## 218        eSolar 140000000
## Source: local data frame [6 x 8]
## Groups: state [1]
## 
## # A tibble: 6 x 8
##    company  state fundedDate raisedAmt  round round_order  years
##     <fctr> <fctr>     <fctr>     <int> <fctr>      <fctr> <fctr>
## 1 Facebook     CA   1-Sep-04    500000  angel       angel   2004
## 2 Facebook     CA   1-May-05  12700000      a           a   2005
## 3 Facebook     CA   1-Apr-06  27500000      b           b   2006
## 4 Facebook     CA   1-Oct-07 300000000      c           c   2007
## 5 Facebook     CA   1-Mar-08  40000000      c           c   2008
## 6 Facebook     CA  15-Jan-08  15000000      c           c   2008
## # ... with 1 more variables: raisedAmt_state <dbl>
## Executing: 
## "C:\PROGRA~1\IMAGEM~1.5-Q\magick.exe -loop 0 -delay 100
##     Rplot1.png Rplot2.png Rplot3.png Rplot4.png Rplot5.png
##     Rplot6.png Rplot7.png Rplot8.png Rplot9.png "output2.gif""
## Output at: output2.gif

Plot

  1. This plot shows the funding amount raised of those technology companies by different states. The funding rounds indicate different rounds of raised funding. There are normally 8 different kinds of fundings, most of the companies do not have all of the funding rounds.
Tech Company Funding raised by State

Tech Company Funding raised by State

  1. Top 10 technology companies were evaluated by their abilities of attracting fundings. Demonstrated by their funding rounds, the plot listed the amount of money those companies were funded together with the funded years.
Top Ten Tech companies and their Funding status by Year

Top Ten Tech companies and their Funding status by Year