Zadaci za wannabe pythoniste

Re: Zadaci za wannabe pythoniste 18.04.2020. u 00:54 · pre 79 meseci #501

Ovo je za pohvalu, ali po meni ovi csv fajlovi imaju smisla ako je potrebno analizirati broj zaraženih po određenim datumima u pojedinim državama. Ili da se bar keširaju, tj. sačuvaju lokalno stariji CSV fajlovi pa da se samo proveri datum zadnje izmene (u principu, za to može da se koristi lokalni git koji bi povukao sve izmene, a python koristio fajlove iz lokalnog repozitorijuma.
Mada i u tom slučaju mogu samo da se dodaju novi podaci, da se ne otvara ponovo blizu 100 fajlova, naravno ako već ranije obrađeni fajlovi nisu menjani.

Zbirni podaci po datumima (ukupan broj zaraženih do tog datuma) su dati svi u jednoj tabeli ovde: https://github.com/CSSEGISandD...data/csse_covid_19_time_series
pa je možda lakše sve pročitati iz jednog fajla ako su potrebni samo zbirni podaci do određenog datuma, a može se lako izračunati i broj novozaraženih po datumima na osnovu razlike vrednosti u dve kolone.

Potpis

Blessed are those who can laugh at themselves, for they shall never cease to be amused.

Re: Zadaci za wannabe pythoniste 18.04.2020. u 01:04 · pre 79 meseci #502

Nece vise to da apdejtuju, ovi dejliji su aktuelni. E sad jedino ako se koristi git mozes dobiti apdejtovane fajlove.
Inace ovo je vise za vezbanje jer sam ja sa git-om i csvkitom importovao u postgres za 5 minuta ;)
A kad je u bazi imas sql pa mozes da izvlacis kakve hoces podatke ::
Inace ovo mi je vezba da ne zardjam sa Rust-om jer radim samo C++ ;)

Re: Zadaci za wannabe pythoniste 18.04.2020. u 09:33 · pre 79 meseci #503

Evo dodao diff:

Code:

~/.../rust/covid19report >>> ./target/release/reports --results 10 --key deaths --diff 04-16-2020
from 04-16-2020
COUNTRY             diff                CONFIRMED           diff                DEATHS              diff                RECOVERED           diff                ACTIVE              diff
US                  US                  699706              31905               36773               3857                58545               3842                604388              24206
Italy               Italy               172434              3493                22745               575                 42727               2563                106962              355
Spain               Spain               190839              5891                20002               687                 74797               0                   96040               5204
France              France              149130              2039                18703               762                 35006               1679                95421               -402
United Kingdom      United Kingdom      109769              5624                14607               848                 394                 19                  94768               4757
Belgium             Belgium             36138               1329                5163                306                 7961                399                 23014               624
Iran                Iran                79494               1499                4958                89                  54064               1835                20472               -425
China               China               83760               357                 4636                1290                77552               -849                1572                -84
Germany             Germany             141397              3699                4352                300                 83114               6114                53931               -2715
Netherlands         Netherlands         30619               1236                3471                144                 315                 4                   26833               1088

Ponosan sam na ovaj feature :P

Re: Zadaci za wannabe pythoniste 18.04.2020. u 11:32 · pre 79 meseci #504

Imam već taj feature ;)

Code:
python covid19.py -t Deaths

Country                      Deaths              New Deaths

US                            36773               3921
Italy                         22745               575
Spain                         20002               687
France                        18703               762
United Kingdom                14607               848
Belgium                       5163                306
Iran                          4958                89
China                         4636                1290
Germany                       4352                300
Netherlands                   3471                144

python covid19.py -t Confirmed

Country                      Confirmed           New Confirmed

US                            699706              32883
Spain                         190839              5891
Italy                         172434              3493
France                        149130              2039
Germany                       141397              3699
United Kingdom                109769              5624
China                         83760               357
Iran                          79494               1499
Turkey                        78546               4353
Belgium                       36138               1329

Takođe sam dodao i procenat smrtnosti:

Code:
python covid19.py

