Chenesa data semutambo weDombo, Pepa, Chigero. Uyu mutambo une kana usina magumo? Chikamu 2. Inoshanda

В chikamu chekutanga Yakatsanangurwa kuti chinyorwa ichi chakaitwa pahwaro hwe dataset yemhedzisiro yecadastral valuation ye real estate zvinhu muKhanty-Mansi Autonomous Okrug.

Chikamu chinoshanda chinoratidzwa mumatanho. Kucheneswa kwese kwakaitwa muExcel, sezvo chiricho chishandiso chakajairika uye mashandiro anotsanangurwa anogona kudzokororwa nenyanzvi dzakawanda dzinoziva Excel. Yakanyatsokodzerawo basa remaoko.

Ini ndichaisa basa rekutanga nekuchengetedza iyo faira seye zero nhanho, sezvo iri 100 MB muhukuru, uye nemakumi nemazana emabasa aya, anotora nguva yakakura.
Nguva yekuvhura ndeye, paavhareji, 30 masekonzi.
Kuchengetedza nguva: 22 sec.

Danho rekutanga rinotanga nekutsanangura zviratidzo zvehuwandu hwe dataset.

Tafura 1. Statistical zviratidzo zve dataset

Technology 2.1.

Gadzira munda wekubatsira; Ndichaidaidza kuti AY. Parekodhi yega yega, gadzira fomula "=LEN(F365502)+LEN(G365502)+…+LEN(AW365502)"

Yese nguva yakashandiswa pachikuva 2.1 (yeSchumann formula) t21 = 1 awa.
Nhamba yezvikanganiso inowanikwa munhanho 2.1 (yeSchumann formula) n21 = 0 pcs.

Chikamu chechipiri.
Kuongorora zvikamu zve dataset.
2.2. Ese makoshero mumarekodhi anogadzirwa uchishandisa akajairwa zviratidzo. Naizvozvo, ngatiteverei nhamba nechiratidzo.

Tafura 2. Nhamba yezviratidzo zvezviratidzo mudheta nekutanga kuongororwa kwemigumisiro.





Technology 2.2.1.

Isu tinogadzira munda wekubatsira - "alpha1". Parekodhi rega rega, tinogadzira fomula "=CONCATENATE(Sheet1!B9;...Sheet1!AQ9)"
Tichagadzira sero yakagadziriswa inonzi "Omega-1." Tichapinda Windows-1251 mavara macode kubva pa32 kusvika 255 muchitokisi ichi, rimwe nerimwe.
Isu tinogadzira munda wekubatsira - "alpha2". Neformula "= TSVAGA(CHAR(Omega;1); "alpha1";N)".
Isu tinogadzira munda wekubatsira - "alpha3". Neformula "=IF(ISNUMBER("alpha2";N);1;0)"
Gadzira sero yakagadziriswa "Omega-2" ine fomula "=SUM("alpha3"N1:"alpha3"N365498)"

Tafura 3. Migumisiro yekuongorora kwekutanga kwemigumisiro

Tafura 4. Mhosho dzakanyorwa panguva ino

Yese nguva yakashandiswa pachikuva 2.2.1 (yeSchumann formula) t221 = 8 awa.
Nhamba yezvikanganiso zvakagadziriswa pachikuva 2.2.1 (yeSchumann formula) n221 = 0 pcs.

Stage 3.
Nhanho yechitatu ndeyekunyora mamiriro e dataset. Isu tinopa yakasarudzika nhamba (ID) kune yega yega rekodhi uye yega yega ndima. Izvi zvinodiwa pakuenzanisa iyo dataset yakashandurwa neyekutanga. Izvo zvinodiwawo kushandisa zvizere kugona kwemapoka uye kusefa. Pano, tinonongedzera zvakare kuTable 2.2.2 uye sarudza chiratidzo chisina kushandiswa mudheta. Mhedzisiro inoratidzwa mumufananidzo 10.

Fig.10. Kugovera zviziviso.

Yese nguva yakashandiswa pachikuva 3 (yeSchumann formula) t3 = 0,75 awa.
Nhamba yezvikanganiso inowanikwa munhanho 3 (yeSchumann formula) n3 = 0 pcs.

Sezvo iyo Schumann fomula ichida kuti nhanho iyi ipedze nekugadziriswa kwekukanganisa, isu tinodzokera padanho rechipiri.

Stage 2.2.2.
Panguva ino tichagadzirisawo nzvimbo mbiri uye katatu.

Fig.11. Nhamba yenzvimbo mbiri.

Kugadziriswa kwezvikanganiso zvakaonekwa muTable 2.2.4.

Tafura 5. Chikanganiso chekugadzirisa danho


Muenzaniso wekuti sei chinhu chakadai sekushandiswa kwemavara “e” kana “yo” kuchikosha unoratidzwa muMufananidzo 12.

Mufananidzo 12. Kusaenderana mutsamba "ё".

Nguva yose yakashandiswa pachikuva 2.2.2 t222 = maawa mana.
Nhamba yezvikanganiso inowanikwa munhanho 2.2.2 (yeSchumann formula) n222 = 583 pcs.

Danho rechina.
Kuongorora kwemunda redundancy kunokodzera mudanho iri. Pakati pe44 minda, 6 ndeiyi:
7 - Chinangwa chechimiro
16 - Nhamba yepasi pevhu
17 - Chinhu chevabereki
21 - Dare reMusha
38 - Zvimiro zvimiro (tsanangudzo)
40 - Cultural Heritage

Havana kana pekupinda. Kureva kuti havana basa.
Munda "22 - Guta" ine imwe chete yekupinda, Mufananidzo 13.

