Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Zadaci za wannabe pythoniste

[es] :: Python :: Zadaci za wannabe pythoniste

Strane: << < .. 21 22 23 24 25 26 27 28 29 30 ... Dalje > >>

[ Pregleda: 52355 | Odgovora: 629 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

mjanjic
Šikagou

Član broj: 187539
Poruke: 2712



+700 Profil

icon Re: Zadaci za wannabe pythoniste17.04.2020. u 23:54 - pre 48 meseci
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.
Blessed are those who can laugh at themselves, for they shall never cease to be amused.
 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 00:04 - pre 48 meseci
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++ ;)
 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 08:33 - pre 48 meseci
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

 
Odgovor na temu

Panta_
Aleksandar Pantić
Kragujevac

Član broj: 214959
Poruke: 790



+162 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 10:32 - pre 48 meseci
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 

Prikačeni fajlovi
 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 10:59 - pre 48 meseci
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                 ---            
 
Odgovor na temu

Panta_
Aleksandar Pantić
Kragujevac

Član broj: 214959
Poruke: 790



+162 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 11:40 - pre 48 meseci
Ne, za sada samo poslednji i pretposlednji da izračuna nove slučajeve.
 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 11:44 - pre 48 meseci
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%        
 
Odgovor na temu

mjanjic
Šikagou

Član broj: 187539
Poruke: 2712



+700 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 17:07 - pre 48 meseci
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.
Blessed are those who can laugh at themselves, for they shall never cease to be amused.
 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 18:04 - pre 48 meseci
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%     
 
Odgovor na temu

mjanjic
Šikagou

Član broj: 187539
Poruke: 2712



+700 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 20:18 - pre 48 meseci
mislio sam na Python verziju
Blessed are those who can laugh at themselves, for they shall never cease to be amused.
 
Odgovor na temu

Panta_
Aleksandar Pantić
Kragujevac

Član broj: 214959
Poruke: 790



+162 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 21:24 - pre 48 meseci
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
 
Odgovor na temu

mjanjic
Šikagou

Član broj: 187539
Poruke: 2712



+700 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 21:45 - pre 48 meseci
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 :)
Blessed are those who can laugh at themselves, for they shall never cease to be amused.
 
Odgovor na temu

Panta_
Aleksandar Pantić
Kragujevac

Član broj: 214959
Poruke: 790



+162 Profil

icon Re: Zadaci za wannabe pythoniste18.04.2020. u 22:16 - pre 48 meseci
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
 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste19.04.2020. u 02:33 - pre 48 meseci
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.


[Ovu poruku je menjao Branimir Maksimovic dana 19.04.2020. u 04:41 GMT+1]

[Ovu poruku je menjao Branimir Maksimovic dana 19.04.2020. u 04:43 GMT+1]
 
Odgovor na temu

Panta_
Aleksandar Pantić
Kragujevac

Član broj: 214959
Poruke: 790



+162 Profil

icon Re: Zadaci za wannabe pythoniste19.04.2020. u 06:32 - pre 48 meseci
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
 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste19.04.2020. u 06:38 - pre 48 meseci
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             

 
Odgovor na temu

Branimir Maksimovic

Član broj: 64947
Poruke: 5534
109.72.51.23



+1064 Profil

icon Re: Zadaci za wannabe pythoniste19.04.2020. u 06:48 - pre 48 meseci
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 >>>          
 
Odgovor na temu

a1234567

Član broj: 46801
Poruke: 297
65.18.117.*



+3 Profil

icon Re: Zadaci za wannabe pythoniste22.04.2020. u 18:07 - pre 48 meseci
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')))


[Ovu poruku je menjao a1234567 dana 22.04.2020. u 19:24 GMT+1]
 
Odgovor na temu

djoka_l
Beograd

Član broj: 56075
Poruke: 3453

Jabber: djoka_l


+1462 Profil

icon Re: Zadaci za wannabe pythoniste22.04.2020. u 21:21 - pre 48 meseci
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.
 
Odgovor na temu

djoka_l
Beograd

Član broj: 56075
Poruke: 3453

Jabber: djoka_l


+1462 Profil

icon Re: Zadaci za wannabe pythoniste22.04.2020. u 22:20 - pre 48 meseci
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'))
 
Odgovor na temu

[es] :: Python :: Zadaci za wannabe pythoniste

Strane: << < .. 21 22 23 24 25 26 27 28 29 30 ... Dalje > >>

[ Pregleda: 52355 | Odgovora: 629 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.