COUNTRY                            CONFIRMED           DEATHS              MORTALITY RATE %    RECOVERED           ACTIVE

US                                 699706              36773               5.3                 58545               604388
Spain                              190839              20002               10.5                74797               96040
Italy                              172434              22745               13.2                42727               106962
France                             149130              18703               12.5                35006               95421
Germany                            141397              4352                3.1                 83114               53931
United Kingdom                     109769              14607               13.3                394                 94768
China                              83760               4636                5.5                 77552               1572
Iran                               79494               4958                6.2                 54064               20472
Turkey                             78546               1769                2.3                 8631                68146
Belgium                            36138               5163                14.3                7961                23014
Brazil                             33682               2141                6.4                 14026               17515
Canada                             32814               1355                4.1                 10545               20914

covid19.py10.95k

Re: Zadaci za wannabe pythoniste 18.04.2020. u 11:59 · pre 79 meseci #505

A da li moze diff dva proizvoljna datuma?
recimo:

Code:

~/.../rust/covid19report >>> ./target/release/reports --results 10 --key deaths --diff 03-10-2020 --date 03-11-2020
from 03-10-2020
COUNTRY             diff                CONFIRMED           diff                DEATHS              diff                RECOVERED           diff                ACTIVE              diff
China               ---                 80921               ---                 3161                ---                 61644               ---
Italy               ---                 12462               2313                827                 196                 1045                321
Iran                ---                 9000                ---                 354                 ---                 2959                ---
Korea, South        ---                 7755                ---                 60                  ---                 288                 ---
Spain               ---                 2277                582                 54                  19                  183                 151
France              ---                 2284                500                 48                  15                  12                  0
US                  ---                 1281                322                 36                  8                   8                   0
Japan               ---                 639                 58                  15                  5                   118                 17
United Kingdom      ---                 459                 ---                 8                   ---                 19                  ---
Cruise Ship         ---                 696                 ---                 7                   ---                 325                 ---

Re: Zadaci za wannabe pythoniste 18.04.2020. u 12:40 · pre 79 meseci #506

Ne, za sada samo poslednji i pretposlednji da izračuna nove slučajeve.

Re: Zadaci za wannabe pythoniste 18.04.2020. u 12:44 · pre 79 meseci #507

U medjuvremenu sam dodao procente:

Code:

~/.../rust/covid19report >>> ./target/release/reports --results 10 --key deaths --diff 03-03-2020 --date 03-04-2020
from 03-03-2020
COUNTRY             diff                CONFIRMED           diff                DEATHS              diff                RECOVERED           diff                ACTIVE              diff
Mainland China      ---                 80271                 120  0.15%        2981                   36  1.21%        49955                2551  5.11%
Italy               ---                 3089                  587 19.00%        107                    28 26.17%        276                   116 42.03%
Iran                ---                 2922                  586 20.05%        92                     15 16.30%        552                   261 47.28%
South Korea         ---                 5621                  435  7.74%        35                      7 20.00%        41                     11 26.83%
US                  ---                 153                    31 20.26%        11                      4 36.36%        8                       0  0.00%
Japan               ---                 331                    38 11.48%        6                       0  0.00%        43                      0  0.00%
Others              ---                 706                     0  0.00%        6                       0  0.00%        10                      0  0.00%
France              ---                 285                    81 28.42%        4                       0  0.00%        12                      0  0.00%
Australia           ---                 52                     13 25.00%        2                       1 50.00%        11                      0  0.00%
Hong Kong           ---                 105                     5  4.76%        2                       0  0.00%        37                      0  0.00%

Re: Zadaci za wannabe pythoniste 18.04.2020. u 18:07 · pre 79 meseci #508

Citat:

Panta_:
Ne, za sada samo poslednji i pretposlednji da izračuna nove slučajeve.

Pa samo umesto indeksa -1 i -2 stave se indeksi od odgovarajućih datuma. Ali, kao što reče neko ranije, lakše je ako je sve u bazi.

Takođe, zavisi da li češće trebaju brojevi po datumima ili ukupni do određenog datuma, pa tako treba i formirati kolone, odnosno u slučaju baze podatke u vrstama.

