Skip to content

Instantly share code, notes, and snippets.

Hao yinhao0424

Block or report user

Report or block yinhao0424

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View README.md

Here is a dataset containing the information about H1-B visa application from 10/1/2018 to 6/30/2019 from The Office of Foreign Labor Certification (OFLC) .

Questions:

  1. The number of different case status,and the percantage of each stats within each case status
  2. Different salaries in different states.
  3. What's the distribution of the amount of pepitions within US.

Attributs: case status, Employee_state : Categorical

View README.md

The dataset was downloaded from kaggle containing flight delay information.

Question: Which destination and departure suffers the dealy most? Top 5 companyies that delay most. Which time of a day suffers delay most? Will different distance influence the delay?

Attribute: Original_airport, destination_airport: categorical

View README.md

Here is a ramen rating dataset about ramen products review from kaggle. This dataset is republished as-is from the original BIG LIST on theramerater.

Questions:

  1. what's the different styles between different countries?
  2. Top 5 brands
  3. distribution of stars, also the distribution of stars in different countries

Attribute country, style,brand: categorical

View Google_app.csv
We can't make this file beautiful and searchable because it's too large.
App,Category,Rating,Reviews,Size,Installs,Type,Price,Content Rating,Genres,Last Updated,Current Ver,Android Ver
Photo Editor & Candy Camera & Grid & ScrapBook,ART_AND_DESIGN,4.1,159,19M,"10,000+",Free,0,Everyone,Art & Design,"January 7, 2018",1.0.0,4.0.3 and up
Coloring book moana,ART_AND_DESIGN,3.9,967,14M,"500,000+",Free,0,Everyone,Art & Design;Pretend Play,"January 15, 2018",2.0.0,4.0.3 and up
"U Launcher Lite – FREE Live Cool Themes, Hide Apps",ART_AND_DESIGN,4.7,87510,8.7M,"5,000,000+",Free,0,Everyone,Art & Design,"August 1, 2018",1.2.4,4.0.3 and up
Sketch - Draw & Paint,ART_AND_DESIGN,4.5,215644,25M,"50,000,000+",Free,0,Teen,Art & Design,"June 8, 2018",Varies with device,4.2 and up
Pixel Draw - Number Art Coloring Book,ART_AND_DESIGN,4.3,967,2.8M,"100,000+",Free,0,Everyone,Art & Design;Creativity,"June 20, 2018",1.1,4.4 and up
Paper flowers instructions,ART_AND_DESIGN,4.4,167,5.6M,"50,000+",Free,0,Everyone,Art & Design,"March 26, 2017",1.0,2.3 and up
View College.csv
Private Apps Accept Enroll Top10perc Top25perc F.Undergrad P.Undergrad Outstate Room.Board Books Personal PhD Terminal S.F.Ratio perc.alumni Expend Grad.Rate
Abilene Christian University Yes 1660 1232 721 23 52 2885 537 7440 3300 450 2200 70 78 18.1 12 7041 60
Adelphi University Yes 2186 1924 512 16 29 2683 1227 12280 6450 750 1500 29 30 12.2 16 10527 56
Adrian College Yes 1428 1097 336 22 50 1036 99 11250 3750 400 1165 53 66 12.9 30 8735 54
Agnes Scott College Yes 417 349 137 60 89 510 63 12960 5450 450 875 92 97 7.7 37 19016 59
Alaska Pacific University Yes 193 146 55 16 44 249 869 7560 4120 800 1500 76 72 11.9 2 10922 15
Albertson College Yes 587 479 158 38 62 678 41 13500 3335 500 675 67 73 9.4 11 9727 55
Albertus Magnus College Yes 353 340 103 17 45 416 230 13290 5720 500 1500 90 93 11.5 26 8861 63
Albion College Yes 1899 1720 489 37 68 1594 32 13868 4826 450 850 89 100 13.7 37 11487 73
Albright College Yes 1038 839 227 30 63 973 306 15595 4400 300 500 79 84 11.3 23 11644 80
View README.md

The data source is immigration programs from The Office of Foreign Labor Certification (OFLC) including the H1-B visa.

The providing dataset contains data from 2011-2016. And its already cleaned and randomly selected 10000 raws for studying purpose.

  1. wage change along years
  2. distribution of petition
  3. relationship between FULL_TIME_POSITION,SOC_NAME, status,
  • h1b_1.csv: this file are grouped by 'YEAR' and 'CASE_STATUS' and get the number of case status in different years.
  • h1b_2.csv: this file shows the number of petition in each year.
You can’t perform that action at this time.