ct_capstone_2_work.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "5f3dff16",
   "metadata": {},
   "source": [
    "## Coding Temple Capstone II - Job Openings and Labor Turnover Survey (BLS)\n",
    "### Harry Hill - May 2023\n",
    "## Step 1: Data Collection\n",
    "Dataset: Jop Openings and Labor Turnover Survey, May 2023, US Bureau of Labor Statistics https://www.bls.gov/jlt/data.htm\n",
    "- myAPI: 2b4ca11bf83746deaa5718b92a582c25\n",
    "\n",
    "Context: The Bureau of Labor Statistics updates a dataset monthly with employment and job vacancy statistics subdivided by industry, business size, and region/state. https://www.bls.gov/news.release/archives/jolts_05032022.pdf\n",
    "- Reported survey of a sample of 20,700 businesses across the United States, from a population of over 9.4 million.\n",
    "- Data is adjusted for regular seasonal changes in these observations.\n",
    "- Labor statistics are ratio-adjusted using employment statistics from the Current Employment Statistics (CES) survey\n",
    "\n",
    "Format: Bureau of Labor Statistics Public Data API, public-use; https://www.bls.gov/developers/api_signature_v2.htm#multiple\n",
    "\n",
    "Defining Question: What are the current trends in the US labor market? \n",
    "- Does 'no one want to work' as some claim, or are there willing workers who are not finding employment? \n",
    "- Are any US industries experiencing more extreme conditions than others? \n",
    "- Are workers voluntarily quitting or are they being fired?\n",
    "- Is the 'Great Resignation' of 2021 still being felt? (3/2022 record 3% quits rate, 7.1% openings rate)\n",
    "- Which industries have had major layoffs? https://mondo.com/insights/mass-layoffs-in-2022-whats-next-for-employees/#:~:text=Candy%20Digital%20layoffs%3A%2033%25%20of,laid%20off%20(November%2C%202022)\n",
    "\n",
    "Hypothesis: If there are openings that are not being taken advantage of in an industry, \n",
    "- Job openings & layoffs rate ~ labor demand (full-time, part-time, and temporary positions)\n",
    "- Quits rate - employment demand"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "42c4a062",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\"JTS000000000000000HIR\", \"JTS000000000000000JOR\", \"JTS000000000000000LDR\", \"JTS000000000000000QUR\", \"JTS000000000000000TSR\", \"JTS000000000000000UOR\", \"JTS100000000000000HIR\", \"JTS100000000000000JOR\", \"JTS100000000000000LDR\", \"JTS100000000000000QUR\", \"JTS100000000000000TSR\", \"JTS230000000000000HIR\", \"JTS230000000000000JOR\", \"JTS230000000000000LDR\", \"JTS230000000000000QUR\", \"JTS230000000000000TSR\", \"JTS300000000000000HIR\", \"JTS300000000000000JOR\", \"JTS300000000000000LDR\", \"JTS300000000000000QUR\", \"JTS300000000000000TSR\", \"JTS400000000000000HIR\", \"JTS400000000000000JOR\", \"JTS400000000000000LDR\", \"JTS400000000000000QUR\", \"JTS400000000000000TSR\", \"JTS510000000000000HIR\", \"JTS510000000000000JOR\", \"JTS510000000000000LDR\", \"JTS510000000000000QUR\", \"JTS510000000000000TSR\", \"JTS510099000000000HIR\", \"JTS510099000000000JOR\", \"JTS510099000000000LDR\", \"JTS510099000000000QUR\", \"JTS510099000000000TSR\", \"JTS540099000000000HIR\", \"JTS540099000000000JOR\", \"JTS540099000000000LDR\", \"JTS540099000000000QUR\", \"JTS540099000000000TSR\", \"JTS600000000000000HIR\", \"JTS600000000000000JOR\", \"JTS600000000000000LDR\", \"JTS600000000000000QUR\", \"JTS600000000000000TSR\", \"JTS900000000000000HIR\", \"JTS900000000000000JOR\", \"JTS900000000000000LDR\", \"JTS900000000000000QUR\", \"JTS900000000000000TSR\"\n"
     ]
    }
   ],
   "source": [
    "# take list of series IDs, split, put into quotes\n",
    "line = \"JTS000000000000000HIR JTS000000000000000JOR JTS000000000000000LDR JTS000000000000000QUR JTS000000000000000TSR JTS000000000000000UOR JTS100000000000000HIR JTS100000000000000JOR JTS100000000000000LDR JTS100000000000000QUR JTS100000000000000TSR JTS230000000000000HIR JTS230000000000000JOR JTS230000000000000LDR JTS230000000000000QUR JTS230000000000000TSR JTS300000000000000HIR JTS300000000000000JOR JTS300000000000000LDR JTS300000000000000QUR JTS300000000000000TSR JTS400000000000000HIR JTS400000000000000JOR JTS400000000000000LDR JTS400000000000000QUR JTS400000000000000TSR JTS510000000000000HIR JTS510000000000000JOR JTS510000000000000LDR JTS510000000000000QUR JTS510000000000000TSR JTS510099000000000HIR JTS510099000000000JOR JTS510099000000000LDR JTS510099000000000QUR JTS510099000000000TSR JTS540099000000000HIR JTS540099000000000JOR JTS540099000000000LDR JTS540099000000000QUR JTS540099000000000TSR JTS600000000000000HIR JTS600000000000000JOR JTS600000000000000LDR JTS600000000000000QUR JTS600000000000000TSR JTS900000000000000HIR JTS900000000000000JOR JTS900000000000000LDR JTS900000000000000QUR JTS900000000000000TSR\"\n",
    "\n",
    "# 1. transform series IDs with quotes\n",
    "import re\n",
    "re.sub(r'(\\w+)', r'\"\\1\"', line)\n",
    "\n",
    "# transform spaced series IDs into neat list with commas and quotes\n",
    "line2 = ', '.join('\"{}\"'.format(word) for word in line.split(' '))\n",
    "\n",
    "print(line2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "ff3a23b6",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n",
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                 SeriesID 2013-M01 2013-M02 2013-M03 2013-M04 2013-M05  \\\n",
      "0   JTS000000000000000HIR      3.3      3.4      3.2      3.4      3.4   \n",
      "1   JTS000000000000000JOR      2.8      2.9      2.9      2.9      3.0   \n",
      "2   JTS000000000000000LDR      1.2      1.2      1.3      1.3      1.3   \n",
      "3   JTS000000000000000QUR      1.7      1.7      1.6      1.7      1.6   \n",
      "4   JTS000000000000000TSR      3.2      3.2      3.1      3.3      3.3   \n",
      "5   JTS000000000000000UOR      3.2      3.0      2.9      2.9      2.8   \n",
      "6   JTS100000000000000HIR      3.7      3.8      3.6      3.8      3.8   \n",
      "7   JTS100000000000000JOR      3.0      3.1      3.1      3.0      3.2   \n",
      "8   JTS100000000000000LDR      1.4      1.4      1.5      1.5      1.5   \n",
      "9   JTS100000000000000QUR      1.9      1.9      1.8      1.9      1.8   \n",
      "10  JTS100000000000000TSR      3.6      3.5      3.5      3.6      3.6   \n",
      "11  JTS230000000000000HIR      5.9      6.5      6.1      5.1      5.8   \n",
      "12  JTS230000000000000JOR      2.1      2.3      2.0      1.9      2.0   \n",
      "13  JTS230000000000000LDR      3.2      3.7      4.1      3.5      3.3   \n",
      "14  JTS230000000000000QUR      2.3      1.8      1.6      1.6      1.6   \n",
      "15  JTS230000000000000TSR      5.7      5.8      5.8      5.2      5.1   \n",
      "16  JTS300000000000000HIR      2.1      2.0      1.8      2.0      2.3   \n",
      "17  JTS300000000000000JOR      2.1      2.3      2.1      2.0      2.0   \n",
      "18  JTS300000000000000LDR      0.9      0.9      0.9      0.9      1.0   \n",
      "19  JTS300000000000000QUR      0.8      0.9      0.8      1.0      1.0   \n",
      "20  JTS300000000000000TSR      1.9      2.0      1.8      2.1      2.2   \n",
      "21  JTS400000000000000HIR      3.5      3.7      3.2      3.5      3.6   \n",
      "22  JTS400000000000000JOR      2.8      2.5      2.8      3.0      3.1   \n",
      "23  JTS400000000000000LDR      1.1      1.2      1.2      1.2      1.4   \n",
      "24  JTS400000000000000QUR      2.1      1.9      1.8      1.9      1.8   \n",
      "25  JTS400000000000000TSR      3.6      3.5      3.3      3.4      3.4   \n",
      "26  JTS510000000000000HIR      2.3      3.1      1.9      2.6      3.0   \n",
      "27  JTS510000000000000JOR      2.8      3.8      3.5      2.4      3.6   \n",
      "28  JTS510000000000000LDR      0.8      0.9      0.4      0.9      1.1   \n",
      "29  JTS510000000000000QUR      1.5      1.2      1.1      1.6      1.3   \n",
      "30  JTS510000000000000TSR      2.6      2.2      1.9      2.7      2.6   \n",
      "31  JTS510099000000000HIR      2.8      2.6      2.3      2.4      2.8   \n",
      "32  JTS510099000000000JOR      2.8      3.7      3.9      3.1      3.8   \n",
      "33  JTS510099000000000LDR      0.9      0.7      0.6      0.6      0.8   \n",
      "34  JTS510099000000000QUR      1.2      1.5      1.2      1.2      1.4   \n",
      "35  JTS510099000000000TSR      2.6      2.7      2.2      2.2      2.7   \n",
      "36  JTS540099000000000HIR      4.8      4.7      4.7      5.0      4.9   \n",
      "37  JTS540099000000000JOR      4.1      4.0      3.9      4.0      4.1   \n",
      "38  JTS540099000000000LDR      2.3      1.9      2.1      2.1      2.1   \n",
      "39  JTS540099000000000QUR      1.9      2.1      2.1      2.4      2.4   \n",
      "40  JTS540099000000000TSR      4.5      4.2      4.4      4.8      4.7   \n",
      "41  JTS600000000000000HIR      2.6      2.5      2.6      2.7      2.8   \n",
      "42  JTS600000000000000JOR      2.9      3.2      3.3      3.3      3.2   \n",
      "43  JTS600000000000000LDR      0.7      0.9      0.7      0.8      0.9   \n",
      "44  JTS600000000000000QUR      1.5      1.4      1.4      1.4      1.4   \n",
      "45  JTS600000000000000TSR      2.5      2.5      2.3      2.5      2.7   \n",
      "46  JTS900000000000000HIR      1.3      1.4      1.2      1.3      1.3   \n",
      "47  JTS900000000000000JOR      2.0      1.9      1.8      1.9      1.8   \n",
      "48  JTS900000000000000LDR      0.4      0.4      0.6      0.4      0.5   \n",
      "49  JTS900000000000000QUR      0.6      0.6      0.6      0.7      0.6   \n",
      "50  JTS900000000000000TSR      1.4      1.3      1.4      1.4      1.4   \n",
      "\n",
      "   2013-M06 2013-M07 2013-M08 2013-M09  ... 2022-M06 2022-M07 2022-M08  \\\n",
      "0       3.3      3.3      3.5      3.5  ...      4.2      4.1      4.2   \n",
      "1       3.0      2.8      2.9      2.9  ...      6.7      6.9      6.2   \n",
      "2       1.3      1.3      1.3      1.4  ...      1.0      1.0      1.1   \n",
      "3       1.6      1.7      1.7      1.7  ...      2.7      2.6      2.8   \n",
      "4       3.2      3.2      3.3      3.3  ...      3.9      3.8      4.1   \n",
      "5       2.8      2.9      2.8      2.7  ...      0.5      0.5      0.6   \n",
      "6       3.7      3.7      3.9      3.9  ...      4.6      4.5      4.6   \n",
      "7       3.2      3.0      3.1      3.1  ...      7.1      7.3      6.5   \n",
      "8       1.5      1.4      1.5      1.5  ...      1.1      1.1      1.2   \n",
      "9       1.8      1.9      1.9      1.9  ...      3.0      2.9      3.1   \n",
      "10      3.5      3.6      3.7      3.7  ...      4.3      4.2      4.5   \n",
      "11      5.8      5.2      5.1      5.4  ...      4.7      5.1      4.9   \n",
      "12      2.2      1.7      1.9      2.1  ...      4.7      4.3      4.2   \n",
      "13      3.8      3.3      2.9      3.0  ...      2.1      2.1      1.7   \n",
      "14      1.7      1.8      1.6      1.6  ...      2.1      2.5      2.9   \n",
      "15      5.6      5.2      4.7      4.9  ...      4.3      4.8      4.9   \n",
      "16      2.0      2.0      2.2      2.2  ...      3.7      3.4      3.7   \n",
      "17      1.8      1.8      2.3      2.2  ...      6.2      6.4      6.1   \n",
      "18      0.9      0.9      0.9      0.8  ...      0.7      0.8      0.9   \n",
      "19      0.9      1.0      0.9      1.0  ...      2.4      2.2      2.2   \n",
      "20      2.0      2.2      2.0      2.0  ...      3.4      3.2      3.4   \n",
      "21      3.4      3.5      3.8      3.8  ...      4.5      4.6      4.6   \n",
      "22      3.4      2.7      2.9      3.0  ...      5.3      5.8      5.2   \n",
      "23      1.1      1.3      1.2      1.2  ...      0.8      1.0      1.2   \n",
      "24      1.8      1.8      2.1      2.1  ...      3.1      3.0      3.1   \n",
      "25      3.2      3.4      3.6      3.5  ...      4.1      4.2      4.5   \n",
      "26      3.3      3.3      3.1      3.5  ...      3.9      3.3      3.6   \n",
      "27      3.7      3.7      2.6      3.6  ...      6.7      7.5      6.8   \n",
      "28      1.5      1.7      2.2      1.6  ...      1.0      1.2      1.9   \n",
      "29      1.5      1.3      2.0      1.2  ...      2.1      1.5      1.8   \n",
      "30      3.2      3.1      4.4      3.0  ...      3.2      3.1      3.8   \n",
      "31      2.4      2.8      2.6      2.8  ...      2.3      2.6      2.7   \n",
      "32      3.8      4.1      3.0      3.1  ...      6.6      6.6      5.4   \n",
      "33      0.7      0.9      0.8      1.1  ...      0.5      0.3      0.6   \n",
      "34      1.3      1.3      1.4      1.3  ...      1.5      1.8      1.6   \n",
      "35      2.3      2.6      2.5      2.7  ...      2.2      2.4      2.6   \n",
      "36      5.1      5.2      5.4      5.2  ...      5.6      5.5      5.4   \n",
      "37      3.9      3.6      4.2      3.9  ...      8.8      8.4      7.6   \n",
      "38      2.2      1.7      2.6      2.4  ...      1.7      1.5      1.8   \n",
      "39      2.5      2.8      2.5      2.3  ...      3.4      3.6      3.2   \n",
      "40      5.0      4.8      5.3      5.0  ...      5.4      5.4      5.2   \n",
      "41      2.3      2.6      2.8      2.6  ...      3.6      3.5      3.5   \n",
      "42      3.1      3.0      3.4      3.1  ...      8.1      8.4      7.9   \n",
      "43      0.7      0.8      0.9      0.8  ...      0.6      0.7      0.5   \n",
      "44      1.4      1.5      1.4      1.5  ...      2.4      2.2      2.4   \n",
      "45      2.4      2.6      2.5      2.5  ...      3.2      3.0      3.1   \n",
      "46      1.1      1.2      1.4      1.3  ...      1.8      1.8      1.9   \n",
      "47      1.8      1.7      1.8      1.8  ...      4.2      4.8      4.4   \n",
      "48      0.4      0.4      0.4      0.5  ...      0.4      0.3      0.4   \n",
      "49      0.6      0.6      0.6      0.6  ...      1.1      0.9      1.0   \n",
      "50      1.3      1.3      1.3      1.3  ...      1.8      1.5      1.7   \n",
      "\n",
      "   2022-M09 2022-M10 2022-M11 2022-M12 2023-M01 2023-M02 2023-M03  \n",
      "0       4.1      4.0      4.1      4.0      4.1      4.0      4.0  \n",
      "1       6.6      6.4      6.5      6.8      6.4      6.0      5.8  \n",
      "2       0.9      1.0      1.0      1.0      1.1      1.0      1.2  \n",
      "3       2.6      2.6      2.7      2.6      2.5      2.6      2.5  \n",
      "4       3.8      3.8      3.9      3.8      3.8      3.8      3.8  \n",
      "5       0.5      0.6      0.6      0.5      0.5      0.6      0.6  \n",
      "6       4.4      4.4      4.4      4.4      4.5      4.3      4.3  \n",
      "7       6.9      6.7      6.8      7.1      6.7      6.3      6.0  \n",
      "8       1.0      1.1      1.1      1.0      1.2      1.1      1.3  \n",
      "9       2.9      2.9      3.0      2.9      2.8      2.8      2.7  \n",
      "10      4.1      4.2      4.2      4.2      4.2      4.1      4.2  \n",
      "11      4.7      4.5      4.3      4.8      4.9      4.7      5.1  \n",
      "12      5.6      4.8      4.3      5.8      3.5      4.9      4.1  \n",
      "13      2.5      2.1      1.9      2.1      2.0      2.3      3.7  \n",
      "14      1.9      2.0      1.7      2.0      2.3      1.9      1.9  \n",
      "15      4.6      4.2      3.8      4.3      4.5      4.5      5.8  \n",
      "16      3.1      3.4      3.1      3.1      3.2      3.2      3.0  \n",
      "17      5.9      5.4      6.0      5.8      5.3      5.2      5.1  \n",
      "18      0.7      0.8      0.8      0.8      0.9      0.9      0.9  \n",
      "19      1.9      2.1      2.1      2.0      2.1      2.1      2.1  \n",
      "20      2.9      3.1      3.0      3.0      3.1      3.1      3.2  \n",
      "21      4.5      4.3      4.4      4.5      4.6      4.4      4.2  \n",
      "22      5.3      5.2      5.1      5.8      6.0      5.5      4.8  \n",
      "23      1.0      1.0      0.9      1.1      1.1      1.1      1.0  \n",
      "24      3.2      3.1      3.5      3.2      3.2      3.1      3.0  \n",
      "25      4.4      4.2      4.5      4.4      4.5      4.4      4.2  \n",
      "26      3.2      3.2      3.6      3.1      2.7      3.1      3.4  \n",
      "27      6.6      6.9      6.4      3.3      4.3      5.2      5.6  \n",
      "28      1.0      1.5      1.5      1.5      1.5      1.6      1.2  \n",
      "29      2.0      1.0      1.3      1.5      1.3      1.4      1.5  \n",
      "30      3.2      3.0      3.1      3.2      3.4      3.2      2.8  \n",
      "31      2.6      2.4      2.7      2.3      2.3      2.3      2.1  \n",
      "32      5.1      6.2      6.0      6.3      4.7      4.8      5.1  \n",
      "33      0.6      0.7      1.3      0.4      0.6      0.4      0.6  \n",
      "34      1.5      1.6      1.4      1.5      1.6      1.2      1.4  \n",
      "35      2.4      2.4      3.0      2.2      2.3      2.1      2.0  \n",
      "36      5.2      5.1      5.1      5.1      5.1      4.9      5.2  \n",
      "37      8.7      7.7      8.5      8.4      8.4      7.5      7.0  \n",
      "38      1.4      1.6      1.6      1.5      2.3      1.7      1.9  \n",
      "39      3.3      3.1      3.2      3.1      2.4      2.8      2.9  \n",
      "40      4.9      4.9      5.1      4.9      4.9      4.6      5.0  \n",
      "41      3.3      3.3      3.5      3.6      3.6      3.4      3.5  \n",
      "42      8.3      8.0      7.7      7.7      7.5      7.0      6.8  \n",
      "43      0.6      0.6      0.5      0.6      0.5      0.6      0.7  \n",
      "44      2.2      2.4      2.5      2.5      2.4      2.5      2.4  \n",
      "45      2.9      3.0      3.1      3.3      3.1      3.2      3.3  \n",
      "46      1.8      1.7      1.9      2.0      1.8      1.8      1.8  \n",
      "47      4.6      4.1      4.6      4.7      4.4      4.3      4.4  \n",
      "48      0.4      0.3      0.3      0.4      0.4      0.4      0.3  \n",
      "49      1.0      1.0      1.0      1.0      0.9      0.9      0.9  \n",
      "50      1.7      1.6      1.6      1.8      1.5      1.5      1.5  \n",
      "\n",
      "[51 rows x 124 columns]\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/l6/k0bks1dx4wd409pkxgr263rm0000gn/T/ipykernel_55992/4085074310.py:52: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append(row_data, ignore_index=True)\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "\n",
    "# List of desired series from BLS JOLTS \n",
    "series_list = [\"JTS000000000000000HIR\", \"JTS000000000000000JOR\", \"JTS000000000000000LDR\", \"JTS000000000000000QUR\", \"JTS000000000000000TSR\", \"JTS000000000000000UOR\", \"JTS100000000000000HIR\", \"JTS100000000000000JOR\", \"JTS100000000000000LDR\", \"JTS100000000000000QUR\", \"JTS100000000000000TSR\", \"JTS230000000000000HIR\", \"JTS230000000000000JOR\", \"JTS230000000000000LDR\", \"JTS230000000000000QUR\", \"JTS230000000000000TSR\", \"JTS300000000000000HIR\", \"JTS300000000000000JOR\", \"JTS300000000000000LDR\", \"JTS300000000000000QUR\", \"JTS300000000000000TSR\", \"JTS400000000000000HIR\", \"JTS400000000000000JOR\", \"JTS400000000000000LDR\", \"JTS400000000000000QUR\", \"JTS400000000000000TSR\", \"JTS510000000000000HIR\", \"JTS510000000000000JOR\", \"JTS510000000000000LDR\", \"JTS510000000000000QUR\", \"JTS510000000000000TSR\", \"JTS510099000000000HIR\", \"JTS510099000000000JOR\", \"JTS510099000000000LDR\", \"JTS510099000000000QUR\", \"JTS510099000000000TSR\", \"JTS540099000000000HIR\", \"JTS540099000000000JOR\", \"JTS540099000000000LDR\", \"JTS540099000000000QUR\", \"JTS540099000000000TSR\", \"JTS600000000000000HIR\", \"JTS600000000000000JOR\", \"JTS600000000000000LDR\", \"JTS600000000000000QUR\", \"JTS600000000000000TSR\", \"JTS900000000000000HIR\", \"JTS900000000000000JOR\", \"JTS900000000000000LDR\", \"JTS900000000000000QUR\", \"JTS900000000000000TSR\"]\n",
    "\n",
    "# Create an empty DataFrame with columns for series IDs\n",
    "df = pd.DataFrame(columns=['SeriesID'])\n",
    "\n",
    "# Specify the start and end year for data retrieval (SPECIFY MONTH TOO?)\n",
    "start_year = 2013\n",
    "end_year = 2023\n",
    "\n",
    "# Iterate over each series ID\n",
    "for series in series_list:\n",
    "    # Make a POST request to the BLS API\n",
    "    data = {\n",
    "        'seriesid': [series],\n",
    "        'startyear': str(start_year),\n",
    "        'endyear': str(end_year),\n",
    "        'registrationkey': '2b4ca11bf83746deaa5718b92a582c25',\n",
    "    }\n",
    "    response = requests.post('https://api.bls.gov/publicAPI/v2/timeseries/data/', json=data)\n",
    "    \n",
    "    # Extract the data from the response\n",
    "    if response.status_code == 200:\n",
    "        result = response.json()\n",
    "        series_data = result['Results']['series'][0]\n",
    "        \n",
    "        # Extract the series title\n",
    "        series_title = series_data['seriesID']\n",
    "        \n",
    "        # Extract the months data\n",
    "        months_data = series_data['data']\n",
    "        \n",
    "        # Create a dictionary to store the row data\n",
    "        row_data = {'SeriesID': series_title}\n",
    "        \n",
    "        # Iterate over each month's data\n",
    "        for month in months_data:\n",
    "            year = month['year']\n",
    "            period = month['period']\n",
    "            value = month['value']\n",
    "            \n",
    "            # Create a column name based on year and period\n",
    "            column_name = f'{year}-{period}'\n",
    "            \n",
    "            # Add the value to the row data\n",
    "            row_data[column_name] = value\n",
    "        \n",
    "        # Add the row data to the DataFrame\n",
    "        df = df.append(row_data, ignore_index=True)\n",
    "\n",
    "# Print the DataFrame\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "10c0a196",
   "metadata": {},
   "source": [
    "## Step 2: Data Cleaning"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e168d631",
   "metadata": {},
   "source": [
    "### 1. Data Setup\n",
    "\n",
    "Observations: monthly updated series for specific industry/sector and variable (hires/openings/layoffs/separations)\n",
    "\n",
    "#### Variable Descriptions: https://www.bls.gov/help/one_screen/JT.htm#select-select-one-or-more-size-classes\n",
    "1. **Hires** (HIR): \"are all additions to the payroll during the month.\"\n",
    "2. **Job Openings** (JOR): \"are all positions that are open (not filled) on the last business day of the month. The positions can be full-time or part-time, and they can be permanent, short-term, or seasonal. A job is \"open\" only if it meets all three of the following conditions: 1) a specific position exists and there is work available for that position; 2) the job could start within 30 days, whether or not the establishment finds a suitable candidate during that time; and 3) there is active recruiting for workers from outside the establishment location that has the opening.\"\n",
    "3. **Layoffs (and Discharges)** (LDR): \"Involuntary separations initiated by the employer.\"\n",
    "4. **Quits** (QUR): \"Employees who left voluntarily. Exception: retirements or transfers to other locations are reported with Other Separations.\"\n",
    "5. **Total Separations** (TSR): \"are all employees separated from the payroll during the calendar month.\"\n",
    "    - Included in this total but not in the sample I chose is also **'other separations'** which is described as \"retirements; transfers to other locations; deaths; or separations due to employee disability.\"\n",
    "6. **Unemployed Persons per Job Opening Ratio** (UOR): only for 'total nonfarm' which is the aggregated dataset without subdivisions by industry\n",
    "\n",
    "This data *is* **seasonally adjusted** which is described as \"a statistical technique that attempts to measure and remove the influences of predictable seasonal patterns from time series data. Seasonally adjusted data contain this type of adjustment to enable comparisons of data across any point in time. Not seasonally adjusted data have no such adjustment.\"\n",
    "\n",
    "Units of Measurement: **Rate** - \"The job openings rate is computed by dividing the number of job openings by the sum of employment and job openings and multiplying that quotient by 100. All other data element rates (hires, total separations, quits, layoffs and discharges, and other separations) are computed by dividing the data element level by employment and multiplying that quotient by 100.\"\n",
    "\n",
    "#### Industry/Sector Descriptions: https://www.bls.gov/iag/home.htm\n",
    "\n",
    "1. Private sectors\n",
    "    1. Mining/Logging\n",
    "    2. Construction\n",
    "    3. Manufacturing\n",
    "        - (1) durable goods \n",
    "        - (2) nondurable goods subsector\n",
    "    4. Trade, transportation, and utilities\n",
    "        - (1) wholesale trade\n",
    "        - (2) retail trade\n",
    "        - (3) transportation, warehousing, and utilities\n",
    "    5. Information\n",
    "        - (1) pulblishing, motion pictures, recording\n",
    "        - (2) broadcasting, telecommunications\n",
    "        - (3) data processing\n",
    "            - programmers, support specialists, systems analysts developers\n",
    "        - (4) other info services\n",
    "            - editors, librarians, admin, internet publishing\n",
    "    6. Financial activties \n",
    "        - (1) finance and insurance\n",
    "        - (2) real estate, rental, and leasing\n",
    "    7. Professional and business services\n",
    "        - (1) professional, scientific, and technical services\n",
    "            * legal, accounting, architectural, design, advertising\n",
    "        - (2) management of companies and enterprises\n",
    "            * accounting, auditors, financial managers, supervisors, general managers\n",
    "        - (3) administrative and support and waste management and remediation services\n",
    "            * janitors, laborers, movers, landscaping, clerks guards\n",
    "    8. Education and Health Services\n",
    "        - (1) educational services\n",
    "        - (2) health care and social assistance\n",
    "    9. Leisure and hospitality\n",
    "        - (1) arts, entertainment, and recreation\n",
    "        - (2) accomodation and food services\n",
    "    10. Other services\n",
    "2. Public / Government\n",
    "    1. Federal\n",
    "    2. State and local\n",
    "        - (1) state and local government education\n",
    "        - (2) state and local government, excluding education"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "33ec372b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\tJTS000000000000000HIR\n",
      "\tJTS000000000000000JOR\n",
      "\tJTS000000000000000LDR\n",
      "\tJTS000000000000000QUR\n",
      "\tJTS000000000000000TSR\n",
      "\tJTS000000000000000UOR\n",
      "\tJTS100000000000000HIR\n",
      "\tJTS100000000000000JOR\n",
      "\tJTS100000000000000LDR\n",
      "\tJTS100000000000000QUR\n",
      "\tJTS100000000000000TSR\n",
      "\tJTS230000000000000HIR\n",
      "\tJTS230000000000000JOR\n",
      "\tJTS230000000000000LDR\n",
      "\tJTS230000000000000QUR\n",
      "\tJTS230000000000000TSR\n",
      "\tJTS300000000000000HIR\n",
      "\tJTS300000000000000JOR\n",
      "\tJTS300000000000000LDR\n",
      "\tJTS300000000000000QUR\n",
      "\tJTS300000000000000TSR\n",
      "\tJTS400000000000000HIR\n",
      "\tJTS400000000000000JOR\n",
      "\tJTS400000000000000LDR\n",
      "\tJTS400000000000000QUR\n",
      "\tJTS400000000000000TSR\n",
      "\tJTS510000000000000HIR\n",
      "\tJTS510000000000000JOR\n",
      "\tJTS510000000000000LDR\n",
      "\tJTS510000000000000QUR\n",
      "\tJTS510000000000000TSR\n",
      "\tJTS510099000000000HIR\n",
      "\tJTS510099000000000JOR\n",
      "\tJTS510099000000000LDR\n",
      "\tJTS510099000000000QUR\n",
      "\tJTS510099000000000TSR\n",
      "\tJTS540099000000000HIR\n",
      "\tJTS540099000000000JOR\n",
      "\tJTS540099000000000LDR\n",
      "\tJTS540099000000000QUR\n",
      "\tJTS540099000000000TSR\n",
      "\tJTS600000000000000HIR\n",
      "\tJTS600000000000000JOR\n",
      "\tJTS600000000000000LDR\n",
      "\tJTS600000000000000QUR\n",
      "\tJTS600000000000000TSR\n",
      "\tJTS900000000000000HIR\n",
      "\tJTS900000000000000JOR\n",
      "\tJTS900000000000000LDR\n",
      "\tJTS900000000000000QUR\n",
      "\tJTS900000000000000TSR\n"
     ]
    }
   ],
   "source": [
    "# transform list of seriesIDs into string of newline separated words\n",
    "    # for easy next step\n",
    "list2 = [\"JTS000000000000000HIR\", \"JTS000000000000000JOR\", \"JTS000000000000000LDR\", \"JTS000000000000000QUR\", \"JTS000000000000000TSR\", \"JTS000000000000000UOR\", \"JTS100000000000000HIR\", \"JTS100000000000000JOR\", \"JTS100000000000000LDR\", \"JTS100000000000000QUR\", \"JTS100000000000000TSR\", \"JTS230000000000000HIR\", \"JTS230000000000000JOR\", \"JTS230000000000000LDR\", \"JTS230000000000000QUR\", \"JTS230000000000000TSR\", \"JTS300000000000000HIR\", \"JTS300000000000000JOR\", \"JTS300000000000000LDR\", \"JTS300000000000000QUR\", \"JTS300000000000000TSR\", \"JTS400000000000000HIR\", \"JTS400000000000000JOR\", \"JTS400000000000000LDR\", \"JTS400000000000000QUR\", \"JTS400000000000000TSR\", \"JTS510000000000000HIR\", \"JTS510000000000000JOR\", \"JTS510000000000000LDR\", \"JTS510000000000000QUR\", \"JTS510000000000000TSR\", \"JTS510099000000000HIR\", \"JTS510099000000000JOR\", \"JTS510099000000000LDR\", \"JTS510099000000000QUR\", \"JTS510099000000000TSR\", \"JTS540099000000000HIR\", \"JTS540099000000000JOR\", \"JTS540099000000000LDR\", \"JTS540099000000000QUR\", \"JTS540099000000000TSR\", \"JTS600000000000000HIR\", \"JTS600000000000000JOR\", \"JTS600000000000000LDR\", \"JTS600000000000000QUR\", \"JTS600000000000000TSR\", \"JTS900000000000000HIR\", \"JTS900000000000000JOR\", \"JTS900000000000000LDR\", \"JTS900000000000000QUR\", \"JTS900000000000000TSR\"]\n",
    "list3 = '\\n\\t'.join(list2)\n",
    "print(f\"\\t{list3}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "a0204544",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>2013-M01</th>\n",
       "      <th>2013-M02</th>\n",
       "      <th>2013-M03</th>\n",
       "      <th>2013-M04</th>\n",
       "      <th>2013-M05</th>\n",
       "      <th>2013-M06</th>\n",
       "      <th>2013-M07</th>\n",
       "      <th>2013-M08</th>\n",
       "      <th>2013-M09</th>\n",
       "      <th>2013-M10</th>\n",
       "      <th>...</th>\n",
       "      <th>2022-M06</th>\n",
       "      <th>2022-M07</th>\n",
       "      <th>2022-M08</th>\n",
       "      <th>2022-M09</th>\n",
       "      <th>2022-M10</th>\n",
       "      <th>2022-M11</th>\n",
       "      <th>2022-M12</th>\n",
       "      <th>2023-M01</th>\n",
       "      <th>2023-M02</th>\n",
       "      <th>2023-M03</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SeriesID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>nonfarm_hires</th>\n",
       "      <td>3.3</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>...</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.8</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_layoffs</th>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_quits</th>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_separations</th>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.2</td>\n",
       "      <td>...</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_unemp_per_opening</th>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_hires</th>\n",
       "      <td>3.7</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.7</td>\n",
       "      <td>...</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_openings</th>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>...</td>\n",
       "      <td>7.1</td>\n",
       "      <td>7.3</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.8</td>\n",
       "      <td>7.1</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.3</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_layoffs</th>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_quits</th>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_separations</th>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.5</td>\n",
       "      <td>...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_hires</th>\n",
       "      <td>5.9</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.4</td>\n",
       "      <td>6.3</td>\n",
       "      <td>...</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_openings</th>\n",
       "      <td>2.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.2</td>\n",
       "      <td>5.6</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.3</td>\n",
       "      <td>5.8</td>\n",
       "      <td>3.5</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_layoffs</th>\n",
       "      <td>3.2</td>\n",
       "      <td>3.7</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.3</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_quits</th>\n",
       "      <td>2.3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_separations</th>\n",
       "      <td>5.7</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.6</td>\n",
       "      <td>5.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.7</td>\n",
       "      <td>...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.2</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_hires</th>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>...</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_openings</th>\n",
       "      <td>2.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.1</td>\n",
       "      <td>5.9</td>\n",
       "      <td>5.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_layoffs</th>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_quits</th>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>...</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_separations</th>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_hires</th>\n",
       "      <td>3.5</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>...</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.8</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_layoffs</th>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_quits</th>\n",
       "      <td>2.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_separations</th>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>...</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_hires</th>\n",
       "      <td>2.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>...</td>\n",
       "      <td>6.7</td>\n",
       "      <td>7.5</td>\n",
       "      <td>6.8</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.4</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4.3</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_layoffs</th>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_quits</th>\n",
       "      <td>1.5</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_separations</th>\n",
       "      <td>2.6</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_hires</th>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>...</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.6</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.1</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.3</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "      <td>5.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_layoffs</th>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_quits</th>\n",
       "      <td>1.2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_separations</th>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_hires</th>\n",
       "      <td>4.8</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.2</td>\n",
       "      <td>4.6</td>\n",
       "      <td>...</td>\n",
       "      <td>5.6</td>\n",
       "      <td>5.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_openings</th>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.6</td>\n",
       "      <td>4.2</td>\n",
       "      <td>3.9</td>\n",
       "      <td>4.2</td>\n",
       "      <td>...</td>\n",
       "      <td>8.8</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.6</td>\n",
       "      <td>8.7</td>\n",
       "      <td>7.7</td>\n",
       "      <td>8.5</td>\n",
       "      <td>8.4</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.5</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_layoffs</th>\n",
       "      <td>2.3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_quits</th>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_separations</th>\n",
       "      <td>4.5</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>...</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.2</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_hires</th>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_openings</th>\n",
       "      <td>2.9</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>...</td>\n",
       "      <td>8.1</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.9</td>\n",
       "      <td>8.3</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.7</td>\n",
       "      <td>7.7</td>\n",
       "      <td>7.5</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_layoffs</th>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_quits</th>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_separations</th>\n",
       "      <td>2.5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_hires</th>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_openings</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>...</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_layoffs</th>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_quits</th>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_separations</th>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51 rows × 123 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          2013-M01 2013-M02 2013-M03 2013-M04 2013-M05  \\\n",
       "SeriesID                                                                 \n",
       "nonfarm_hires                  3.3      3.4      3.2      3.4      3.4   \n",
       "nonfarm_openings               2.8      2.9      2.9      2.9      3.0   \n",
       "nonfarm_layoffs                1.2      1.2      1.3      1.3      1.3   \n",
       "nonfarm_quits                  1.7      1.7      1.6      1.7      1.6   \n",
       "nonfarm_separations            3.2      3.2      3.1      3.3      3.3   \n",
       "nonfarm_unemp_per_opening      3.2      3.0      2.9      2.9      2.8   \n",
       "private_hires                  3.7      3.8      3.6      3.8      3.8   \n",
       "private_openings               3.0      3.1      3.1      3.0      3.2   \n",
       "private_layoffs                1.4      1.4      1.5      1.5      1.5   \n",
       "private_quits                  1.9      1.9      1.8      1.9      1.8   \n",
       "private_separations            3.6      3.5      3.5      3.6      3.6   \n",
       "construction_hires             5.9      6.5      6.1      5.1      5.8   \n",
       "construction_openings          2.1      2.3      2.0      1.9      2.0   \n",
       "construction_layoffs           3.2      3.7      4.1      3.5      3.3   \n",
       "construction_quits             2.3      1.8      1.6      1.6      1.6   \n",
       "construction_separations       5.7      5.8      5.8      5.2      5.1   \n",
       "manufacturing_hires            2.1      2.0      1.8      2.0      2.3   \n",
       "manufacturing_openings         2.1      2.3      2.1      2.0      2.0   \n",
       "manufacturing_layoffs          0.9      0.9      0.9      0.9      1.0   \n",
       "manufacturing_quits            0.8      0.9      0.8      1.0      1.0   \n",
       "manufacturing_separations      1.9      2.0      1.8      2.1      2.2   \n",
       "trade_hires                    3.5      3.7      3.2      3.5      3.6   \n",
       "trade_openings                 2.8      2.5      2.8      3.0      3.1   \n",
       "trade_layoffs                  1.1      1.2      1.2      1.2      1.4   \n",
       "trade_quits                    2.1      1.9      1.8      1.9      1.8   \n",
       "trade_separations              3.6      3.5      3.3      3.4      3.4   \n",
       "info_hires                     2.3      3.1      1.9      2.6      3.0   \n",
       "info_openings                  2.8      3.8      3.5      2.4      3.6   \n",
       "info_layoffs                   0.8      0.9      0.4      0.9      1.1   \n",
       "info_quits                     1.5      1.2      1.1      1.6      1.3   \n",
       "info_separations               2.6      2.2      1.9      2.7      2.6   \n",
       "finance_hires                  2.8      2.6      2.3      2.4      2.8   \n",
       "finance_openings               2.8      3.7      3.9      3.1      3.8   \n",
       "finance_layoffs                0.9      0.7      0.6      0.6      0.8   \n",
       "finance_quits                  1.2      1.5      1.2      1.2      1.4   \n",
       "finance_separations            2.6      2.7      2.2      2.2      2.7   \n",
       "professional_hires             4.8      4.7      4.7      5.0      4.9   \n",
       "professional_openings          4.1      4.0      3.9      4.0      4.1   \n",
       "professional_layoffs           2.3      1.9      2.1      2.1      2.1   \n",
       "professional_quits             1.9      2.1      2.1      2.4      2.4   \n",
       "professional_separations       4.5      4.2      4.4      4.8      4.7   \n",
       "edu_health_hires               2.6      2.5      2.6      2.7      2.8   \n",
       "edu_health_openings            2.9      3.2      3.3      3.3      3.2   \n",
       "edu_health_layoffs             0.7      0.9      0.7      0.8      0.9   \n",
       "edu_health_quits               1.5      1.4      1.4      1.4      1.4   \n",
       "edu_health_separations         2.5      2.5      2.3      2.5      2.7   \n",
       "gov_hires                      1.3      1.4      1.2      1.3      1.3   \n",
       "gov_openings                   2.0      1.9      1.8      1.9      1.8   \n",
       "gov_layoffs                    0.4      0.4      0.6      0.4      0.5   \n",
       "gov_quits                      0.6      0.6      0.6      0.7      0.6   \n",
       "gov_separations                1.4      1.3      1.4      1.4      1.4   \n",
       "\n",
       "                          2013-M06 2013-M07 2013-M08 2013-M09 2013-M10  ...  \\\n",
       "SeriesID                                                                ...   \n",
       "nonfarm_hires                  3.3      3.3      3.5      3.5      3.3  ...   \n",
       "nonfarm_openings               3.0      2.8      2.9      2.9      3.0  ...   \n",
       "nonfarm_layoffs                1.3      1.3      1.3      1.4      1.2  ...   \n",
       "nonfarm_quits                  1.6      1.7      1.7      1.7      1.7  ...   \n",
       "nonfarm_separations            3.2      3.2      3.3      3.3      3.2  ...   \n",
       "nonfarm_unemp_per_opening      2.8      2.9      2.8      2.7      2.6  ...   \n",
       "private_hires                  3.7      3.7      3.9      3.9      3.7  ...   \n",
       "private_openings               3.2      3.0      3.1      3.1      3.2  ...   \n",
       "private_layoffs                1.5      1.4      1.5      1.5      1.4  ...   \n",
       "private_quits                  1.8      1.9      1.9      1.9      1.9  ...   \n",
       "private_separations            3.5      3.6      3.7      3.7      3.5  ...   \n",
       "construction_hires             5.8      5.2      5.1      5.4      6.3  ...   \n",
       "construction_openings          2.2      1.7      1.9      2.1      2.3  ...   \n",
       "construction_layoffs           3.8      3.3      2.9      3.0      4.1  ...   \n",
       "construction_quits             1.7      1.8      1.6      1.6      1.6  ...   \n",
       "construction_separations       5.6      5.2      4.7      4.9      5.7  ...   \n",
       "manufacturing_hires            2.0      2.0      2.2      2.2      1.9  ...   \n",
       "manufacturing_openings         1.8      1.8      2.3      2.2      2.4  ...   \n",
       "manufacturing_layoffs          0.9      0.9      0.9      0.8      0.7  ...   \n",
       "manufacturing_quits            0.9      1.0      0.9      1.0      0.9  ...   \n",
       "manufacturing_separations      2.0      2.2      2.0      2.0      1.7  ...   \n",
       "trade_hires                    3.4      3.5      3.8      3.8      3.7  ...   \n",
       "trade_openings                 3.4      2.7      2.9      3.0      2.9  ...   \n",
       "trade_layoffs                  1.1      1.3      1.2      1.2      1.3  ...   \n",
       "trade_quits                    1.8      1.8      2.1      2.1      2.0  ...   \n",
       "trade_separations              3.2      3.4      3.6      3.5      3.6  ...   \n",
       "info_hires                     3.3      3.3      3.1      3.5      3.0  ...   \n",
       "info_openings                  3.7      3.7      2.6      3.6      4.4  ...   \n",
       "info_layoffs                   1.5      1.7      2.2      1.6      1.6  ...   \n",
       "info_quits                     1.5      1.3      2.0      1.2      0.7  ...   \n",
       "info_separations               3.2      3.1      4.4      3.0      2.5  ...   \n",
       "finance_hires                  2.4      2.8      2.6      2.8      2.4  ...   \n",
       "finance_openings               3.8      4.1      3.0      3.1      3.2  ...   \n",
       "finance_layoffs                0.7      0.9      0.8      1.1      0.8  ...   \n",
       "finance_quits                  1.3      1.3      1.4      1.3      1.1  ...   \n",
       "finance_separations            2.3      2.6      2.5      2.7      2.3  ...   \n",
       "professional_hires             5.1      5.2      5.4      5.2      4.6  ...   \n",
       "professional_openings          3.9      3.6      4.2      3.9      4.2  ...   \n",
       "professional_layoffs           2.2      1.7      2.6      2.4      1.9  ...   \n",
       "professional_quits             2.5      2.8      2.5      2.3      2.4  ...   \n",
       "professional_separations       5.0      4.8      5.3      5.0      4.5  ...   \n",
       "edu_health_hires               2.3      2.6      2.8      2.6      2.4  ...   \n",
       "edu_health_openings            3.1      3.0      3.4      3.1      3.1  ...   \n",
       "edu_health_layoffs             0.7      0.8      0.9      0.8      0.7  ...   \n",
       "edu_health_quits               1.4      1.5      1.4      1.5      1.5  ...   \n",
       "edu_health_separations         2.4      2.6      2.5      2.5      2.4  ...   \n",
       "gov_hires                      1.1      1.2      1.4      1.3      1.3  ...   \n",
       "gov_openings                   1.8      1.7      1.8      1.8      1.8  ...   \n",
       "gov_layoffs                    0.4      0.4      0.4      0.5      0.5  ...   \n",
       "gov_quits                      0.6      0.6      0.6      0.6      0.6  ...   \n",
       "gov_separations                1.3      1.3      1.3      1.3      1.3  ...   \n",
       "\n",
       "                          2022-M06 2022-M07 2022-M08 2022-M09 2022-M10  \\\n",
       "SeriesID                                                                 \n",
       "nonfarm_hires                  4.2      4.1      4.2      4.1      4.0   \n",
       "nonfarm_openings               6.7      6.9      6.2      6.6      6.4   \n",
       "nonfarm_layoffs                1.0      1.0      1.1      0.9      1.0   \n",
       "nonfarm_quits                  2.7      2.6      2.8      2.6      2.6   \n",
       "nonfarm_separations            3.9      3.8      4.1      3.8      3.8   \n",
       "nonfarm_unemp_per_opening      0.5      0.5      0.6      0.5      0.6   \n",
       "private_hires                  4.6      4.5      4.6      4.4      4.4   \n",
       "private_openings               7.1      7.3      6.5      6.9      6.7   \n",
       "private_layoffs                1.1      1.1      1.2      1.0      1.1   \n",
       "private_quits                  3.0      2.9      3.1      2.9      2.9   \n",
       "private_separations            4.3      4.2      4.5      4.1      4.2   \n",
       "construction_hires             4.7      5.1      4.9      4.7      4.5   \n",
       "construction_openings          4.7      4.3      4.2      5.6      4.8   \n",
       "construction_layoffs           2.1      2.1      1.7      2.5      2.1   \n",
       "construction_quits             2.1      2.5      2.9      1.9      2.0   \n",
       "construction_separations       4.3      4.8      4.9      4.6      4.2   \n",
       "manufacturing_hires            3.7      3.4      3.7      3.1      3.4   \n",
       "manufacturing_openings         6.2      6.4      6.1      5.9      5.4   \n",
       "manufacturing_layoffs          0.7      0.8      0.9      0.7      0.8   \n",
       "manufacturing_quits            2.4      2.2      2.2      1.9      2.1   \n",
       "manufacturing_separations      3.4      3.2      3.4      2.9      3.1   \n",
       "trade_hires                    4.5      4.6      4.6      4.5      4.3   \n",
       "trade_openings                 5.3      5.8      5.2      5.3      5.2   \n",
       "trade_layoffs                  0.8      1.0      1.2      1.0      1.0   \n",
       "trade_quits                    3.1      3.0      3.1      3.2      3.1   \n",
       "trade_separations              4.1      4.2      4.5      4.4      4.2   \n",
       "info_hires                     3.9      3.3      3.6      3.2      3.2   \n",
       "info_openings                  6.7      7.5      6.8      6.6      6.9   \n",
       "info_layoffs                   1.0      1.2      1.9      1.0      1.5   \n",
       "info_quits                     2.1      1.5      1.8      2.0      1.0   \n",
       "info_separations               3.2      3.1      3.8      3.2      3.0   \n",
       "finance_hires                  2.3      2.6      2.7      2.6      2.4   \n",
       "finance_openings               6.6      6.6      5.4      5.1      6.2   \n",
       "finance_layoffs                0.5      0.3      0.6      0.6      0.7   \n",
       "finance_quits                  1.5      1.8      1.6      1.5      1.6   \n",
       "finance_separations            2.2      2.4      2.6      2.4      2.4   \n",
       "professional_hires             5.6      5.5      5.4      5.2      5.1   \n",
       "professional_openings          8.8      8.4      7.6      8.7      7.7   \n",
       "professional_layoffs           1.7      1.5      1.8      1.4      1.6   \n",
       "professional_quits             3.4      3.6      3.2      3.3      3.1   \n",
       "professional_separations       5.4      5.4      5.2      4.9      4.9   \n",
       "edu_health_hires               3.6      3.5      3.5      3.3      3.3   \n",
       "edu_health_openings            8.1      8.4      7.9      8.3      8.0   \n",
       "edu_health_layoffs             0.6      0.7      0.5      0.6      0.6   \n",
       "edu_health_quits               2.4      2.2      2.4      2.2      2.4   \n",
       "edu_health_separations         3.2      3.0      3.1      2.9      3.0   \n",
       "gov_hires                      1.8      1.8      1.9      1.8      1.7   \n",
       "gov_openings                   4.2      4.8      4.4      4.6      4.1   \n",
       "gov_layoffs                    0.4      0.3      0.4      0.4      0.3   \n",
       "gov_quits                      1.1      0.9      1.0      1.0      1.0   \n",
       "gov_separations                1.8      1.5      1.7      1.7      1.6   \n",
       "\n",
       "                          2022-M11 2022-M12 2023-M01 2023-M02 2023-M03  \n",
       "SeriesID                                                                \n",
       "nonfarm_hires                  4.1      4.0      4.1      4.0      4.0  \n",
       "nonfarm_openings               6.5      6.8      6.4      6.0      5.8  \n",
       "nonfarm_layoffs                1.0      1.0      1.1      1.0      1.2  \n",
       "nonfarm_quits                  2.7      2.6      2.5      2.6      2.5  \n",
       "nonfarm_separations            3.9      3.8      3.8      3.8      3.8  \n",
       "nonfarm_unemp_per_opening      0.6      0.5      0.5      0.6      0.6  \n",
       "private_hires                  4.4      4.4      4.5      4.3      4.3  \n",
       "private_openings               6.8      7.1      6.7      6.3      6.0  \n",
       "private_layoffs                1.1      1.0      1.2      1.1      1.3  \n",
       "private_quits                  3.0      2.9      2.8      2.8      2.7  \n",
       "private_separations            4.2      4.2      4.2      4.1      4.2  \n",
       "construction_hires             4.3      4.8      4.9      4.7      5.1  \n",
       "construction_openings          4.3      5.8      3.5      4.9      4.1  \n",
       "construction_layoffs           1.9      2.1      2.0      2.3      3.7  \n",
       "construction_quits             1.7      2.0      2.3      1.9      1.9  \n",
       "construction_separations       3.8      4.3      4.5      4.5      5.8  \n",
       "manufacturing_hires            3.1      3.1      3.2      3.2      3.0  \n",
       "manufacturing_openings         6.0      5.8      5.3      5.2      5.1  \n",
       "manufacturing_layoffs          0.8      0.8      0.9      0.9      0.9  \n",
       "manufacturing_quits            2.1      2.0      2.1      2.1      2.1  \n",
       "manufacturing_separations      3.0      3.0      3.1      3.1      3.2  \n",
       "trade_hires                    4.4      4.5      4.6      4.4      4.2  \n",
       "trade_openings                 5.1      5.8      6.0      5.5      4.8  \n",
       "trade_layoffs                  0.9      1.1      1.1      1.1      1.0  \n",
       "trade_quits                    3.5      3.2      3.2      3.1      3.0  \n",
       "trade_separations              4.5      4.4      4.5      4.4      4.2  \n",
       "info_hires                     3.6      3.1      2.7      3.1      3.4  \n",
       "info_openings                  6.4      3.3      4.3      5.2      5.6  \n",
       "info_layoffs                   1.5      1.5      1.5      1.6      1.2  \n",
       "info_quits                     1.3      1.5      1.3      1.4      1.5  \n",
       "info_separations               3.1      3.2      3.4      3.2      2.8  \n",
       "finance_hires                  2.7      2.3      2.3      2.3      2.1  \n",
       "finance_openings               6.0      6.3      4.7      4.8      5.1  \n",
       "finance_layoffs                1.3      0.4      0.6      0.4      0.6  \n",
       "finance_quits                  1.4      1.5      1.6      1.2      1.4  \n",
       "finance_separations            3.0      2.2      2.3      2.1      2.0  \n",
       "professional_hires             5.1      5.1      5.1      4.9      5.2  \n",
       "professional_openings          8.5      8.4      8.4      7.5      7.0  \n",
       "professional_layoffs           1.6      1.5      2.3      1.7      1.9  \n",
       "professional_quits             3.2      3.1      2.4      2.8      2.9  \n",
       "professional_separations       5.1      4.9      4.9      4.6      5.0  \n",
       "edu_health_hires               3.5      3.6      3.6      3.4      3.5  \n",
       "edu_health_openings            7.7      7.7      7.5      7.0      6.8  \n",
       "edu_health_layoffs             0.5      0.6      0.5      0.6      0.7  \n",
       "edu_health_quits               2.5      2.5      2.4      2.5      2.4  \n",
       "edu_health_separations         3.1      3.3      3.1      3.2      3.3  \n",
       "gov_hires                      1.9      2.0      1.8      1.8      1.8  \n",
       "gov_openings                   4.6      4.7      4.4      4.3      4.4  \n",
       "gov_layoffs                    0.3      0.4      0.4      0.4      0.3  \n",
       "gov_quits                      1.0      1.0      0.9      0.9      0.9  \n",
       "gov_separations                1.6      1.8      1.5      1.5      1.5  \n",
       "\n",
       "[51 rows x 123 columns]"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# replace numerical index column with SeriesID\n",
    "df = df.set_index(['SeriesID'])\n",
    "\n",
    "# rename seriesIDs with descriptive headers\n",
    "row_labels={\n",
    "    # total nonfarm\n",
    "    \"JTS000000000000000HIR\": \"nonfarm_hires\",\n",
    "    \"JTS000000000000000JOR\": \"nonfarm_openings\",\n",
    "    \"JTS000000000000000LDR\": \"nonfarm_layoffs\",\n",
    "    \"JTS000000000000000QUR\": \"nonfarm_quits\",\n",
    "    \"JTS000000000000000TSR\": \"nonfarm_separations\",\n",
    "    \"JTS000000000000000UOR\": \"nonfarm_unemp_per_opening\",\n",
    "    # nonfarm :: total private\n",
    "    \"JTS100000000000000HIR\": \"private_hires\",\n",
    "    \"JTS100000000000000JOR\": \"private_openings\",\n",
    "    \"JTS100000000000000LDR\": \"private_layoffs\",\n",
    "    \"JTS100000000000000QUR\": \"private_quits\",\n",
    "    \"JTS100000000000000TSR\": \"private_separations\",\n",
    "    # nonfarm :: private :: construction\n",
    "    \"JTS230000000000000HIR\": \"construction_hires\",\n",
    "    \"JTS230000000000000JOR\": \"construction_openings\",\n",
    "    \"JTS230000000000000LDR\": \"construction_layoffs\",\n",
    "    \"JTS230000000000000QUR\": \"construction_quits\",\n",
    "    \"JTS230000000000000TSR\": \"construction_separations\",\n",
    "    # nonfarm :: private :: manufacturing\n",
    "    \"JTS300000000000000HIR\": \"manufacturing_hires\",\n",
    "    \"JTS300000000000000JOR\": \"manufacturing_openings\",\n",
    "    \"JTS300000000000000LDR\": \"manufacturing_layoffs\",\n",
    "    \"JTS300000000000000QUR\": \"manufacturing_quits\",\n",
    "    \"JTS300000000000000TSR\": \"manufacturing_separations\",\n",
    "    # nonfarm :: private :: trade, transportation, utilities\n",
    "    \"JTS400000000000000HIR\": \"trade_hires\",\n",
    "    \"JTS400000000000000JOR\": \"trade_openings\",\n",
    "    \"JTS400000000000000LDR\": \"trade_layoffs\",\n",
    "    \"JTS400000000000000QUR\": \"trade_quits\",\n",
    "    \"JTS400000000000000TSR\": \"trade_separations\",\n",
    "    # nonfarm :: private :: information\n",
    "    \"JTS510000000000000HIR\": \"info_hires\", \n",
    "    \"JTS510000000000000JOR\": \"info_openings\", \n",
    "    \"JTS510000000000000LDR\": \"info_layoffs\",\n",
    "    \"JTS510000000000000QUR\": \"info_quits\",\n",
    "    \"JTS510000000000000TSR\": \"info_separations\",\n",
    "    # nonfarm :: private :: financial activities\n",
    "    \"JTS510099000000000HIR\": \"finance_hires\",\n",
    "    \"JTS510099000000000JOR\": \"finance_openings\",\n",
    "    \"JTS510099000000000LDR\": \"finance_layoffs\",\n",
    "    \"JTS510099000000000QUR\": \"finance_quits\",\n",
    "    \"JTS510099000000000TSR\": \"finance_separations\",\n",
    "    # nonfarm :: private :: professional and business services\n",
    "    \"JTS540099000000000HIR\": \"professional_hires\",\n",
    "    \"JTS540099000000000JOR\": \"professional_openings\",\n",
    "    \"JTS540099000000000LDR\": \"professional_layoffs\",\n",
    "    \"JTS540099000000000QUR\": \"professional_quits\",\n",
    "    \"JTS540099000000000TSR\": \"professional_separations\",\n",
    "    # nonfarm :: private :: education and health\n",
    "    \"JTS600000000000000HIR\": \"edu_health_hires\",\n",
    "    \"JTS600000000000000JOR\": \"edu_health_openings\",\n",
    "    \"JTS600000000000000LDR\": \"edu_health_layoffs\",\n",
    "    \"JTS600000000000000QUR\": \"edu_health_quits\",\n",
    "    \"JTS600000000000000TSR\": \"edu_health_separations\",\n",
    "    # nonfarm :: total government\n",
    "    \"JTS900000000000000HIR\": \"gov_hires\",\n",
    "    \"JTS900000000000000JOR\": \"gov_openings\",\n",
    "    \"JTS900000000000000LDR\": \"gov_layoffs\",\n",
    "    \"JTS900000000000000QUR\": \"gov_quits\",\n",
    "    \"JTS900000000000000TSR\": \"gov_separations\",\n",
    "}\n",
    "\n",
    "df.rename(index=row_labels, inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "id": "cae408ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "# convert dataframe to csv for Tableau / R analyis\n",
    "df.to_csv('../files/jolts.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "55dd95d5",
   "metadata": {},
   "source": [
    "### Notes for Tableau:\n",
    "- turned time series columns into date variable by pivoting only the month columns\n",
    "- Series ID | Date | Value\n",
    "- then can graph different series by graphic series Id vs. Date vs. Value and filtering by series ID\n",
    "- Problem 1: YYYY-'M'MM is a difficult string format to parse into a date in Tableau, so I have to remove the 'M' from every date column -> regex substitution\n",
    "- Problem 2: Even after transforming column names in the csv to YYYY-MM, Tableau returned to the previous format YYYY-'M'MM -> split into month and year fields in Tableau, then joined with DATE(Left(Year) +'-'+ Right(Month) + '-1') to set the day for each date value to the 1st; it was getting confused by not having a day to parse "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "id": "c8e35e76",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>2013-01</th>\n",
       "      <th>2013-02</th>\n",
       "      <th>2013-03</th>\n",
       "      <th>2013-04</th>\n",
       "      <th>2013-05</th>\n",
       "      <th>2013-06</th>\n",
       "      <th>2013-07</th>\n",
       "      <th>2013-08</th>\n",
       "      <th>2013-09</th>\n",
       "      <th>2013-10</th>\n",
       "      <th>...</th>\n",
       "      <th>2022-06</th>\n",
       "      <th>2022-07</th>\n",
       "      <th>2022-08</th>\n",
       "      <th>2022-09</th>\n",
       "      <th>2022-10</th>\n",
       "      <th>2022-11</th>\n",
       "      <th>2022-12</th>\n",
       "      <th>2023-01</th>\n",
       "      <th>2023-02</th>\n",
       "      <th>2023-03</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SeriesID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>nonfarm_hires</th>\n",
       "      <td>3.3</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>...</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.8</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_layoffs</th>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_quits</th>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_separations</th>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.2</td>\n",
       "      <td>...</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nonfarm_unemp_per_opening</th>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_hires</th>\n",
       "      <td>3.7</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.7</td>\n",
       "      <td>...</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_openings</th>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>...</td>\n",
       "      <td>7.1</td>\n",
       "      <td>7.3</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.8</td>\n",
       "      <td>7.1</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.3</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_layoffs</th>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_quits</th>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>private_separations</th>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.5</td>\n",
       "      <td>...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_hires</th>\n",
       "      <td>5.9</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.4</td>\n",
       "      <td>6.3</td>\n",
       "      <td>...</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_openings</th>\n",
       "      <td>2.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.2</td>\n",
       "      <td>5.6</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.3</td>\n",
       "      <td>5.8</td>\n",
       "      <td>3.5</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_layoffs</th>\n",
       "      <td>3.2</td>\n",
       "      <td>3.7</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.3</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_quits</th>\n",
       "      <td>2.3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>construction_separations</th>\n",
       "      <td>5.7</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.6</td>\n",
       "      <td>5.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.7</td>\n",
       "      <td>...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.2</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_hires</th>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>...</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_openings</th>\n",
       "      <td>2.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.1</td>\n",
       "      <td>5.9</td>\n",
       "      <td>5.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_layoffs</th>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_quits</th>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>...</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>manufacturing_separations</th>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_hires</th>\n",
       "      <td>3.5</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>...</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.8</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_layoffs</th>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_quits</th>\n",
       "      <td>2.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trade_separations</th>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>...</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_hires</th>\n",
       "      <td>2.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>...</td>\n",
       "      <td>6.7</td>\n",
       "      <td>7.5</td>\n",
       "      <td>6.8</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.4</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4.3</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_layoffs</th>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_quits</th>\n",
       "      <td>1.5</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info_separations</th>\n",
       "      <td>2.6</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_hires</th>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_openings</th>\n",
       "      <td>2.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>...</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.6</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.1</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.3</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "      <td>5.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_layoffs</th>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_quits</th>\n",
       "      <td>1.2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>finance_separations</th>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_hires</th>\n",
       "      <td>4.8</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.2</td>\n",
       "      <td>4.6</td>\n",
       "      <td>...</td>\n",
       "      <td>5.6</td>\n",
       "      <td>5.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_openings</th>\n",
       "      <td>4.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.6</td>\n",
       "      <td>4.2</td>\n",
       "      <td>3.9</td>\n",
       "      <td>4.2</td>\n",
       "      <td>...</td>\n",
       "      <td>8.8</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.6</td>\n",
       "      <td>8.7</td>\n",
       "      <td>7.7</td>\n",
       "      <td>8.5</td>\n",
       "      <td>8.4</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.5</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_layoffs</th>\n",
       "      <td>2.3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_quits</th>\n",
       "      <td>1.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>professional_separations</th>\n",
       "      <td>4.5</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>5.3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>...</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.4</td>\n",
       "      <td>5.2</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_hires</th>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_openings</th>\n",
       "      <td>2.9</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.1</td>\n",
       "      <td>...</td>\n",
       "      <td>8.1</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.9</td>\n",
       "      <td>8.3</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.7</td>\n",
       "      <td>7.7</td>\n",
       "      <td>7.5</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_layoffs</th>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_quits</th>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>edu_health_separations</th>\n",
       "      <td>2.5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_hires</th>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_openings</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>...</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_layoffs</th>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_quits</th>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gov_separations</th>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51 rows × 123 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          2013-01 2013-02 2013-03 2013-04 2013-05 2013-06  \\\n",
       "SeriesID                                                                    \n",
       "nonfarm_hires                 3.3     3.4     3.2     3.4     3.4     3.3   \n",
       "nonfarm_openings              2.8     2.9     2.9     2.9     3.0     3.0   \n",
       "nonfarm_layoffs               1.2     1.2     1.3     1.3     1.3     1.3   \n",
       "nonfarm_quits                 1.7     1.7     1.6     1.7     1.6     1.6   \n",
       "nonfarm_separations           3.2     3.2     3.1     3.3     3.3     3.2   \n",
       "nonfarm_unemp_per_opening     3.2     3.0     2.9     2.9     2.8     2.8   \n",
       "private_hires                 3.7     3.8     3.6     3.8     3.8     3.7   \n",
       "private_openings              3.0     3.1     3.1     3.0     3.2     3.2   \n",
       "private_layoffs               1.4     1.4     1.5     1.5     1.5     1.5   \n",
       "private_quits                 1.9     1.9     1.8     1.9     1.8     1.8   \n",
       "private_separations           3.6     3.5     3.5     3.6     3.6     3.5   \n",
       "construction_hires            5.9     6.5     6.1     5.1     5.8     5.8   \n",
       "construction_openings         2.1     2.3     2.0     1.9     2.0     2.2   \n",
       "construction_layoffs          3.2     3.7     4.1     3.5     3.3     3.8   \n",
       "construction_quits            2.3     1.8     1.6     1.6     1.6     1.7   \n",
       "construction_separations      5.7     5.8     5.8     5.2     5.1     5.6   \n",
       "manufacturing_hires           2.1     2.0     1.8     2.0     2.3     2.0   \n",
       "manufacturing_openings        2.1     2.3     2.1     2.0     2.0     1.8   \n",
       "manufacturing_layoffs         0.9     0.9     0.9     0.9     1.0     0.9   \n",
       "manufacturing_quits           0.8     0.9     0.8     1.0     1.0     0.9   \n",
       "manufacturing_separations     1.9     2.0     1.8     2.1     2.2     2.0   \n",
       "trade_hires                   3.5     3.7     3.2     3.5     3.6     3.4   \n",
       "trade_openings                2.8     2.5     2.8     3.0     3.1     3.4   \n",
       "trade_layoffs                 1.1     1.2     1.2     1.2     1.4     1.1   \n",
       "trade_quits                   2.1     1.9     1.8     1.9     1.8     1.8   \n",
       "trade_separations             3.6     3.5     3.3     3.4     3.4     3.2   \n",
       "info_hires                    2.3     3.1     1.9     2.6     3.0     3.3   \n",
       "info_openings                 2.8     3.8     3.5     2.4     3.6     3.7   \n",
       "info_layoffs                  0.8     0.9     0.4     0.9     1.1     1.5   \n",
       "info_quits                    1.5     1.2     1.1     1.6     1.3     1.5   \n",
       "info_separations              2.6     2.2     1.9     2.7     2.6     3.2   \n",
       "finance_hires                 2.8     2.6     2.3     2.4     2.8     2.4   \n",
       "finance_openings              2.8     3.7     3.9     3.1     3.8     3.8   \n",
       "finance_layoffs               0.9     0.7     0.6     0.6     0.8     0.7   \n",
       "finance_quits                 1.2     1.5     1.2     1.2     1.4     1.3   \n",
       "finance_separations           2.6     2.7     2.2     2.2     2.7     2.3   \n",
       "professional_hires            4.8     4.7     4.7     5.0     4.9     5.1   \n",
       "professional_openings         4.1     4.0     3.9     4.0     4.1     3.9   \n",
       "professional_layoffs          2.3     1.9     2.1     2.1     2.1     2.2   \n",
       "professional_quits            1.9     2.1     2.1     2.4     2.4     2.5   \n",
       "professional_separations      4.5     4.2     4.4     4.8     4.7     5.0   \n",
       "edu_health_hires              2.6     2.5     2.6     2.7     2.8     2.3   \n",
       "edu_health_openings           2.9     3.2     3.3     3.3     3.2     3.1   \n",
       "edu_health_layoffs            0.7     0.9     0.7     0.8     0.9     0.7   \n",
       "edu_health_quits              1.5     1.4     1.4     1.4     1.4     1.4   \n",
       "edu_health_separations        2.5     2.5     2.3     2.5     2.7     2.4   \n",
       "gov_hires                     1.3     1.4     1.2     1.3     1.3     1.1   \n",
       "gov_openings                  2.0     1.9     1.8     1.9     1.8     1.8   \n",
       "gov_layoffs                   0.4     0.4     0.6     0.4     0.5     0.4   \n",
       "gov_quits                     0.6     0.6     0.6     0.7     0.6     0.6   \n",
       "gov_separations               1.4     1.3     1.4     1.4     1.4     1.3   \n",
       "\n",
       "                          2013-07 2013-08 2013-09 2013-10  ... 2022-06  \\\n",
       "SeriesID                                                   ...           \n",
       "nonfarm_hires                 3.3     3.5     3.5     3.3  ...     4.2   \n",
       "nonfarm_openings              2.8     2.9     2.9     3.0  ...     6.7   \n",
       "nonfarm_layoffs               1.3     1.3     1.4     1.2  ...     1.0   \n",
       "nonfarm_quits                 1.7     1.7     1.7     1.7  ...     2.7   \n",
       "nonfarm_separations           3.2     3.3     3.3     3.2  ...     3.9   \n",
       "nonfarm_unemp_per_opening     2.9     2.8     2.7     2.6  ...     0.5   \n",
       "private_hires                 3.7     3.9     3.9     3.7  ...     4.6   \n",
       "private_openings              3.0     3.1     3.1     3.2  ...     7.1   \n",
       "private_layoffs               1.4     1.5     1.5     1.4  ...     1.1   \n",
       "private_quits                 1.9     1.9     1.9     1.9  ...     3.0   \n",
       "private_separations           3.6     3.7     3.7     3.5  ...     4.3   \n",
       "construction_hires            5.2     5.1     5.4     6.3  ...     4.7   \n",
       "construction_openings         1.7     1.9     2.1     2.3  ...     4.7   \n",
       "construction_layoffs          3.3     2.9     3.0     4.1  ...     2.1   \n",
       "construction_quits            1.8     1.6     1.6     1.6  ...     2.1   \n",
       "construction_separations      5.2     4.7     4.9     5.7  ...     4.3   \n",
       "manufacturing_hires           2.0     2.2     2.2     1.9  ...     3.7   \n",
       "manufacturing_openings        1.8     2.3     2.2     2.4  ...     6.2   \n",
       "manufacturing_layoffs         0.9     0.9     0.8     0.7  ...     0.7   \n",
       "manufacturing_quits           1.0     0.9     1.0     0.9  ...     2.4   \n",
       "manufacturing_separations     2.2     2.0     2.0     1.7  ...     3.4   \n",
       "trade_hires                   3.5     3.8     3.8     3.7  ...     4.5   \n",
       "trade_openings                2.7     2.9     3.0     2.9  ...     5.3   \n",
       "trade_layoffs                 1.3     1.2     1.2     1.3  ...     0.8   \n",
       "trade_quits                   1.8     2.1     2.1     2.0  ...     3.1   \n",
       "trade_separations             3.4     3.6     3.5     3.6  ...     4.1   \n",
       "info_hires                    3.3     3.1     3.5     3.0  ...     3.9   \n",
       "info_openings                 3.7     2.6     3.6     4.4  ...     6.7   \n",
       "info_layoffs                  1.7     2.2     1.6     1.6  ...     1.0   \n",
       "info_quits                    1.3     2.0     1.2     0.7  ...     2.1   \n",
       "info_separations              3.1     4.4     3.0     2.5  ...     3.2   \n",
       "finance_hires                 2.8     2.6     2.8     2.4  ...     2.3   \n",
       "finance_openings              4.1     3.0     3.1     3.2  ...     6.6   \n",
       "finance_layoffs               0.9     0.8     1.1     0.8  ...     0.5   \n",
       "finance_quits                 1.3     1.4     1.3     1.1  ...     1.5   \n",
       "finance_separations           2.6     2.5     2.7     2.3  ...     2.2   \n",
       "professional_hires            5.2     5.4     5.2     4.6  ...     5.6   \n",
       "professional_openings         3.6     4.2     3.9     4.2  ...     8.8   \n",
       "professional_layoffs          1.7     2.6     2.4     1.9  ...     1.7   \n",
       "professional_quits            2.8     2.5     2.3     2.4  ...     3.4   \n",
       "professional_separations      4.8     5.3     5.0     4.5  ...     5.4   \n",
       "edu_health_hires              2.6     2.8     2.6     2.4  ...     3.6   \n",
       "edu_health_openings           3.0     3.4     3.1     3.1  ...     8.1   \n",
       "edu_health_layoffs            0.8     0.9     0.8     0.7  ...     0.6   \n",
       "edu_health_quits              1.5     1.4     1.5     1.5  ...     2.4   \n",
       "edu_health_separations        2.6     2.5     2.5     2.4  ...     3.2   \n",
       "gov_hires                     1.2     1.4     1.3     1.3  ...     1.8   \n",
       "gov_openings                  1.7     1.8     1.8     1.8  ...     4.2   \n",
       "gov_layoffs                   0.4     0.4     0.5     0.5  ...     0.4   \n",
       "gov_quits                     0.6     0.6     0.6     0.6  ...     1.1   \n",
       "gov_separations               1.3     1.3     1.3     1.3  ...     1.8   \n",
       "\n",
       "                          2022-07 2022-08 2022-09 2022-10 2022-11 2022-12  \\\n",
       "SeriesID                                                                    \n",
       "nonfarm_hires                 4.1     4.2     4.1     4.0     4.1     4.0   \n",
       "nonfarm_openings              6.9     6.2     6.6     6.4     6.5     6.8   \n",
       "nonfarm_layoffs               1.0     1.1     0.9     1.0     1.0     1.0   \n",
       "nonfarm_quits                 2.6     2.8     2.6     2.6     2.7     2.6   \n",
       "nonfarm_separations           3.8     4.1     3.8     3.8     3.9     3.8   \n",
       "nonfarm_unemp_per_opening     0.5     0.6     0.5     0.6     0.6     0.5   \n",
       "private_hires                 4.5     4.6     4.4     4.4     4.4     4.4   \n",
       "private_openings              7.3     6.5     6.9     6.7     6.8     7.1   \n",
       "private_layoffs               1.1     1.2     1.0     1.1     1.1     1.0   \n",
       "private_quits                 2.9     3.1     2.9     2.9     3.0     2.9   \n",
       "private_separations           4.2     4.5     4.1     4.2     4.2     4.2   \n",
       "construction_hires            5.1     4.9     4.7     4.5     4.3     4.8   \n",
       "construction_openings         4.3     4.2     5.6     4.8     4.3     5.8   \n",
       "construction_layoffs          2.1     1.7     2.5     2.1     1.9     2.1   \n",
       "construction_quits            2.5     2.9     1.9     2.0     1.7     2.0   \n",
       "construction_separations      4.8     4.9     4.6     4.2     3.8     4.3   \n",
       "manufacturing_hires           3.4     3.7     3.1     3.4     3.1     3.1   \n",
       "manufacturing_openings        6.4     6.1     5.9     5.4     6.0     5.8   \n",
       "manufacturing_layoffs         0.8     0.9     0.7     0.8     0.8     0.8   \n",
       "manufacturing_quits           2.2     2.2     1.9     2.1     2.1     2.0   \n",
       "manufacturing_separations     3.2     3.4     2.9     3.1     3.0     3.0   \n",
       "trade_hires                   4.6     4.6     4.5     4.3     4.4     4.5   \n",
       "trade_openings                5.8     5.2     5.3     5.2     5.1     5.8   \n",
       "trade_layoffs                 1.0     1.2     1.0     1.0     0.9     1.1   \n",
       "trade_quits                   3.0     3.1     3.2     3.1     3.5     3.2   \n",
       "trade_separations             4.2     4.5     4.4     4.2     4.5     4.4   \n",
       "info_hires                    3.3     3.6     3.2     3.2     3.6     3.1   \n",
       "info_openings                 7.5     6.8     6.6     6.9     6.4     3.3   \n",
       "info_layoffs                  1.2     1.9     1.0     1.5     1.5     1.5   \n",
       "info_quits                    1.5     1.8     2.0     1.0     1.3     1.5   \n",
       "info_separations              3.1     3.8     3.2     3.0     3.1     3.2   \n",
       "finance_hires                 2.6     2.7     2.6     2.4     2.7     2.3   \n",
       "finance_openings              6.6     5.4     5.1     6.2     6.0     6.3   \n",
       "finance_layoffs               0.3     0.6     0.6     0.7     1.3     0.4   \n",
       "finance_quits                 1.8     1.6     1.5     1.6     1.4     1.5   \n",
       "finance_separations           2.4     2.6     2.4     2.4     3.0     2.2   \n",
       "professional_hires            5.5     5.4     5.2     5.1     5.1     5.1   \n",
       "professional_openings         8.4     7.6     8.7     7.7     8.5     8.4   \n",
       "professional_layoffs          1.5     1.8     1.4     1.6     1.6     1.5   \n",
       "professional_quits            3.6     3.2     3.3     3.1     3.2     3.1   \n",
       "professional_separations      5.4     5.2     4.9     4.9     5.1     4.9   \n",
       "edu_health_hires              3.5     3.5     3.3     3.3     3.5     3.6   \n",
       "edu_health_openings           8.4     7.9     8.3     8.0     7.7     7.7   \n",
       "edu_health_layoffs            0.7     0.5     0.6     0.6     0.5     0.6   \n",
       "edu_health_quits              2.2     2.4     2.2     2.4     2.5     2.5   \n",
       "edu_health_separations        3.0     3.1     2.9     3.0     3.1     3.3   \n",
       "gov_hires                     1.8     1.9     1.8     1.7     1.9     2.0   \n",
       "gov_openings                  4.8     4.4     4.6     4.1     4.6     4.7   \n",
       "gov_layoffs                   0.3     0.4     0.4     0.3     0.3     0.4   \n",
       "gov_quits                     0.9     1.0     1.0     1.0     1.0     1.0   \n",
       "gov_separations               1.5     1.7     1.7     1.6     1.6     1.8   \n",
       "\n",
       "                          2023-01 2023-02 2023-03  \n",
       "SeriesID                                           \n",
       "nonfarm_hires                 4.1     4.0     4.0  \n",
       "nonfarm_openings              6.4     6.0     5.8  \n",
       "nonfarm_layoffs               1.1     1.0     1.2  \n",
       "nonfarm_quits                 2.5     2.6     2.5  \n",
       "nonfarm_separations           3.8     3.8     3.8  \n",
       "nonfarm_unemp_per_opening     0.5     0.6     0.6  \n",
       "private_hires                 4.5     4.3     4.3  \n",
       "private_openings              6.7     6.3     6.0  \n",
       "private_layoffs               1.2     1.1     1.3  \n",
       "private_quits                 2.8     2.8     2.7  \n",
       "private_separations           4.2     4.1     4.2  \n",
       "construction_hires            4.9     4.7     5.1  \n",
       "construction_openings         3.5     4.9     4.1  \n",
       "construction_layoffs          2.0     2.3     3.7  \n",
       "construction_quits            2.3     1.9     1.9  \n",
       "construction_separations      4.5     4.5     5.8  \n",
       "manufacturing_hires           3.2     3.2     3.0  \n",
       "manufacturing_openings        5.3     5.2     5.1  \n",
       "manufacturing_layoffs         0.9     0.9     0.9  \n",
       "manufacturing_quits           2.1     2.1     2.1  \n",
       "manufacturing_separations     3.1     3.1     3.2  \n",
       "trade_hires                   4.6     4.4     4.2  \n",
       "trade_openings                6.0     5.5     4.8  \n",
       "trade_layoffs                 1.1     1.1     1.0  \n",
       "trade_quits                   3.2     3.1     3.0  \n",
       "trade_separations             4.5     4.4     4.2  \n",
       "info_hires                    2.7     3.1     3.4  \n",
       "info_openings                 4.3     5.2     5.6  \n",
       "info_layoffs                  1.5     1.6     1.2  \n",
       "info_quits                    1.3     1.4     1.5  \n",
       "info_separations              3.4     3.2     2.8  \n",
       "finance_hires                 2.3     2.3     2.1  \n",
       "finance_openings              4.7     4.8     5.1  \n",
       "finance_layoffs               0.6     0.4     0.6  \n",
       "finance_quits                 1.6     1.2     1.4  \n",
       "finance_separations           2.3     2.1     2.0  \n",
       "professional_hires            5.1     4.9     5.2  \n",
       "professional_openings         8.4     7.5     7.0  \n",
       "professional_layoffs          2.3     1.7     1.9  \n",
       "professional_quits            2.4     2.8     2.9  \n",
       "professional_separations      4.9     4.6     5.0  \n",
       "edu_health_hires              3.6     3.4     3.5  \n",
       "edu_health_openings           7.5     7.0     6.8  \n",
       "edu_health_layoffs            0.5     0.6     0.7  \n",
       "edu_health_quits              2.4     2.5     2.4  \n",
       "edu_health_separations        3.1     3.2     3.3  \n",
       "gov_hires                     1.8     1.8     1.8  \n",
       "gov_openings                  4.4     4.3     4.4  \n",
       "gov_layoffs                   0.4     0.4     0.3  \n",
       "gov_quits                     0.9     0.9     0.9  \n",
       "gov_separations               1.5     1.5     1.5  \n",
       "\n",
       "[51 rows x 123 columns]"
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert column names from bytes to strings\n",
    "df.columns = df.columns.astype(str)\n",
    "\n",
    "# remove 'M' from column names with regex substitution\n",
    "df.columns = [re.sub('M', '', column) for column in df.columns]\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9fbf3265",
   "metadata": {},
   "source": [
    "## Step 4: Data Analysis\n",
    "\n",
    "### 1. Exploratory Data Analysis\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "97e3366e",
   "metadata": {},
   "source": [
    "#### Tableau Trend Exploration\n",
    "\n",
    "1. Hires\n",
    "    1. Spring 2020 (Covid Quarantine)\n",
    "        - Big Picture: most sectors experienced some volatility between April and July 2020, but most increased their hires in the months after \n",
    "        - gov, info, finance, and professional went down sharply 4/1/2020 then bounced back within a few months\n",
    "        - edu/health and construction went way down (2.4) then way up (5.1) then back to previous levels and steadily increased\n",
    "        - manufacturing, trade only increased sharply then dropped to previous levels and steadily increased\n",
    "    2. Hires 10/1/2022 - Present (last 6 months)\n",
    "        - Big Picture: the professional, construction, and trade/utility sectors are hiring the most, information and construction are the most volatile, finance and government are hiring the least\n",
    "        - professional > construction > trade > edu/health > manufacturing, information, finance, gov\n",
    "        - Professional stable around 5.1\n",
    "        - Construction volatile 5.1-> 4.3 -> 5.1\n",
    "        - Trade volatile and decreasing 4.3 ^ˇ 4.1\n",
    "        - Total nonfarm (all) steady at 4.1\n",
    "        - Edu/health mostly steady at ~3.4\n",
    "        - Manufacturing mostly steady at 3.0-3.2\n",
    "        - Information somewhat volatile 3.6 -> 2.7 -> 3.5\n",
    "        - Finance decreasing 2.4 -> 2.1\n",
    "        - Government mostly steady 1.7-1.8\n",
    "2. Layoffs\n",
    "    1. Layoffs 10/1/2022 - Present (last 6+ months)\n",
    "        - Big Picture: most industries are fairly volatile in terms of layoffs, with amounts changing by .1-.5 month-to-month in many industries, though a big month is usually followed by a lower month\n",
    "        - construction > professional > info > trade > manufacturing > edu/health > finance > gov\n",
    "        - construction having a spike since January (2.0-3.7)\n",
    "3. Openings\n",
    "    1. Openings 10/1/2022 - Present (last 6+ months)\n",
    "        - Big Picture: professional > edu/health >> info* > manufacturing ~ finance > trade > gov > construction\n",
    "        - edu and health are at the top but slowly coming down from a high in March 21\n",
    "        - most volatility in info and construction\n",
    "        - government is consistently low/bottom\n",
    "        - finance is volatile but holding in the middle of the pack\n",
    "4. Quits\n",
    "    1. Quits 10/1/22 - Present\n",
    "        - Big Picture: trade > professional > edu/health > construction > manufacturing > info > finance > gov\n",
    "5. Total Separations\n",
    "    1. Total Separations 10/1/22 - Present\n",
    "        - Big Picture: professional >~ construction > trade > edu/health ~ manufacturing ~ info > finance > gov\n",
    "        - don't change our perspective of layoffs and quits much, though it's interesting that professional is far and above 1st with a slow decline since 11/21\n",
    "\n",
    "\n",
    "Big Picture:\n",
    "- **hiring**: professional > construction > trade > edu/health > manufacturing, info, finance, gov\n",
    "- **openings**: professional > edu/health >> info* > manufacturing ~ finance > trade > gov > construction\n",
    "- **layoffs**: construction > professional > info > trade > manufacturing > edu/health > finance > gov\n",
    "- **quits**: trade > professional > edu/health > construction > manufacturing > info > finance > gov\n",
    "- **total separations**: professional >~ construction > trade > edu/health ~ manufacturing ~ info > finance > gov\n",
    "\n",
    "\n",
    "Industry Take-Aways:\n",
    "1. Government and Finance are hiring and firing the least people -> low turnover?\n",
    "    - government also consistently has some of the fewest openings while finance is middle of the pack\n",
    "    - government and finance have the lowest quits as well\n",
    "2. Construction and Professional are hiring and firing the most people -> high turnover?\n",
    "    - construction is usually 2nd to last in openings with recent volatility (not looking for as many people as they are losing?)\n",
    "    - professional also has the highest openings -> high turnover!\n",
    "    - professional has the 2nd most quits as well, consistently high\n",
    "    - construction is mid in quits, volatile\n",
    "3. Edu/Health are mid-high in hiring and low in layoffs -> understaffed?\n",
    "    - edu/health has 2nd most openings -> hiring decent numbers of new people, not firing anyone, has lots of openings\n",
    "    - 3rd in quits, consistently mid-high, fair number of quits every month\n",
    "4. Info went from 3rd in openings in November to last in December, had a moderate but steady drop in new hires during that time, and was 3rd in layoffs after a 30% uptick in September -> layoffs then hiring freezes\n",
    "    - volatile openings but generally 3rd, lowest hires in December\n",
    "    - 2nd/3rd lowest quits -> those who have the jobs and haven't been fired are mostly staying (high months could correlate with big layoffs where people leave during periods of extreme change\n",
    "\n",
    "Big Thoughts:\n",
    "- Government and finance are interesting in their stability\n",
    "- Professional is having consistently high turnover\n",
    "- Construction is very volatile with turnover and lower openings and only middle in quits\n",
    "- Edu/Health appear to be understaffed with mid-high hires, low layoffs, lots of openings, and mid-high quits\n",
    "- Information had recent high layoffs in September and a steady drop in new hires since, still mid-low in hires but layoffs seem to be easing with a drop in March, and openings are on the rise after a sharp drop in December"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51bc99d3",
   "metadata": {},
   "source": [
    "### 2. Diagnostic Analysis: Last 8 months\n",
    "\n",
    "I mapped all statistics for the most interesting industries that seem to have a story appearing in their trends (most interesting at the top)\n",
    "\n",
    "General Relative Trend:\n",
    "- Openings is 1-4pp higher than hires\n",
    "- Hires and Total Separations are usually very similar and move together\n",
    "- Usually more quits than layoffs\n",
    "\n",
    "1. Information:\n",
    "- more volatility but trends remain similar (relative statistics)\n",
    "- consistently much more openings than separations and hires, though had a sharp bounce down in december to lowest since spring 2020\n",
    "- roughly similar hires and separations, slightly more hires\n",
    "- generally more quits than layoffs, but has flipped since October (round of layoffs)\n",
    "\n",
    "2. Edu/Health:\n",
    "- very steady across the board, not much volatility\n",
    "- consistently ~2x as many openings as separations and hires (understaffed)\n",
    "- way more quits than the very small number of layoffs\n",
    "- slightly more hires than separations (increasing employment)\n",
    "\n",
    "3. Professional:\n",
    "- very steady with noticable change since December\n",
    "- smaller gap between openings and hires\n",
    "- slightly more hires than separations\n",
    "- more quits than layoffs\n",
    "- December-February: drop in openings, hires, total separations, but increase in layoffs\n",
    "\n",
    "4. Construction:\n",
    "- about the same number of openings as separations and hires (nearly full employment?)\n",
    "- quits/layoffs are volatile and swap\n",
    "- last several months, more separations than hires and drop in openings, big round of layoffs\n",
    "- recent constriction of the sector\n",
    "\n",
    "5. Finance:\n",
    "- trends are low and stable\n",
    "- 2x openings to hires with recent drop to 1.5x\n",
    "- roughly equal hires and separations\n",
    "- more quits than layoffs (very few)\n",
    "- November: round of layoffs, then drop in openings and hires\n",
    "\n",
    "6. Government:\n",
    "- very low and stable\n",
    "- way more openings than hires & separations (+2x)\n",
    "- extremely stable and low quits, though still more than very very low layoffs\n",
    "- not as affected or changed the last 10 months, only a slight increase in turnover (hires & separations) in December\n",
    "\n",
    "7. Manufacturing:\n",
    "- usual relative trends\n",
    "- slight decrease in openings over time\n",
    "\n",
    "8. Trade\n",
    "- closer to full employment with small gap between openings and hires/separations\n",
    "- November: slight increase in quits and openings, now decreasing in all stats"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "42f67adf",
   "metadata": {},
   "source": [
    "# Future Revisions / Expansions\n",
    "1. Add education & health specific series as they have been industries of great interest in the labor market lately\n",
    "2. Look at raw numbers to see how many openings/hires/quits for important months/industries (e.g. Information sector https://www.bls.gov/iag/tgs/iag51.htm)\n",
    "3. Look at labor participation in these industries -> who could be working in them but is choosing not to or are moving to different industries?\n",
    "4. Take out 'total separations' and replace with 'other separations' to see nuance -> especially in health where leaving from illness/disability is more likely; however in comparing quits + layoffs = total separations - other separations, it seems to be a small fraction of the other two\n",
    "5. Looking at seasonally unadjusted data would be interesting\n",
    "6. Expand the sample to more industries; Mining/Logging, Leisure/Hospitality, Other Services"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7d09ee2d",
   "metadata": {},
   "source": [
    "## Step 5: Communication\n",
    "\n",
    "### Goals:\n",
    "    1. Using the Job Openings and Labor Turnover Survey, investigate the labor market as a whole in light of the 'Great Resignation'; which aspects of the GR have continued and which have changed?\n",
    "    3. Investigage recent layoffs and hiring freezes\n",
    "\n",
    "### Process:\n",
    "##### Jupyter Notebook\n",
    "    1. Data Collection:\n",
    "        - Found data on Bureau of Labor Statistics website\n",
    "        - Decided to use API for replicable data collection\n",
    "        - Imported into pandas dataframe\n",
    "    2. Data Cleaning:\n",
    "        - converted series IDs into descriptive headers\n",
    "##### Tableau\n",
    "        - pivoted monthly columns to a single date field\n",
    "        - converted YYYY-'M'MM format into filterable YYYY-MM format\n",
    "    3. Data Analysis\n",
    "        - graphed each statistic with all industries to see relative trends between industries\n",
    "        - graphed each industry with all statistics to see industry-specific trends\n",
    "\n",
    "### Conclusions:\n",
    "    1. Great Resignation & Macro Labor Market \n",
    "        - increase in quits and job openings rate in Spring 2021\n",
    "        - continued increase until Spring 2022\n",
    "        - gradual loosening of the labor market since, with layoffs and hiring freezes in Fall 2022 - Winter 2023\n",
    "    2. Total Nonfarm in last 5-6 months \n",
    "        - Job openings have decreased by 1.6 million (1pp) since December. Layoffs have increased by .2pp since December. Hires and total separations seem stable.\n",
    "    3. Industry-Specific Findings\n",
    "        a. Information has had recent high layoffs in September and a steady drop in new hires since, still mid-low in hires but layoffs seem to be easing with a drop in March, and openings are on the rise after a sharp drop in December\n",
    "        b. Professional is having consistently high turnover\n",
    "        c. Edu/Health appear to be understaffed with mid-high hires, low layoffs, high of openings, and mid-high quits\n",
    "        d. Construction is very volatile with turnover and lower openings and only middle in quits\n",
    "        e. Government and finance are interesting in their stability and low layoffs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3ab972a3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}