biglocalnews / warn-california-analysis

An exploration and analysis of the WARN Notices data for California
0 stars 1 forks source link

Side Bar: How we did our analysis #27

Closed Dilcia19 closed 3 years ago

Dilcia19 commented 3 years ago

Write a side bar explaining how we did our analysis for people not necessarily familiar with programming or jupyter notebook.

Dilcia19 commented 3 years ago

Have a draft:

For our analysis of California’s layoff notices, we collected data from the Employment Development Department. From their website, we gathered records from as far back as 2014 to the end of 2020.

Once we had our data, we sought to answer a few questions: How many people were laid off in 2020? How did that compare to the amount of layoffs in 2019? Can the numbers show how weak hard a county was hit just by comparing the layoff numbers?

In order to answer these questions, we identified possible duplicates from the data by standardizing it and comparing the data. We then removed the duplicates and kept the data that did not fall under the duplication criteria where layoff county, layoff number, layoff notice dates, and layoff city matched.

After that, we used programming to crunch the numbers and figure out where the biggest impacts from layoffs were being felt. We used these numbers as a way to contextualize the already difficult situation for people who are in danger of being evicted or those dealing with housing instability due to the pandemic.

Dilcia19 commented 3 years ago

Want to find some examples of side-bars on #ddj stories so that I can have an idea of the structure/format - ie, am I over writing this section.

Dilcia19 commented 3 years ago

Examples Cheryl shared:

Dilcia19 commented 3 years ago

Can't finish this side bar about how we actually did the story without making all the updates and changes - moving ticket back to TO DO.

Dilcia19 commented 3 years ago

It's done: https://docs.google.com/document/d/1B0vQb2UWizPQuP9173FEya1W-4aE5dGoW47c0iLGY2Q/edit