Mufananidzo 13. Iyo chete yekupinda Z_348653 mundima ye "Guta".

Munda "34 - Zita rechivako" rine zvinyorwa zvisingaenderane nechinangwa chemunda, Mufananidzo 14.

Mufananidzo 14. Muenzaniso wekupinda kusina.

Isu tinosiya minda iyi kubva mudhata uye tinorekodha shanduko kune 214 marekodhi.

Yese nguva yakashandiswa pachikuva 4 (yeSchumann formula) t4 = 2,5 awa.
Nhamba yezvikanganiso inowanikwa munhanho 4 (yeSchumann formula) n4 = 222 pcs.

Tafura 6. Kuongororwa kwedataset zviratidzo mushure mechikamu chechina

Kazhinji, kuongorora kuchinja zviratidzo (Table 6), tinogona kutaura kuti:
1) Chiyero cheavhareji yenhamba yezviratidzo kune yakajairwa deviation lever iri padyo ne3, zvichireva kuti pane zviratidzo zvekugovera kwakajairika (Six sigma rule).
2) Kutsauka kwakakosha kwehushoma uye huwandu hwemarevhisi kubva paavhareji lever inoratidza kuti kudzidza kwemiswe inzira inovimbisa mukutsvaga zvikanganiso.

Tichaongorora mhedzisiro yekutsvaga zvikanganiso tichishandisa nzira yaSchumann.

Zvitanho zvisina basa

2.1. Yese nguva yakashandiswa pachikuva 2.1 (yeSchumann formula) t21 = 1 awa.
Nhamba yezvikanganiso inowanikwa munhanho 2.1 (yeSchumann formula) n21 = 0 pcs.

3. Yese nguva yakashandiswa pachikuva 3 (yeSchumann formula) t3 = 0,75 awa.
Nhamba yezvikanganiso inowanikwa munhanho 3 (yeSchumann formula) n3 = 0 pcs.

Zvitanho zvinobudirira
2.2. Yese nguva yakashandiswa pachikuva 2.2.1 (yeSchumann formula) t221 = 8 awa.
Nhamba yezvikanganiso zvakagadziriswa pachikuva 2.2.1 (yeSchumann formula) n221 = 0 pcs.
Nguva yose yakashandiswa pachikuva 2.2.2 t222 = maawa mana.
Nhamba yezvikanganiso inowanikwa munhanho 2.2.2 (yeSchumann formula) n222 = 583 pcs.

Nguva yose yakashandiswa pachikuva 2.2 t22 = 8 + 4 = maawa gumi nemaviri.
Nhamba yezvikanganiso inowanikwa munhanho 2.2.2 (yeSchumann formula) n222 = 583 pcs.

4. Yese nguva yakashandiswa pachikuva 4 (yeSchumann formula) t4 = 2,5 awa.
Nhamba yezvikanganiso inowanikwa munhanho 4 (yeSchumann formula) n4 = 222 pcs.

Sezvo kune zero nhanho dzinofanirwa kuverengerwa muchikamu chekutanga cheSchumann modhi, uye kune rumwe rutivi, nhanho 2.2 uye 4 dzakazvimiririra, saka tichifunga kuti iyo Schumann modhi inofunga kuti nekuwedzera kwenguva yekuyedzwa, mukana wekuona kukanganisa unoderera, ndiko kuti, kuyerera kwekutadza kunoderera, zvino nekudzidza kuti ndeupi nhanho yatichaisa padanho rekutanga. yekukundikana inowanzoitika, iyo nhanho inoiswa pekutanga.

Fig.15.

Kubva paformula iri muFigure 15 zvinotevera kuti zviri nani kuisa nhanho yechina pamberi pechikamu 2.2 mukuverenga.

Tichishandisa iyo Schumann formula, tinoona iyo inofungidzirwa yekutanga nhamba yezvikanganiso:

Fig.16.

Kubva pane zvabuda muMufananidzo 16, zvinogona kuonekwa kuti nhamba yakafanotaurwa yezvikanganiso N2 = 3167, iyo yakakura kudarika chiyero chiduku che1459.

Somugumisiro wekururamisa, takagadzirisa zvikanganiso zve805, uye nhamba yakafanotaurwa ndeye 3167 - 805 = 2362, iyo ichiri kudarika zvishoma zvishoma zvatakagamuchira.

Isu tinotsanangura parameter C, lambda uye basa rekuvimbika:

Fig.17.

Chaizvoizvo, lambda chiratidzo chaicho cheyero iyo zvikanganiso zvinoonekwa padanho rega rega. Tichitarisa fungidziro yapfuura, chiratidzo ichi chaive 42,4 zvikanganiso paawa, iyo inofananidzwa neiyo Schumann chiratidzo. Tichitaura nezvechikamu chekutanga chechinhu ichi, zvakatemwa kuti chiyero chekuona kukanganisa kwemugadziri hachifanirwe kunge chiri pasi pe1 kukanganisa pamarekodhi 250,4, paine rekodhi paminiti iri kuongororwa. Nekudaro, iyo yakakosha lambda kukosha kweiyo Schumann modhi ndeiyi:
60 / 250,4 = 0,239617.

Kureva kuti, kudiwa kwekuita zvikanganiso zvekuona maitiro kunofanirwa kuitwa kusvika lambda, kubva kune iripo 38,964, yadzikira kusvika 0,239617.

Kana kusvika chiratidzo N (chinokwanisika nhamba yezvikanganiso) kubvisa n (yakagadziriswa nhamba yezvikanganiso) inoderera pazasi pechikumbaridzo chatakagamuchira (muchikamu chekutanga) - 1459 pcs.

Chikamu 1. Theoretical.

Source: www.habr.com