I have an excel file some dates, countries, namely:

"Austria", "Belgium", "Bulgaria", "Croatia", "Cyprus", "Czechia", "Denmark", "Estonia", "Finland", "France", "Germany", "Greece", "Hungary", "Iceland", "Ireland", "Italy", "Latvia", "Lithuania", "Luxembourg", "Malta", "Netherlands", "Norway", "Poland", "Portugal", "Romania", "Slovakia", "Slovenia", "Spain", "Sweden"

and total number of confirmed virus cases for each country on that date.

My task is to import the excel file into mathematica (already done) and find the total number of cases of all countries.

Dates in 1. column, countries in 2. column and number of cases in 5.

  • 1
    $\begingroup$ You posted a similar question not long ago that is no longer visible on your profile. It was closed and perhaps you deleted it. If you have already imported this file into Mathematica, then you can start by changing the title, and loading your data with the post. It is considered bad form to delete a question that has already received comments and then to ask the same question without significant changes. $\endgroup$
    – Syed
    Apr 30, 2023 at 11:07
  • $\begingroup$ How do i load data with the post? the previous post got closed because the title was apparently bad. I didn't really get what i was looking for. $\endgroup$ Apr 30, 2023 at 11:16
  • 2
    $\begingroup$ No post is closed due to a bad title. Select data from the Mathematica notebook cell and press Ctrl-C. Click on the Edit button under your post. Paste using Ctrl-V in the right spot and format it using the {...} icon. Thanks. $\endgroup$
    – Syed
    Apr 30, 2023 at 11:23

1 Answer 1


(* "13.2.1 for Mac OS X ARM (64-bit) (January 27, 2023)" *)


allCountries = {"Austria", "Belgium", "Bulgaria", "Croatia", "Cyprus", 
   "Czechia", "Denmark", "Estonia", "Finland", "France", "Germany", "Greece", 
   "Hungary", "Iceland", "Ireland", "Italy", "Latvia", "Lithuania", 
   "Luxembourg", "Malta", "Netherlands", "Norway", "Poland", "Portugal", 
   "Romania", "Slovakia", "Slovenia", "Spain", "Sweden"};


n = 20;

Example of data:

data = Transpose[{RandomDate[DateObject[{2022}, "Year"], n], 
     RandomChoice[allCountries, n], 
     RandomInteger[{1000, 10000}, n]}]

enter image description here

Total cases by country

(totals = Sort[{#[[1, 2]], Total[#[[All, 3]]]} & /@ GatherBy[data, #[[2]] &]]) // Grid

enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.