Potpis

Blessed are those who can laugh at themselves, for they shall never cease to be amused.

Re: Zadaci za wannabe pythoniste 18.04.2020. u 19:04 · pre 79 meseci #509

Pa evo ti:

Code:

~/.../rust/covid19report >>> ./target/release/reports --results 10 --key Recovered --diff 03-29-2020 --date 04-12-2020
from 03-29-2020
COUNTRY             diff                CONFIRMED           diff                DEATHS              diff                RECOVERED           diff                ACTIVE              diff
China               ---                 83134                1012  1.22%        3343                   39  1.17%        77956                2380  3.05%        1835                -1407 -76.68%
Spain               ---                 166831              86721 51.98%        17209               10406 60.47%        62391               47682 76.42%        87231               28633 32.82%
Germany             ---                 127854              65759 51.43%        3022                 2489 82.36%        60300               51089 84.72%        64532               12181 18.88%
Iran                ---                 71686               33377 46.56%        4474                 1834 40.99%        43894               31503 71.77%        23318                  40  0.17%
Italy               ---                 156363              58674 37.52%        19899                9120 45.83%        34211               21181 61.91%        102253              28373 27.75%
US                  ---                 555313              414404 74.63%       22019               19552 88.80%        32988               30323 91.92%        500306              500306 100.00%
France              ---                 133670              92962 69.55%        14412               11801 81.88%        27469               20243 73.69%        91789               60918 66.37%
Switzerland         ---                 25415               10586 41.65%        1106                  806 72.88%        12700               11105 87.44%        11609               -1325 -11.41%
Korea, South        ---                 10512                 929  8.84%        214                    62 28.97%        7368                 2335 31.69%        2930                -1468 -50.10%
Canada              ---                 24299               18019 74.16%        713                   649 91.02%        7123                 6657 93.46%        16463               16463 100.00%

Re: Zadaci za wannabe pythoniste 18.04.2020. u 21:18 · pre 79 meseci #510

mislio sam na Python verziju

Potpis

Blessed are those who can laugh at themselves, for they shall never cease to be amused.

Re: Zadaci za wannabe pythoniste 18.04.2020. u 22:24 · pre 79 meseci #511

Citat:

Pa samo umesto indeksa -1 i -2 stave se indeksi od odgovarajućih datuma

Pa, nije baš samo, al ajde. ;)

Code:
python covid19.py -D 04-12-2020 03-29-2020

COUNTRY                            CONFIRMED           DIFF                DEATHS              DIFF                RECOVERED           DIFF

US                                 554797              414204              21974               19566               32988               30323
Canada                             24299               18032               713                 650                 7123                6657
United Kingdom                     85201               65421               10629               9399                625                 474
China                              83134               4542                3343                156                 77956               5421
Netherlands                        25743               14813               2747                1976                295                 292
Australia                          6315                2331                60                  44                  1806                1566
Denmark                            6369                3805                273                 201                 2291                2218
France                             133669              92961               14412               11801               27469               20243

Re: Zadaci za wannabe pythoniste 18.04.2020. u 22:45 · pre 79 meseci #512

Da, treba sabrati sve datume između, ako su podaci dati pojedinjačno za datume, prebacio sam se na varijantu koju sam predložio, da kolone po datumima predstavljaju broj ukupno zaraženih do tog datuma.

Ako su potrebni grafikoni za broj novorazaženih i druge slične podatke po pojedinačnim datumima, onda mogu ovi podaci, a ako je potreban grafik za broj ukupno zaraženih na svaki datum, onda je bolje imati drugi fajl sa takvim podacima.

Samo jedna stvar mi nije jasna, da li iko negde predstavlja i broj trenutno zaraženih, koji se dobija oduzimanjem broja onih koji više nemaju virus od broja ukupno zaraženih od početka praćenja podataka?

I da staviš negde na Github, da mogu da te citiraju :)

Potpis

Blessed are those who can laugh at themselves, for they shall never cease to be amused.

Re: Zadaci za wannabe pythoniste 18.04.2020. u 23:16 · pre 79 meseci #513

