projects
/
covid19.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Changed European data source and format
[covid19.git]
/
uk_deaths_import.md
diff --git
a/uk_deaths_import.md
b/uk_deaths_import.md
index e775661c8803ddaf2c8da3a68ff001d1b7c4e324..612783c9d629b396cdf8d7372c009d0cd503b70f 100644
(file)
--- a/
uk_deaths_import.md
+++ b/
uk_deaths_import.md
@@
-5,8
+5,8
@@
jupyter:
text_representation:
extension: .md
format_name: markdown
text_representation:
extension: .md
format_name: markdown
- format_version: '1.
2
'
- jupytext_version: 1.
9.1
+ format_version: '1.
3
'
+ jupytext_version: 1.
10.2
kernelspec:
display_name: Python 3
language: python
kernelspec:
display_name: Python 3
language: python
@@
-53,25
+53,36
@@
engine = create_engine(connection_string)
```
```python Collapsed="false"
```
```python Collapsed="false"
-england_wales_filename = 'uk-deaths-data/
copyofpublishedweek04
2021.xlsx'
+england_wales_filename = 'uk-deaths-data/
publishedweek05
2021.xlsx'
```
```python Collapsed="false"
```
```python Collapsed="false"
-scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (1
0
February 2021).xlsx'
+scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (1
5
February 2021).xlsx'
```
```python
n_ireland_filename = 'uk-deaths-data/Weekly_Deaths_0.xlsx'
```
```
```python
n_ireland_filename = 'uk-deaths-data/Weekly_Deaths_0.xlsx'
```
+```python Collapsed="false"
+# eng_xls = pd.read_excel(england_wales_filename,
+# sheet_name="Weekly figures 2021",
+# skiprows=[0, 1, 2, 3],
+# skipfooter=11,
+# header=0,
+# index_col=[1]
+# ).iloc[:99].T
+# eng_xls
+```
+
```python Collapsed="false"
eng_xls = pd.read_excel(england_wales_filename,
sheet_name="Weekly figures 2021",
skiprows=[0, 1, 2, 3],
```python Collapsed="false"
eng_xls = pd.read_excel(england_wales_filename,
sheet_name="Weekly figures 2021",
skiprows=[0, 1, 2, 3],
- skipfooter=1
1
,
+ skipfooter=1
0
,
header=0,
index_col=[1]
header=0,
index_col=[1]
- ).
iloc[:91].
T
+ ).T
eng_xls
```
eng_xls
```
@@
-415,7
+426,7
@@
def create_and_save_radar_plot(dataset, title_string, filename_suffix):
ax.set_xticklabels(dataset.index)
plt.legend()
plt.title(f"Deaths by week over years, {title_string}")
ax.set_xticklabels(dataset.index)
plt.legend()
plt.title(f"Deaths by week over years, {title_string}")
- plt.savefig(f'deaths
-radar-
2021{filename_suffix}.png')
+ plt.savefig(f'deaths
_radar_
2021{filename_suffix}.png')
plt.show()
```
plt.show()
```
@@
-469,19
+480,19
@@
create_and_save_radar_plot(deaths, 'all UK', '')
<!-- #endregion -->
```python
<!-- #endregion -->
```python
-create_and_save_radar_plot(deaths_e, 'England', '
-
england')
+create_and_save_radar_plot(deaths_e, 'England', '
_
england')
```
```python
```
```python
-create_and_save_radar_plot(deaths_w, 'Wales', '
-
wales')
+create_and_save_radar_plot(deaths_w, 'Wales', '
_
wales')
```
```python
```
```python
-create_and_save_radar_plot(deaths_s, 'Scotland', '
-
scotland')
+create_and_save_radar_plot(deaths_s, 'Scotland', '
_
scotland')
```
```python
```
```python
-create_and_save_radar_plot(deaths_i, 'Northern Ireland', '
-northern-
ireland')
+create_and_save_radar_plot(deaths_i, 'Northern Ireland', '
_northern_
ireland')
```
```python Collapsed="false"
```
```python Collapsed="false"