<jupyter_start><jupyter_text>Alpha and Delta Information (Deceased = COV ONLY)<jupyter_code>import pandas as pd
import os
input_loc = "input_data"
output_loc = "output_data"
infections_mz = pd.read_csv(os.path.join(os.getcwd(), input_loc, "infections_alpha_delta.csv"))
hospitalized_mz = pd.read_csv(os.path.join(os.getcwd(), input_loc, "hospitalized_alpha_delta.csv"))
deceased_mz_cov = pd.read_csv(os.path.join(os.getcwd(), input_loc, "deceased_alpha_delta_without_oc_cov.csv"))<jupyter_output><empty_output><jupyter_text>Prevent categorical data loss due to joins between files<jupyter_code>age_groups = ['0-4', '5-9', '10-14', '15-19', '20-24', '25-29','30-34', '35-39', '40-44',
       '45-49', '50-54', '55-59', '60-64', '65-69', '70-74', '75-79',
       '80-84', '85-89', '90-94', '95-99', '100+']

age_binding = [age for age in age_groups for period in ['Period 1', 'Period 2']]
period_binding = [period for age in age_groups for period in ['Period 1', 'Period 2']]

full_data = pd.DataFrame({
    'periods': period_binding,
    'age_groups': age_binding
})
full_data = full_data.merge(infections_mz, on=['age_groups', 'periods'], how='left')
full_data = full_data.merge(hospitalized_mz, on=['age_groups', 'periods'], how='left')
full_data = full_data.merge(deceased_mz_cov, on=['age_groups', 'periods'], how='left')
full_data.to_csv(os.path.join(os.getcwd(), output_loc, "infected_hospitalized_deceased[cov-only]_combined.csv"), index=False)<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.17905405405405406, 'fraction_numerical': 0.056081081081081084, 'mean_word_length': 6.794736842105263, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '2', 'dir': 'jupyter-structured-clean-dedup', 'id': '70943', 'license': 'MIT', 'n_tokens_mistral': 635, 'n_tokens_neox': 579, 'n_words': 107, 'path': 'Alpha_Delta_Info.ipynb', 'repo_name': 'Mlad-en/Cov-Reinfections', 'size': '1480'}