Citat:

Samo jedna stvar mi nije jasna, da li iko negde predstavlja i broj trenutno zaraženih, koji se dobija oduzimanjem broja onih koji više nemaju virus od broja ukupno zaraženih od početka praćenja podataka?

Da ima, aktivni slučajevi na koje sam zaboravio.

Code:
covid19.py -D 04-12-2020 03-29-2020

COUNTRY                            CONFIRMED           DIFF                DEATHS              DIFF                RECOVERED           DIFF                ACTIVE              DIFF

US                                 554797              414204              21974               19566               32988               30323               499835              499835
Canada                             24299               18032               713                 650                 7123                6657                16463               16463
United Kingdom                     85201               65421               10629               9399                625                 474                 73947               55549
China                              83134               4542                3343                156                 77956               5421                1835                -1376
Netherlands                        25743               14813               2747                1976                295                 292                 22701               12801
Australia                          6315                2331                60                  44                  1806                1566                4449                725
Denmark                            6369                3805                273                 201                 2291                2218                3805                1386
France                             133669              92961               14412               11801               27469               20243               91788               60917

Re: Zadaci za wannabe pythoniste 19.04.2020. u 03:33 · pre 79 meseci #514

Nisu uneti svi podaci uvek pa ispada da us ima takvu promenu.

edit:
po kojoj koloni sortiras kada radis diff?

Ja recimo imam moguce nasetovati sorting key i koje kolone da prikaze:

Code:

~/.../rust/covid19report >>> ./target/release/reports --results 10 --key Confirmed  --diff 04-15-2020 --date 04-16-2020 --columns Active
from 04-15-2020
Active              diff                Confirmed           diff                Country             diff
580182              24253  4.18%        667801              31451  4.71%        US                  ---
90836                2753  3.03%        184948               7304  3.95%        Spain               ---
106607               1189  1.12%        168941               3786  2.24%        Italy               ---
95823                9899 10.33%        147091              12509  8.50%        France              ---
56646               -1703 -3.01%        137698               2945  2.14%        Germany             ---
90011                3790  4.21%        104145               4662  4.48%        United Kingdom      ---
1656                  -43 -2.60%        83403                  47  0.06%        China               ---
20897                -782 -3.74%        77995                1606  2.06%        Iran                ---
65461                3261  4.98%        74193                4801  6.47%        Turkey              ---
22390                 364  1.63%        34809                1236  3.55%        Belgium             ---

Kolone key i foreign_key automatski dodajem ako nije stavljeno.
foreign_key je uvek Country zato sto mislim da nema za sada smisla to unositi.

Re: Zadaci za wannabe pythoniste 19.04.2020. u 07:32 · pre 79 meseci #515

Sortiram po Confirmed, mada mogu lako da dodam sort_key kao parametar.

Code:
COUNTRY                            CONFIRMED           DIFF                DEATHS              DIFF                RECOVERED           DIFF                Active              DIFF

US                                 554797              414204              21974               19566               32988               30323               499835              499835
Spain                              166831              86721               17209               10406               62391               47682               87231               28633
Italy                              156363              58674               19899               9120                34211               21181               102253              28373
France                             133669              92961               14412               11801               27469               20243               91788               60917
Germany                            127854              65759               3022                2489                60300               51089               64532               12181
United Kingdom                     85201               65421               10629               9399                625                 474                 73947               55549
China                              83134               4542                3343                156                 77956               5421                1835                -1376

Sortirano po Deaths:

Code:
COUNTRY                            CONFIRMED           DIFF                DEATHS              DIFF                RECOVERED           DIFF                Active              DIFF

US                                 554797              414204              21974               19566               32988               30323               499835              499835
Italy                              156363              58674               19899               9120                34211               21181               102253              28373
Spain                              166831              86721               17209               10406               62391               47682               87231               28633
France                             133669              92961               14412               11801               27469               20243               91788               60917
United Kingdom                     85201               65421               10629               9399                625                 474                 73947               55549
Iran                               71686               33377               4474                1834                43894               31503               23318               40
Belgium                            29647               18811               3600                3169                6463                5104                19584               10538
China                              83134               4542                3343                156                 77956               5421                1835                -1376

