Hi All,
This is a sample of my data. I have expected cases from 2021-2050 and lower and upper limits for the same years.
I want to plot
1) a scatter plot with the CI for three 30 years, all countries in the same plot
2) a line chart with a CI as and around the line, all countries in the same plot.
something
like this:
How to indicate multiple expected cases without typing out all the 30 variable names?
Thanks,
Rubana
This is a sample of my data. I have expected cases from 2021-2050 and lower and upper limits for the same years.
I want to plot
1) a scatter plot with the CI for three 30 years, all countries in the same plot
2) a line chart with a CI as and around the line, all countries in the same plot.
something
How to indicate multiple expected cases without typing out all the 30 variable names?
HTML Code:
Country agegroup pop_20072020 cases_20072020 pop2021 pop2022 expected_cases2021 expected_cases2022 expected_cases2023 expected_cases2024 lower_limit2021 upper_limit2021 lower_limit2022 upper_limit2022 lower_limit2023 A >=50 67835 15 5671 5722 1.253999 1.265276 1.275227 1.285177 0 3.448803 0 3.469927 0 A 20-49 145892 7 9325 9174 0.44742 0.440175 0.434417 0.430819 0 1.758427 0 1.740524 0 A All age 213727 22 14996 14896 1.543614 1.533321 1.5256 1.522512 0 3.978713 0 3.960287 0 B >=50 266466 59 22410 22857 4.961946 5.060919 5.14705 5.216354 0.596052 9.327841 0.651698 9.470141 0.700467 B 20-49 450466 40 31111 30896 2.762561 2.74347 2.722248 2.711325 0 6.020202 0 5.989835 0 B All age 716932 99 53521 53753 7.39063 7.422666 7.443379 7.469616 2.062339 12.71892 2.082839 12.76249 2.096107 C >=50 62181 46 6052 6287 4.477123 4.650971 4.829257 4.997186 0.330002 8.624245 0.4241 8.877842 0.522133 C 20-49 199327 85 16501 16849 7.036603 7.185002 7.336813 7.500138 1.837496 12.23571 1.931358 12.43865 2.027957 C All age 261508 131 22553 23136 11.29772 11.58976 11.88883 12.1944 4.709884 17.88555 4.917327 18.2622 5.130849 D >=50 109389 43 9242 9455 3.632961 3.71669 3.797667 3.879823 0 7.36871 0 7.495242 0 D 20-49 321913 66 23409 23338 4.799415 4.784858 4.766611 4.743648 0.505619 9.09321 0.497579 9.072137 0.487515 D All age 431302 109 32651 32793 8.251663 8.28755 8.317119 8.341633 2.621539 13.88179 2.645197 13.9299 2.664709 E >=50 76835 6 7665 7902 0.598555 0.617063 0.632056 0.638771 0 2.114905 0 2.156677 0 E 20-49 161704 8 8681 8514 0.429476 0.421214 0.414139 0.413348 0 1.713925 0 1.693248 0 E All age 238539 14 16346 16416 0.959357 0.963465 0.966341 0.970449 0 2.879074 0 2.887289 0 F >=50 41870 6 3874 3961 0.555147 0.567614 0.579221 0.588966 0 2.015477 0 2.044251 0 F 20-49 55171 8 3840 3837 0.556814 0.556379 0.557104 0.560874 0 2.019336 0 2.01833 0 F All age 97041 14 7714 7798 1.11289 1.125009 1.137416 1.150977 0 3.180523 0 3.203869 0 All >=50 624576 185 54914 56184 16.26558 16.64175 16.98357 17.26437 8.360942 24.17022 8.646234 24.63728 8.906354 All 20-49 1.30E+06 224 92867 92608 15.58833 15.54486 15.50625 15.52018 7.850005 23.32666 7.817329 23.27238 7.788324 All All age 2.00E+06 409 147781 148792 30.85295 31.06402 31.25692 31.47217 19.96626 41.73963 20.14016 41.98787 20.2992
Rubana
