extension: .md
format_name: markdown
format_version: '1.3'
- jupytext_version: 1.10.2
+ jupytext_version: 1.11.1
kernelspec:
display_name: Python 3
language: python
```
```python Collapsed="false"
-england_wales_filename = 'uk-deaths-data/publishedweek082021.xlsx'
+england_wales_filename = 'uk-deaths-data/publishedweek122021.xlsx'
```
```python Collapsed="false"
-scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (10 March 2021).xlsx'
+scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (08 April 2021).xlsx'
```
```python
-n_ireland_filename = 'uk-deaths-data/Weekly_Deaths.xlsx'
+n_ireland_filename = 'uk-deaths-data/Weekly_Deaths - w e 2nd April 2021.XLSX'
```
```python Collapsed="false"
rd['year'] = 2021
rd['nation'] = 'Wales'
rd.dropna(inplace=True)
-rd.head()
+rd.tail()
```
```python
```python
ni_xls = pd.read_excel(n_ireland_filename,
sheet_name='Table 1',
- skiprows=[0, 1, 2, 3],
+ skiprows=[0, 1, 2],
header=0,
).rename(
columns={'Week Ending (Friday)': 'date_up_to', 'Total Number of Deaths Registered in Week (2021P)': 'deaths',
rd = ni_xls[ni_xls['deaths'].notna()][['week', 'date_up_to', 'deaths']]
rd['year'] = 2021
rd['nation'] = 'Northern Ireland'
-rd
+rd.tail()
```
```python
```
```python
-%sql select nation from all_causes_deaths group by nation
+%sql select nation, count(*) from all_causes_deaths group by nation
```
```python