News for hackers. Stuff that matters.
Re:Modern CSV Version 2 Beta is now available by andi999 on Wednesday June 01, 2022 @01:19AM (#31578406)
How do you deal with decimal separator ',' used in a few countries instead of '.'?
Re:Modern CSV Version 2 Beta is now available by avgcorrection on Wednesday June 01, 2022 @02:17AM (#31578748)
Most countries by raw country count.
Re:Modern CSV Version 2 Beta is now available by andi999 on Wednesday June 01, 2022 @05:19AM (#31579682)
Re:Modern CSV Version 2 Beta is now available by deaddodo on Wednesday June 01, 2022 @05:59AM (#31579855)
Less people, by raw population count.
Re:Modern CSV Version 2 Beta is now available by bzxcvbn on Wednesday June 01, 2022 @10:58AM (#31582740)
Just for fun (and because I don't like unsourced claims) I fired up Mathematica to sum up the population of the countries listed. Here are the results:

    In[1]:= comma = {"Albania", "Algeria", "Andorra", "Angola", 
       "Argentina", "Armenia", "Austria", "Azerbaijan", "Belarus", 
       "Belgium", "Bolivia", "BosniaHerzegovina", "Brazil", "Bulgaria", 
       "Cameroon", "Canada", "Chile", "Colombia", "CostaRica", "Croatia", 
       "Cuba", "Cyprus", "CzechRepublic", "Denmark", "EastTimor", 
       "Ecuador", "Estonia", "FaroeIslands", "Finland", "France", 
       "Germany", "Georgia", "Greece", "Greenland", "Hungary", "Iceland", 
       "Indonesia", "Italy", "Kazakhstan", "Kosovo", "Kyrgyzstan", 
       "Latvia", "Lebanon", "Lithuania", "Luxembourg", "Macau", 
       "Mauritania", "Moldova", "Mongolia", "Montenegro", "Morocco", 
       "Mozambique", "Namibia", "Netherlands", "Macedonia", "Norway", 
       "Paraguay", "Peru", "Poland", "Portugal", "Romania", "Russia", 
       "Serbia", "Slovakia", "Slovenia", "Somalia", "SouthAfrica", 
       "Spain", "Suriname", "Sweden", "Switzerland", "Tunisia", "Turkey", 
       "Turkmenistan", "Ukraine", "Uruguay", "Uzbekistan", "Venezuela", 
       "Vietnam", "Zimbabwe"};
    
    In[2]:= Plus @@ (Entity["Country", #]["Population"] & /@ comma)
    
    Out[2]= Quantity[1990645326, "People"]
    
    In[3]:= period = {"Australia", "Bangladesh", "Botswana", "Cambodia", 
       "Canada", "China", "DominicanRepublic", "Egypt", "ElSalvador", 
       "Estonia", "Ethiopia", "Ghana", "Guatemala", "Guyana", "Honduras", 
       "HongKong", "India", "Ireland", "Israel", "Jamaica", "Japan", 
       "Jordan", "Kenya", "NorthKorea", "SouthKorea", "Libya", 
       "Liechtenstein", "Luxembourg", "Macau", "Malaysia", "Maldives", 
       "Malta", "Mexico", "Myanmar", "Namibia", "Nepal", "NewZealand", 
       "Nicaragua", "Nigeria", "Pakistan", "Panama", "Peru", 
       "Philippines", "Qatar", "SaudiArabia", "Singapore", "Somalia", 
       "SriLanka", "Switzerland", "Syria", "Taiwan", "Tanzania", 
       "Thailand", "Uganda", "UnitedArabEmirates", "UnitedKingdom", 
       "UnitedStates"};
    
    In[4]:= Plus @@ (Entity["Country", #]["Population"] & /@ period)
    
    Out[4]= Quantity[5210743028, "People"]
It's not accurate because I'm not taking into account things such as "only in French Canada" or "only in currency", so some countries are double counted. But it gives a rough estimate. Five billion people for the dot, two for the comma.
Re:Modern CSV Version 2 Beta is now available by evanem on Wednesday June 01, 2022 @02:56PM (#31586435)
That is really useful information. Thanks!
Re:Modern CSV Version 2 Beta is now available by avgcorrection on Wednesday June 01, 2022 @11:30AM (#31583328)
I felt like I had to add “raw count” even though the OP only mentioned countries since someone would inevitably feel chafed.
Re:Modern CSV Version 2 Beta is now available by deaddodo on Wednesday June 01, 2022 @11:56AM (#31583764)
Only “chafed” as far as it’s misrepresentative.
Re:Modern CSV Version 2 Beta is now available by evanem on Wednesday June 01, 2022 @10:28AM (#31582266)
This new version has a Convert Number Format command that can be used to convert between the two formats. It just occurred to me I didn't take that into account for the new statistics operations. I'll be sure to fix it.