Hello Community Members, A solution to last week’s challenge can be found here. This challenge was submitted by Yash Thakkar. We appreciate your contribution @yash_thakkar! Some months mark pivotal moments for students and job seekers worldwide, especially when exploring the H-1B job market. The H-1B visa program allows US employers to temporarily hire foreign workers in specialty occupations requiring a combination of highly specialized knowledge and a bachelor's degree or higher in a relevant field, or its equivalent. The dataset provided includes fiscal year 2024 data on employers who have submitted petitions to employ H-1B workers. Your tasks are: * Identify the top 10 companies that submitted the most H-1B petitions in 2024. * Determine the top 10 industries with the highest demand (number of total petitions submitted) for H-1B workers in 2024. Hints: * Exclude companies with missing industry data (Industry (NAICS) Code). * Focus only on approved petitions as follows:* Initial Approval (first-time H-1B employment) * Continuing Approval (extensions or changes for existing H-1B employees) Happy solving! Sources: https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub/understanding-our-h-1b-employer-data-hub The Academy Team Challenge_453_start_file.yxzp Challenge_453_solution_file.yxzp

Challenge Completed Spoiler Challenge_453_Joe_Serpis.yxzp

Spoiler Challenge_453_EHB_completed.yxzp

Another fun little aggregation exercise. Hint: Caching data helps speed up development 😉 My solution: Spoiler Challenge_453_jrlindem_solution.yxzp

Challenge #453: Unlock H-1B Visa Program Trends in 2024

AYXAcademy

Weekly Challenge LMS Banner.png

Hello Community Members,

A solution to last week’s challenge can be found here.

This challenge was submitted by Yash Thakkar. We appreciate your contribution @yash_thakkar!

Some months mark pivotal moments for students and job seekers worldwide, especially when exploring the H-1B job market. The H-1B visa program allows US employers to temporarily hire foreign workers in specialty occupations requiring a combination of highly specialized knowledge and a bachelor's degree or higher in a relevant field, or its equivalent.

The dataset provided includes fiscal year 2024 data on employers who have submitted petitions to employ H-1B workers.

Your tasks are:

Identify the top 10 companies that submitted the most H-1B petitions in 2024.
Determine the top 10 industries with the highest demand (number of total petitions submitted) for H-1B workers in 2024.

Hints:

Exclude companies with missing industry data (Industry (NAICS) Code).
Focus only on approved petitions as follows:
- Initial Approval (first-time H-1B employment)
- Continuing Approval (extensions or changes for existing H-1B employees)

Happy solving!

Sources:

https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub

https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub/understanding-our-h-1b-employer-data-hub

The Academy Team

Challenge_453_start_file.yxzp

Challenge_453_solution_file.yxzp

Data Preparation

Core

Basic

Accepted answers

All comments

ggruccio

I used summarize and sample!

Spoiler

Challenge_453_gg_finish.yxzp

mmontgomery

C453

Spoiler

c453.yxzp

Kenda

Spoiler

Challenge_453_start_file.yxmd

olga_strubbe

Thank you, Yash @yash_thakkar! This was a fun and informative challenge.

Spoiler

Challenge 453_OS.yxmd

nSpire

Spoiler

Challenge_453_nSpire.yxzp

RolandSchubert

Spoiler

Challenge_453_solution_rsc.yxzp

binu_acs

Spoiler

Challenge_453_solution_BV.yxmd

balajilolla2

Spoiler

Solution Attached

Screenshot 2024-12-02 080226.jpg

Challenge_453_start_file.yxmd

peter_gb

A nice little cool down after the advent of code...!

Spoiler

Challenge_453_pgb.yxmd

Spoiler

My solution

Spoiler

Challenge_453_Solution_AAA.yxmd

Tofel

Spoiler

Challenge_453_Dom.yxzp

MelGibson

Spoiler

MG Challenge_453_Solution.yxmd

Bobbyt23

Fun Core challenge.

Spoiler

Weekly Challenge 453 02-12-24.yxzp

Hub119

Solution attached.

Spoiler

Challenge_453_CH Solved.yxzp

tomqlduong

Here is my solution to Challenge #453

Spoiler

Challenge_453_start_file.yxmd

BransonJamesFarley

Fun and Simple!

Spoiler

Challenge 453.yxzp

DaisukeTsuchiya

Spoiler

Challenge_453_start_file_DT.yxzp

Qiu

I think the definition "Highest demand" here is not clear.

The answer in the output is consistent with the counting of record number, but I would argue we should count the actual approved petitions as in Part 1 of the question.

Spoiler

Challenge_453_start_file-Qiu.yxzp

ccanterman

Solved!

I was getting the wrong answer because, similar to @Qiu 's comment, I was using the Approved petitions but the answer seems to be based on Approved + Rejected. I guess that if it was Rejected, it's still part of the demand, but that part of a little unclear.

Spoiler

Challenge_453_start_file.yxzp

sobirjon_alteryx

my solution

Challenge_453.yxmd

Walz777

solved

Challenge_453_WMS_solved.yxmd

Spainey

Nice easy one to solve alongside Advent of Code

Spoiler

Insert picture button not working - will try again later

Challenge_453_mark-spain.yxmd

Sebastian_Chaieb2

Solution attached

Spoiler

Challenge_453_Solution_SC.yxmd

Powerhouse_21

Spoiler

PH21_Challenge_453.yxmd

AYXAcademy

Hi @Qiu and @Carolyn ,

Thank you for raising this question!

When we refer to 'highest demand,' we are specifically referring to the number of petitions submitted by each company, regardless of whether they were approved. It is based purely on the volume of petitions filed, not on the number of approved petitions.