{"id":344,"date":"2024-03-19T19:01:02","date_gmt":"2024-03-19T16:01:02","guid":{"rendered":"https:\/\/www.datuskola.lv\/?p=344"},"modified":"2024-03-19T21:10:00","modified_gmt":"2024-03-19T18:10:00","slug":"datu-analize-ar-chatgpt-4","status":"publish","type":"post","link":"https:\/\/www.datuskola.lv\/index.php\/2024\/03\/19\/datu-analize-ar-chatgpt-4\/","title":{"rendered":"Datu anal\u012bze ar ChatGPT 4"},"content":{"rendered":"\n<p><em>Autors: Aivis Brut\u0101ns<\/em>,&nbsp;<em>datu zin\u0101tnieks un \u201cDatu skolas\u201d akt\u012bvists<\/em><\/p>\n\n\n\n<p id=\"2b1c\">OpenAI ChatGPT nav tikai r\u012bks, kur\u0161 pied\u0101v\u0101 ar lietot\u0101ju \u010datot, bet tas ir m\u0101ksl\u012bg\u0101 intelekta asistents (<em>AI assistent<\/em>), kur\u0161 pal\u012bdz veidot att\u0113lus, k\u0101 ar\u012b analiz\u0113t datus. Apl\u016bkosim, cik labas ir OpenAI ChatGPT 4 sniegt\u0101s datu anal\u012btikas sp\u0113jas.<\/p>\n\n\n\n<p id=\"cc19\">Vispirms j\u0101atz\u012bm\u0113, ka ChatGPT 4 \u0161obr\u012bd ir maksas pakalpojums, kas izmaks\u0101 20 USD m\u0113nes\u012b (<a href=\"https:\/\/openai.com\/chatgpt\/pricing\" rel=\"noreferrer noopener\" target=\"_blank\">https:\/\/openai.com\/chatgpt\/pricing<\/a>). Ta\u010du, ja lietot\u0101js nev\u0113las, lai OpenAI izmanto vi\u0146a uzvednes (<em>prompts<\/em>) mode\u013cu tren\u0113\u0161an\u0101, tad ir j\u0101iegulda v\u0113l vair\u0101k: j\u0101piesl\u0113dz biznesa klientu komplekts \u201cTeams\u201d par 25 USD\/m\u0113nes\u012b no katra lietot\u0101ja (minim\u0101lais lietot\u0101ju skaits: 2).<\/p>\n\n\n\n<p id=\"d5f6\">Datu anal\u012bz\u0113 izmantots&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/data.gov.lv\/dati\/lv\/dataset\/visparejas-videjas-izglitibas-ce-rezultatu-kopvertejums-un-limenu-sadalijums-pa-skolam-prieksmetos\" target=\"_blank\">atv\u0113rto datu port\u0101l\u0101 public\u0113ts<\/a>&nbsp;visp\u0101r\u0113j\u0101s vid\u0113j\u0101s izgl\u012bt\u012bbas centraliz\u0113to eks\u0101menu (CE) rezult\u0101tu kopv\u0113rt\u0113jums un l\u012bme\u0146u sadal\u012bjums pa skol\u0101m par 2022.\/2023. m\u0101c\u012bbu gadu. Uzvednes rakst\u012btas ang\u013cu valod\u0101.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p id=\"139b\">ChatGPT 4 datu anal\u012bz\u0113 izmanto&nbsp;<a href=\"https:\/\/www.python.org\/\" rel=\"noreferrer noopener\" target=\"_blank\">Python<\/a>&nbsp;programm\u0113\u0161anas valodu, t\u0101p\u0113c papildu datu anal\u012bzes skaidrojumiem&nbsp;<em>chat.openai.com<\/em>&nbsp;r\u012bk\u0101 atspogu\u013cots ar\u012b \u0161\u012bs programmas kods.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>\u201cPerform an exploratory data analysis about these data\u201d<\/p><\/blockquote>\n\n\n\n<p id=\"d532\">Pirmaj\u0101 uzvedn\u0113 aug\u0161upl\u0101d\u0113ju .csv failu ar CE rezult\u0101tiem un prasu lai sagatavo datu anal\u012bzi (<em>exploratory data analysis<\/em>). Jau datu nolas\u012b\u0161an\u0101 ChatGPT sask\u0101r\u0101s ar probl\u0113mu \u2014 tas nevar nolas\u012bt .csv failu.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*XSEqywJggU8e-0ave3AFSg.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>R\u012bks pats sp\u0113ja atrast k\u013c\u016bdu \u2014 .csv fail\u0101 kolonnu atdal\u012bt\u0101js ir semikols (nevis komats), ChatGPT papildin\u0101ja&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.read_csv.html\" target=\"_blank\"><em>read_csv<\/em><\/a>&nbsp;funkciju ar papildu parametru un faila datus nolas\u012bt izdev\u0101s.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*XMk4RdNvL7NCrSf3MRwuuA.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>P\u0113c faila nolas\u012b\u0161anas r\u012bks apraksta k\u0101das kolonnas ir atspogu\u013cotas fail\u0101:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*fHJZXUp077928ad1JQtXjw.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"cc7c\">Un datu anal\u012bz\u0113 pied\u0101v\u0101 izpild\u012bt sekojo\u0161us so\u013cus:<\/p>\n\n\n\n<ul><li>visp\u0101r\u012bgu statistiku \u2014 vid\u0113jo eks\u0101menu v\u0113rt\u0113jumu un k\u0101rtot\u0101ju skaitu,<\/li><li>k\u0101 sadal\u0101s v\u0113rt\u0113jumi un k\u0101rtot\u0101ju skaits starp da\u017e\u0101d\u0101m pa\u0161vald\u012bb\u0101m un izgl\u012bt\u012bbas iest\u0101d\u0113m,<\/li><li>tr\u016bksto\u0161o v\u0113rt\u012bbu apjoma nov\u0113rt\u0113\u0161ana un \u201cizlec\u0113ju\u201d (<em>outliers<\/em>) identific\u0113\u0161ana,<\/li><li>k\u0101da ir tendence un saist\u012bba starp vid\u0113jo eks\u0101mena v\u0113rt\u0113jumu un k\u0101rtot\u0101ju skaitu.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*xAc8jRBundOfBKNNOyL46w.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Vid\u0113, kur\u0101 tiek darbin\u0101ts&nbsp;<em>Python&nbsp;<\/em>kods, decim\u0101lskait\u013ca atdal\u012bt\u0101js ir punkts, t\u0101p\u0113c ChatGPT autom\u0101tiski p\u0101rveido kolonnas \u201c<em>Vid\u0113jais, %<\/em>\u201d v\u0113rt\u012bbas \u2014 aizvietojot komatu ar punktu:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*omUMhRWD40MzfkzMc-BctQ.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Ta\u010du r\u012bks \u0161eit sask\u0101r\u0101s ar k\u0101rt\u0113jo probl\u0113mu \u2014kolonn\u0101 \u201c<em>Vid\u0113jais, %<\/em>\u201d ir ieraksts ar v\u0113rt\u012bbu \u2018<em>#DIV\/0!<\/em>\u2019 un, t\u0101d\u0113j\u0101di, nevar \u0161o v\u0113rt\u012bbu p\u0101rv\u0113rst decim\u0101lskaitl\u012b. Bet ar to vi\u0146\u0161 tiek gal\u0101, papildinot&nbsp;<em>Python&nbsp;<\/em>kodu, kas \u0161\u0101das v\u0113rt\u012bbas aizvieto ar specifisku datu tipu&nbsp;<em>NaN<\/em>&nbsp;(<em>not a number<\/em>):<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*p-NAtFnvHrblN9lOcuU1Lw.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>R\u012bks t\u0101l\u0101k apraksta \u201c<em>Vid\u0113jais, %<\/em>\u201d un \u201c<em>K\u0101rtot\u0101ju skaits<\/em>\u201d amplit\u016bdas un vid\u0113jos r\u0101d\u012bt\u0101jus. ChatGPT nezina saist\u012bbas starp \u0161\u012bm kolonn\u0101m, t\u0101p\u0113c \u201c<em>Vid\u0113jais, %<\/em>\u201d vid\u0113jo rezult\u0101tu apr\u0113\u0137ina nepareizi \u2014 to vajag sv\u0113rt ar kolonnas \u201c<em>K\u0101rtot\u0101ju skaits<\/em>\u201d v\u0113rt\u012bb\u0101m:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*-IinZIka1E-TT5vuPrD4FA.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*mNSoxDJDOWorWSmL3EIZWg.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Lai redz\u0113tu sakar\u012bbu starp k\u0101rtot\u0101ju skaitu un vid\u0113jo eks\u0101mena v\u0113rt\u0113jumu, ChatGPT izveidoja grafikus. J\u0101\u0146em v\u0113r\u0101, ka vi\u0146\u0161 grafik\u0101 apkopojis inform\u0101ciju par visu priek\u0161metu centraliz\u0113tajiem eks\u0101meniem:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*aMAIvxSb8nzIg1qVGwFMpA.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Ar\u012b izveidotaj\u0101 histogramm\u0101 visi CE priek\u0161metu rezult\u0101ti atspogu\u013coti kop\u0101:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*TyDUoXaspCS4ZVCW5mvHWQ.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Nov\u0113roju, ka n\u0101kamaj\u0101 dien\u0101 grafiki vairs nav pieejami:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*VPxz8hZMFmwAGfoVTL3FVw.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"4a1b\">Pirm\u0101s uzvednes aprakstu ChatGPT nosl\u0113dz ar iepriek\u0161\u0113jo grafiku skaidrojumu:<\/p>\n\n\n\n<ul><li>nav stipras korel\u0101cijas starp vid\u0113jo CE rezult\u0101tu un eks\u0101menu k\u0101rtot\u0101ju skaitu,<\/li><li>vid\u0113jais CE v\u0113rt\u0113jums ir norm\u0101li sadal\u012bts ar nelielu asimetriju (<em>skewness<\/em>) uz augst\u0101ko v\u0113rt\u0113jumu pusi.<\/li><\/ul>\n\n\n\n<p id=\"8780\">T\u0101l\u0101k r\u012bks pied\u0101v\u0101 analiz\u0113t jau konkr\u0113tus eks\u0101menus vai pa\u0161vald\u012bbas, identific\u0113t \u201c<em>izlec\u0113jus<\/em>\u201d un trendu:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*h-8q1LeQnqpkZRPvyEnrHg.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"ed9f\">R\u012bks neizprot sakar\u012bbas starp kolonn\u0101m, t\u0101p\u0113c korektai vid\u0113j\u0101 CE rezult\u0101ta apr\u0113\u0137in\u0101\u0161anai turpm\u0101kajos so\u013cos preciz\u0113ts, ka \u0161is rezult\u0101ts ir j\u0101sver.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Prepare list of TOP 5 `Izsgl\u012bt\u012bbas iest\u0101des nosaukums` which has a largest average `Vid\u0113jais, %` where `P\u0101rbaud\u012bjums` LIKE `Eks\u0101mens matem\u0101tik\u0101%`. You need to weight average with `K\u0101rtot\u0101ju skaits`<\/p><\/blockquote>\n\n\n\n<p id=\"47f6\">Fr\u0101ze&nbsp;<em>`P\u0101rbaud\u012bjums` LIKE `Eks\u0101mens matem\u0101tik\u0101%`<\/em>&nbsp;ir veidota SQL sintakses stil\u0101, lai atlas\u012btu visus gad\u012bjumus, kuros kolonn\u0101 \u201cP\u0101rbaud\u012bjums\u201d v\u0113rt\u012bbas s\u0101kas ar \u2018Eks\u0101mens matem\u0101tik\u0101\u2019. \u0160\u0101du sintaksi nor\u0101d\u012bju uzvedn\u0113, cerot, ka tiks atlas\u012bti visi iesp\u0113jamie matem\u0101tikas eks\u0101menu p\u0101rbaud\u012bjuma veidi.<\/p>\n\n\n\n<p id=\"d768\">R\u012bks prec\u012bzi izpild\u012bja komandu. Ar\u012b apr\u0113\u0137in\u0101 ir izmantots vid\u0113ji sv\u0113rtais vid\u0113jais:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*gB1UypZz15ocW42jH4lHYg.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>What about TOP 5 lowest scores?<\/p><\/blockquote>\n\n\n\n<p id=\"9bd6\">Speci\u0101li uzdevu \u0161\u0101du jaut\u0101jumu, lai saprastu vai ChatGPT saprot, ka runa v\u0113l joproj\u0101m ir par matem\u0101tikas CE. Saprata:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*FfExl3fNTtfoMXyb6hzymQ.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Why these schools has lowest scores in maths?<\/p><\/blockquote>\n\n\n\n<p id=\"6f99\">Provokat\u012bvs jaut\u0101jums, jo zinu, ka no datiem \u0161o uzzin\u0101t nevar. Ta\u010du ar\u012b \u0161eit ChatGPT nesamulst:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*puweGzhOpmK-plVPm5IeVw.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*OpreXocwu8YXd3RDJpYZDw.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"4b78\">ChatGPT k\u0101 iesp\u0113jamos zemo v\u0113rt\u0113jumus sasaista ar:<\/p>\n\n\n\n<ul><li>m\u0101c\u012bbu materi\u0101lu, person\u0101la u.c. resursu tr\u016bkumu,<\/li><li>izgl\u012btojamo soci\u0101lekonomisko st\u0101vokli,<\/li><li>at\u0161\u0137ir\u012bgu fokusu uz m\u0101c\u012bbu priek\u0161metiem,<\/li><li>izgl\u012btojam\u0101 iesaistes l\u012bmeni,<\/li><li>atbalsta iesp\u0113j\u0101m.<\/li><\/ul>\n\n\n\n<p id=\"e063\">Lai saprastu prec\u012bzus zem\u0101 v\u0113rt\u0113juma iemeslus, algoritms iesaka veikt papildu anal\u012bzi \u2014 intervijas, nov\u0113ro\u0161anu, skolas politikas un prakses anal\u012bzi.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>How strong is a correlation between maths scores and physics (`P\u0101rbaud\u012bjums` like `Eks\u0101mens fizik\u0101%`) ?<\/p><\/blockquote>\n\n\n\n<p id=\"e665\">J\u0101\u0146em v\u0113r\u0101, ka ne vis\u0101s skol\u0101s tika k\u0101rtots gan matem\u0101tikas, gan fizikas CE. T\u0101p\u0113c, atkar\u012bb\u0101 no datu apstr\u0101des, var ieg\u016bt nepareizu rezult\u0101tu. Bet ar \u0161o r\u012bks tiek veiksm\u012bgi gal\u0101 \u2014tas izmanto pandas&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.merge.html\" target=\"_blank\">merge<\/a>&nbsp;funkciju, kur p\u0113c noklus\u0113juma datu savieno\u0161ana ir p\u0113c&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/support.microsoft.com\/lv-lv\/topic\/oper%C4%81cija-inner-join-b9e73ab6-884a-403e-9f22-cb502feae36a\" target=\"_blank\">INNER JOIN<\/a>&nbsp;principa.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*k_HNCcXl4IJPlFgJUzgaSw.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Rezult\u0101t\u0101 tiek ieg\u016bts pareizs korel\u0101cijas koeficients:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*-1PpPZVAe_IOFqDgMS3x-g.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Create a scatter plot with TOP 100 schools with highest scores in maths on x-axis and this schools\u2019 scores in physics on y-axis. If school doesn\u2019t have a score in physics then replace NaN with 0.<\/p><\/blockquote>\n\n\n\n<p id=\"6d59\">\u0160\u0101du grafiku izveido bez probl\u0113m\u0101m:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*bxy7Nx9K_hssoJHGQr8AsQ.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"3180\">P\u0113c grafika redzam skolas, kur\u0101s matem\u0101tikas CE v\u0113rt\u0113jums ir liel\u0101ks par 60 un skol\u0101 izgl\u012btojamie nav k\u0101rtoju\u0161i fizikas centraliz\u0113to eks\u0101menu. Noskaidrosim kuras ir \u0161\u012bs skolas.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Give me a list of schools which has an average maths score greater than 60, but doesn\u2019t have score in physics. Add sum of `K\u0101rtot\u0101ju skaits` in maths for each school.<\/p><\/blockquote>\n\n\n\n<p id=\"279d\">P\u0113c iepriek\u0161\u0113j\u0101 grafika inform\u0101cijas, r\u012bkam ir j\u0101atlasa 4 skolas. T\u0101 ar\u012b notiek:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*iMn8cTkW-0pBMHcXYVIR7Q.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Create a choropleth map which shows average score in maths in `Pa\u0161vald\u012bba` (Latvian cities and municipalities).<\/p><\/blockquote>\n\n\n\n<p id=\"716c\">R\u012bkam nav pieejas Latvijas pils\u0113tu un novadu robe\u017eu datiem, t\u0101p\u0113c tas kartogrammu nesp\u0113j izveidot:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*8_5A_InQOjBuoLwkdKMGRg.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Here are GeoJSON data.<\/p><\/blockquote>\n\n\n\n<p id=\"b7c8\">Izmantoju citus&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/data.gov.lv\/dati\/dataset\/7bb04db9-97ce-4a30-b93a-10ba8dafd104\/resource\/3ded58bd-c0dc-419a-97ff-59ba45a7b1b0\" target=\"_blank\">atv\u0113rtos datus<\/a>, kuros ir administrat\u012bvo teritoriju robe\u017eu dati&nbsp;<em>GeoJSON&nbsp;<\/em>form\u0101t\u0101. T\u0101 k\u0101 r\u012bks nesp\u0113js lejupl\u0101d\u0113t robe\u017eu datus pa tie\u0161o (..<em>since I cannot access external files or services to download the necessary geospatial data..<\/em>), aug\u0161upl\u0101d\u0113ju datus un prasu sagatavot karti, bet ChatGPT pirmo reizi saskaras ar probl\u0113mu, ko nevar atrisin\u0101t:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*mYYFK52e5mbD7Y5LsnPQuw.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*leYuDHFg42YkrXI0KA8dsw.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>R\u012bks iesaka izmantot p\u0113d\u0113jo versiju telpisko datu bibliot\u0113kas (<em>geospatial libraries<\/em>). Pats ChatGPT sav\u0101 vid\u0113 izmanto&nbsp;<em>shapely&nbsp;<\/em>pakotnes 1.7.1 versiju un iepriek\u0161 min\u0113t\u0101s k\u013c\u016bdas (\u201c<em>NotImplementedError: Multi-part geometries do not themselves provide the array interface<\/em>\u201d) atrisin\u0101\u0161anai&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/stackoverflow.com\/questions\/73347010\/why-do-i-get-an-error-when-trying-to-read-a-file-in-geopandas-included-datasets\" target=\"_blank\">iesaka \u0161o pakotni atjaunot<\/a>, ta\u010du ChatGPT neparedz iesp\u0113ju aug\u0161upl\u0101d\u0113t&nbsp;<em>Python&nbsp;<\/em>pakotnes un t\u0101s aizvietot ar cit\u0101m versij\u0101m.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*Vbpp-9L11A02kpVFUJT9Xw.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*wkqvEMCiNyxebJxGebr8MA.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Veicot visus tos pa\u0161us so\u013cus uz lok\u0101l\u0101 datora, ar jaun\u0101ko&nbsp;<em>shapely&nbsp;<\/em>pakotnes versiju ir iesp\u0113jams izveidot iepriek\u0161 pras\u012bto kartogrammu (valstpils\u0113t\u0101m neuzr\u0101d\u0101s dati, jo GeoJSON fail\u0101 tie ir ar cit\u0101d\u0101ku nosaukumu):<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*yH5KW1iGUzEXp0S5jp9nFQ.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Uzdevu papildu jaut\u0101jumus par datiem n\u0101kamaj\u0101 dien\u0101, bet ar to ChatGPT vairs netiek gal\u0101, jo ir beigusies sesija (laika interv\u0101ls, kur\u0101 ChatGPT apstr\u0101d\u0101 inform\u0101ciju un sniedz atbildi uz lietot\u0101ja jaut\u0101jumiem). Tas ir j\u0101\u0146em v\u0113r\u0101 veidojot datu anal\u012bzi. Varat r\u012bkam likt apkopot visu iepriek\u0161 min\u0113to&nbsp;<em>Python&nbsp;<\/em>kodu \u2014 p\u0113c tam \u0161o kodu izpild\u012bt uz sava lok\u0101l\u0101 datora.<\/p>\n\n\n\n<h2 id=\"1e8d\"><strong>K\u0101 ir ar latvie\u0161u valodu?<\/strong><\/h2>\n\n\n\n<p id=\"dc76\">Vai ir iesp\u0113jams visu iepriek\u0161 min\u0113to anal\u012bzi pras\u012bt latvie\u0161u valod\u0101 un visu vien\u0101 uzvedn\u0113? J\u0101 ir:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*4mwZ7eu7STfKzNUq7Lz3qg.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Bet ir \u013coti j\u0101piestr\u0101d\u0101 pie uzdevumu defin\u0113\u0161anas, lai ChatGPT tos saprastu. Augst\u0101k min\u0113t\u0101 uzvedne rakst\u012bta ar otro pieg\u0101jienu, ta\u010du rezult\u0101ts t\u0101pat neatbilst pras\u012btajam. Piem\u0113ram, \u0161\u012b uzdevuma \u201c<em>1) izveido v\u0113rt\u012bbamplit\u016bdas diagrammu (box-whisker plot). Uz x-ass ir kolonnas PARB v\u0113rt\u012bbas, uz y-ass ir \u201cvid\u0113ji sv\u0113rtais\u201d eks\u0101mena rezult\u0101ts. Katrs datu punkts nor\u0101da izgl\u012bt\u012bbas iest\u0101des (`Izgl\u012bt\u012bbas iest\u0101des nosaukums`) \u201cvid\u0113ji sv\u0113rto\u201d v\u0113rt\u0113jumu.<\/em>\u201d sagaid\u0101mais rezult\u0101ts:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*6RZVQoqgPN00SIUbfoVy8Q.png\" alt=\"\"\/><figcaption>1.uzdevuma sagaid\u0101mais rezult\u0101ts<\/figcaption><\/figure>\n\n\n\n<p>Bet ChatGPT sagatavoja grafiku tikai par \u010detriem priek\u0161metiem (kas min\u0113ti uzdevuma 2.punkt\u0101 un neattiecas uz 1.punktu):<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*jUGuvCv3A4aNumUonbv8Yw.png\" alt=\"\"\/><figcaption>1.uzdevuma ieg\u016btais rezult\u0101ts<\/figcaption><\/figure>\n\n\n\n<p>4.punkta sagaid\u0101mais rezult\u0101ts \u2014 pa\u0161vald\u012bba, kurai katr\u0101 p\u0101rbaud\u012bjum\u0101 ir slikt\u0101ks rezult\u0101ts nek\u0101 vid\u0113jais r\u0101d\u012bt\u0101js valst\u012b. P\u0113c \u0161\u0101diem krit\u0113rijiem atbilst tikai viena pa\u0161vald\u012bba:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*ynMA34pweaav6XlO5zuCow.png\" alt=\"\"\/><figcaption>4.uzdevuma sagaid\u0101mais rezult\u0101ts<\/figcaption><\/figure>\n\n\n\n<p>Ta\u010du ChatGPT sagatavoja statistiku atkal tikai par 2.punkta priek\u0161metiem un TOP 3 veidoja no p\u0101rbaud\u012bjumiem, nevis pa\u0161vald\u012bb\u0101m. Krit\u0113rijs \u2014 \u201c..<em>katr\u0101 no PARB eks\u0101meniem ir slikt\u0101ks par atbilsto\u0161o PARB veidu valst\u012b.<\/em>\u201d visp\u0101r netika iev\u0113rots:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*PoMStPehI-ARK6LrbC839w.png\" alt=\"\"\/><figcaption>4.uzdevuma ieg\u016btais rezult\u0101ts<\/figcaption><\/figure>\n\n\n\n<p id=\"4713\">T\u0101tad ieteicams veidot vair\u0101kas \u012bs\u0101kas uzvednes.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Which Python version are you using and list versions of Python packages that you have been imported?<\/p><\/blockquote>\n\n\n\n<p id=\"32c5\">Datu anal\u012bz\u0113 ChatGPT izmantoja sekojo\u0161as&nbsp;<em>Python&nbsp;<\/em>pakot\u0146u versijas:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*qonEClqV1X6zCo2WFu6MtA.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"6d4d\">ChatGPT \u0123ener\u0113tie kodi ir pieejami ar\u012b&nbsp;<a href=\"https:\/\/github.com\/aivisbr\/data_analysis\/blob\/main\/001_data_analysis_with_ChatGPT4.py\" rel=\"noreferrer noopener\" target=\"_blank\">GitHub<\/a>.<\/p>\n\n\n\n<h2 id=\"d223\"><strong>Secin\u0101jumi<\/strong><\/h2>\n\n\n\n<ul><li>ChatGPT 4 sp\u0113j identific\u0113t k\u013c\u016bdas&nbsp;<em>Python&nbsp;<\/em>koda izpild\u0113 un t\u0101s labot, ja k\u013c\u016bdas ir vienk\u0101r\u0161i identific\u0113jamas un labojamas. K\u013c\u016bdas, kas rodas&nbsp;<em>Python&nbsp;<\/em>pakot\u0146u nesader\u012bbas d\u0113\u013c, r\u012bks labot nesp\u0113j.<\/li><li>Pirms datu aug\u0161upl\u0101des ieteicams tos apstr\u0101d\u0101t t\u0101, lai ChatGPT nav j\u0101saskar\u0101s ar&nbsp;<em>Python&nbsp;<\/em>k\u013c\u016bd\u0101m, vai ar\u012b uzvedn\u0113 min\u0113t iesp\u0113jamos riskus ar ko r\u012bkam var\u0113tu n\u0101kties saskarties. T\u0101d\u0101 veid\u0101 tiktu pa\u0101trin\u0101ta datu anal\u012bze. Jo sare\u017e\u0123\u012bt\u0101ki datu modific\u0113\u0161anas krit\u0113riji, jo liel\u0101ka iesp\u0113jam\u012bba, ka r\u012bks \u0161\u0101du krit\u0113riju saprot cit\u0101d\u0101k.<\/li><li>Ja datu modific\u0113\u0161anu un p\u0113c tam \u0161o datu anal\u012bzi v\u0113laties veikt ar ChatGPT pal\u012bdz\u012bbu, tad iesaku datu izmai\u0146as un datu anal\u012bzi veikt atsevi\u0161\u0137\u0101s sesij\u0101s. Vien\u0101 \u2014 pal\u016bgt veikt nepiecie\u0161am\u0101s izmai\u0146as fail\u0101, otr\u0101 \u2014 veikt datu anal\u012bzi.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*gf_RTtgLXC6Ggje6GYYH8g.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/miro.medium.com\/v2\/resize:fit:700\/1*Cm9Ocs2iH-4FeSyfsrJSBQ.png\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>R\u012bks neizprot sakar\u012bbas starp kolonn\u0101m, t\u0101p\u0113c uzvedn\u0113 b\u016btu j\u0101piemin b\u016btiskas kopsakar\u012bbas, kas ir svar\u012bgas datu anal\u012bz\u0113 (piem\u0113ram, vid\u0113jais apr\u0113\u0137ins ir j\u0101sver ar kolonnu X u.tml.).<\/li><li>ChatGPT saprot uzvednes latvie\u0161u valod\u0101, ta\u010du piev\u0113rsiet uzman\u012bbu sare\u017e\u0123\u012bt\u0101k\u0101m valodas konstrukcij\u0101m. R\u012bks t\u0101s var\u0113tu nesaprast.<\/li><li>Vien\u0101 uzvedn\u0113 var nodefin\u0113t visas datu anal\u012btikas pras\u012bbas, ta\u010du ir j\u0101str\u0101d\u0101 pie uzved\u0146u prec\u012bza formul\u0113juma. V\u0113rt\u0113jot p\u0113c pat\u0113r\u0113t\u0101 laika uzved\u0146u defin\u0113\u0161an\u0101, veidot vair\u0101kas maz\u0101kas uzvednes \u0161aj\u0101 eksperiment\u0101 bija lab\u0101kais risin\u0101jums nek\u0101 aprakst\u012bt vienu lielu uzvedni.<\/li><li>ChatGPT 4 lietot\u0101jam ir j\u0101saprot&nbsp;<em>Python&nbsp;<\/em>kods, jo visi datu anal\u012bzes apr\u0113\u0137ini veidoti ar \u0161\u012bs programm\u0113\u0161anas valodas pal\u012bdz\u012bbu. Lietot\u0101js, kur\u0161 nep\u0101rzin&nbsp;<em>Python<\/em>, var nepaman\u012bt gad\u012bjumus, kad r\u012bks iedod rezult\u0101tu, bet datu atlase neatbilst nosac\u012bjumiem.<\/li><li>Ja nev\u0113laties ChatGPT \u0123ener\u0113to kodu izpild\u012bt v\u0113lreiz, tad iesaku r\u012bk\u0101 izveidotos grafikus saglab\u0101t \u2014 p\u0113c sesijas beig\u0101m att\u0113li var\u0113tu neb\u016bt vairs pieejami.<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>Ori\u0123in\u0101lais raksts public\u0113ts <a href=\"https:\/\/aivis.medium.com\/datu-anal%C4%ABze-ar-chatgpt-4-b2f031bdbb74\" target=\"_blank\" rel=\"noreferrer noopener\">\u0161eit<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Autors: Aivis Brut\u0101ns,&nbsp;datu zin\u0101tnieks un \u201cDatu skolas\u201d akt\u012bvists OpenAI ChatGPT nav tikai r\u012bks, kur\u0161 pied\u0101v\u0101 ar lietot\u0101ju \u010datot, bet tas ir m\u0101ksl\u012bg\u0101 intelekta asistents (AI assistent), kur\u0161 pal\u012bdz veidot att\u0113lus, k\u0101 ar\u012b analiz\u0113t datus. Apl\u016bkosim, cik labas ir OpenAI ChatGPT 4 sniegt\u0101s datu anal\u012btikas sp\u0113jas. Vispirms j\u0101atz\u012bm\u0113, ka ChatGPT 4 \u0161obr\u012bd ir maksas pakalpojums, kas [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":347,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14,11,15],"tags":[],"_links":{"self":[{"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/posts\/344"}],"collection":[{"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/comments?post=344"}],"version-history":[{"count":5,"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/posts\/344\/revisions"}],"predecessor-version":[{"id":350,"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/posts\/344\/revisions\/350"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/media\/347"}],"wp:attachment":[{"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/media?parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/categories?post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.datuskola.lv\/index.php\/wp-json\/wp\/v2\/tags?post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}