1

So I'm working on the John Hopkins covid19 data and I'm having some problems with isos and plotly.chloropleth, but so what I want to do is add the two Congo rows together into one row for said dataset, namely:

enter image description here

and

enter image description here

That is, add the values together for all the dates and I'll keep just 'Congo' as one country. How would I go about doing that? Any help appreciated.

Also does anyone know why Greenland isn't in that dataset or am I just blind?

Henry Ecker
  • 34,399
  • 18
  • 41
  • 57
John
  • 81
  • 1
  • 6
  • Please do not link or embed external images of source code or data. Images make it difficult to efficiently assist you as they cannot be copied and offer poor usability as they cannot be searched. See: [Why not upload images of code/errors when asking a question?](https://meta.stackoverflow.com/q/285551/15497888) If you need assistance formatting a small sample of your DataFrame as a copyable piece of code for SO see [How to make good reproducible pandas examples](https://stackoverflow.com/q/20109391/15497888). – Henry Ecker Nov 14 '21 at 00:19
  • Without access to the data it is difficult to tell how countries are organised and what standard rules may or may not be acceptable to extract and group Country/Regions together. In addition, while you may eventually want to plot your results with plotly. This question does not currently appear to be _about_ plotting, but rather the DataFrame transformation which is why I have removed the plotly tag. – Henry Ecker Nov 14 '21 at 00:21
  • 2
    Why join the two Congo rows? You know they are two different countries. And I'm not sure which file you are looking at or which data, but when I look, I find Greenland, it's filed as a part of Denmark. – creanion Nov 14 '21 at 00:52
  • 2
    I realised that after. You're an absolute gentleman, creanion. I am blind it seems, very. – John Nov 14 '21 at 01:04
  • Hahaha! - Is your question answered @John? –  Nov 14 '21 at 01:16
  • 1
    Great, done and dusted.. For now. Good luck :) – creanion Nov 14 '21 at 01:45

0 Answers0