Mapping Employee

Inspiration

We wanted to use People Data Labs' API to make something unique and visually-focused. So we examined where employees for a specific company live because we thought it might help companies make decisions about the locations of their offices, especially since the COVID-19 pandemic has shifted people from in-person to remote working, and some companies could go back to the office.

What it does

Given any company available with People Data Labs' API, we can make an interactive plot to show where all the employees are located. The user would just need to input their API key, the company's name, and the amount the employees they want to see. Then the output plotly plot would show the densities of employees for that company

How we built it

We used People Data Labs' Person Search API and Python packages such as plotly, pandas, numpy, etc.

Challenges we ran into

We ran into a lot of challenges. First, we had a lot of initial ideas on what to do with data on professional, but quickly realized we were limited by what was available, like unfortunately we couldn't access employee salaries or company stats over time. We also spent a lot of our time trying to figure out how to display our html visualizations on a website or dashboard, which was unsuccessful.

Accomplishments that we're proud of

This was our first time using plotly, so we were proud that we made something that worked and looked cool. Also, we were proud that made our project very customizable. For example, instead of providing a handful of plots for companies, our code works on any company the user may want to see. And if the user wanted to make more plots, the code makes the CSV file available to them. This was also our fastest turnout of a project.

What we learned

We learned that pulling and getting data in a useable format is important.

What's next for Mapping Employees

We want to somehow scrape the addresses of the company offices (not just the company's HQ) to put on the visualizations. We would also make more visualization, maybe specific to the skills and interests of the employees at a specific company.

Built With

• api
• python