1

Re: Zadaci za wannabe pythoniste 19.04.2020. u 07:38 · pre 79 meseci #516

Ja sam u medjuvremenu dodao, --no_multi_key zbog toga sto postoji kolona Combined_Key.

recimo zbog ovoga:

Code:

~/.../rust/covid19report >>> ./target/release/reports --results 10 --key Confirmed --columns Active,Combined_Key
Active              Combined_Key        Confirmed           Country
628693              Abbeville, South Carolina, US732197              US
96886               Spain               191726              Spain
107771              Italy               175925              Italy
93217               French Guiana, France149149              France
53483               Germany             143342              Germany
99402               Anguilla, United Kingdom115314              United Kingdom
1537                Anhui, China        83787               China
69986               Turkey              82329               Turkey
19850               Iran                80868               Iran
23382               Belgium             37183               Belgium

pa sad:

Code:

~/.../rust/covid19report >>> ./target/release/reports --results 10 --key Confirmed --columns Active,Combined_Key --no_multi_key
Active              Combined_Key        Confirmed           Country
96886               Spain               191726              Spain
107771              Italy               175925              Italy
92663               France              147969              France
53483               Germany             143342              Germany
122370              New York City, New York, US135572              US
98753               United Kingdom      114217              United Kingdom
69986               Turkey              82329               Turkey
19850               Iran                80868               Iran
122                 Hubei, China        68128               China
23382               Belgium             37183               Belgium

Re: Zadaci za wannabe pythoniste 19.04.2020. u 07:48 · pre 79 meseci #517

A tu je i convenient opcija -l da se izlistaju postojece kolone za odredjen datum posto postoji opcija --columns

Code:

~/.../rust/covid19report >>> ./target/release/reports -l --date 02-04-2020
Confirmed
Country/Region
Deaths
Last Update
Province/State
Recovered
~/.../rust/covid19report >>> ./target/release/reports -l
Active
Admin2
Combined_Key
Confirmed
Country_Region
Deaths
FIPS
Last_Update
Lat
Long_
Province_State
Recovered
~/.../rust/covid19report >>>

Re: Zadaci za wannabe pythoniste 22.04.2020. u 19:07 · pre 79 meseci #518

Zadatak 34:

Napisati funkciju koja će u datom engleskom tekstu izračunati zbir brojeva.
Računaju se samo posebni brojevi. Ako je broj deo reči, ne ulazi u zbir.

Mustre za text i očekivani zbir:

('hi') == 0
('who is 1st here') == 0
('my numbers is 2') == 2
('This picture is an oil on canvas '
'painting by Danish artist Anna '
'Petersen between 1845 and 1910 year') == 3755
('5 plus 6 is') == 11
('') == 0

Ja sam napravio ovakvo rešenje:

Code:
def sum_numbers(text: str) -> int:
    zbir = 0
    a = text.split()
    a = ['' if x == '1st' else x for x in a]
    for i in a:
        if i.isdigit():
            zbir += int(i)
    return zbir

print("Example:")
    print(sum_numbers(('This picture is an oil on canvas '
                       'painting by Danish artist Anna '
                       'Petersen between 1845 and 1910 year')))

Re: Zadaci za wannabe pythoniste 22.04.2020. u 22:21 · pre 79 meseci #519

Ne valja. Ne treba da radi samo za zadate primere nego i za druge slučajeve.
Probaj:
2nd
2020-04-22

Pa ćeš videti da ne radi kako treba.

Re: Zadaci za wannabe pythoniste 22.04.2020. u 23:20 · pre 79 meseci #520

Ne znam šta je cilj, da se nauče regularni izrazi ili nešto drugo.
Tvoj program ne prepoznaje int ako ima predznak + ili -

Code:

def MySum( InStr ):
  sum=0
  for i in InStr.split():
    try:
      sum += int(i)
    except:
      None
  return sum

print(MySum('1 2 3 abc 45 -11 +12a +1'))

Forum kao aplikacija na telefonu

Srodne teme