{"id":6123,"date":"2022-03-01T14:12:09","date_gmt":"2022-03-01T14:12:09","guid":{"rendered":"https:\/\/bentego.com\/pyspark-window-functions\/"},"modified":"2025-10-20T16:09:26","modified_gmt":"2025-10-20T16:09:26","slug":"pyspark-window-functions","status":"publish","type":"post","link":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/","title":{"rendered":"PySpark Window Functions"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\" wp-image-4806 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2022\/03\/xx-300x164.png\" alt=\"\" width=\"489\" height=\"268\" \/><\/p>\n<p>Merhabalar bug\u00fcnk\u00fc yaz\u0131mda size PySpark Window Functions\u2019\u0131n\u00a0 i\u015flevinden ve PySpark Sql ve PySpark DataFrame API ile kullan\u0131m\u0131ndan bahsedece\u011fim.<\/p>\n<p><strong>Pyspark:<\/strong> Apache Spark, Scala programlama dilinde yaz\u0131lm\u0131\u015ft\u0131r. PySpark, Apache Spark ve Python i\u015fbirli\u011fini desteklemek yani Spark i\u00e7in yaz\u0131lm\u0131\u015f bir Python API\u2019d\u0131r. PySpark sayesinde Python ve Spark\u2019\u0131n baz\u0131 \u00f6zellikleri birlikte kullan\u0131labilir hale gelir. Ayr\u0131ca PySpark, Apache Spark ve Python programlama dilinde Esnek Da\u011f\u0131t\u0131lm\u0131\u015f Veri K\u00fcmeleri (Resilient Distributed Datasets) ile aray\u00fcz olu\u015fturman\u0131za yard\u0131mc\u0131 olur. Spark, Python ve Java gibi bir programlama dili olmad\u0131\u011f\u0131 i\u00e7in PySpark\u2019a ihtiya\u00e7 duyulmu\u015ftur. Bu sayede geli\u015ftiriciler ve veri bilimciler, verileri h\u0131zl\u0131 bir \u015fekilde sorgulamak, analiz etmek ve d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in PySpark\u2019\u0131 uygulamalar\u0131na dahil ederler.<\/p>\n<p><strong>Window Functions:<\/strong> PySpark Window Functions i\u015flevleri bir grup\u00a0 girdi sat\u0131r\u0131 \u00fczerinde \u00e7e\u015fitli analitik i\u015flemler ger\u00e7ekle\u015ftirir ve her girdi sat\u0131r\u0131 i\u00e7in ayr\u0131 ayr\u0131 sonu\u00e7 d\u00f6nd\u00fcr\u00fcr. Bu i\u015flemin yap\u0131labilmesi i\u00e7in kullan\u0131lan veriyi partitionlamam\u0131z gerekir. PySpark Sql \u00fc\u00e7 t\u00fcr i\u015flevi destekler. Bunlar;<\/p>\n<ul>\n<li>S\u0131ralama Fonksiyonlar\u0131<\/li>\n<li>Analitik Fonksiyonlar<\/li>\n<li>Toplama (aggregate) Fonksiyonlar\u0131<\/li>\n<\/ul>\n<p>Kulland\u0131\u011f\u0131m\u0131z Versiyonlar ;<\/p>\n<ul>\n<li>Pyspark 3<\/li>\n<li>Python 3.6<\/li>\n<\/ul>\n<p>\u0130lk olarak gerekli k\u00fct\u00fcphaneleri import ediyoruz;<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZnJvbSBweXNwYXJrLnNxbCBpbXBvcnQgZnVuY3Rpb25zIGFzIEYKZnJvbSBweXNwYXJrLnNxbCBpbXBvcnQgU3BhcmtTZXNzaW9uCmZyb20gcHlzcGFyay5zcWwuZnVuY3Rpb25zIGltcG9ydCAqCmZyb20gcHlzcGFyay5zcWwud2luZG93IGltcG9ydCBXaW5kb3cKaW1wb3J0IHB5c3Bhcmsuc3FsLmZ1bmN0aW9ucyBhcyBmdW5j[\/fusion_syntax_highlighter]<\/p>\n<p>Spark session olu\u015fturuyoruz.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]c3BhcmsgPSBTcGFya1Nlc3Npb24uYnVpbGRlci5hcHBOYW1lKCJ3aW5kb3dfZnVuY19leGFtcGxlIikgXAogICAgICAgICAgICAgICAgICAgICAgICAgICAgLmNvbmZpZygic3BhcmsuZXhlY3V0b3IubWVtb3J5IiwgIjEwZyIpIFwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC5jb25maWcoInNwYXJrLnlhcm4uZXhlY3V0b3IubWVtb3J5T3ZlcmhlYWQiLCAiMTBnIikgXAogICAgICAgICAgICAgICAgICAgICAgICAgICAgLmNvbmZpZygic3BhcmsuZHluYW1pY0FsbG9jYXRpb24ubWF4RXhlY3V0b3JzIiwgIjUwIikgXAogICAgICAgICAgICAgICAgICAgICAgICAgICAgLmNvbmZpZygic3Bhcmsuc3FsLmF1dG9Ccm9hZGNhc3RKb2luVGhyZXNob2xkIiwgIi0xIikgXAogICAgICAgICAgICAgICAgICAgICAgICAgICAgLmNvbmZpZygic3Bhcmsuc3FsLmJyb2FkY2FzdFRpbWVvdXQiLCAiMzYwMCIpLmdldE9yQ3JlYXRlKCk=[\/fusion_syntax_highlighter]<\/p>\n<p>Csv format\u0131ndaki datay\u0131 okuyoruz.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGY9c3BhcmsucmVhZC5jc3YoIi90bXAvZGF0YS50eHQiKQ==[\/fusion_syntax_highlighter]<\/p>\n<p>Datay\u0131 tan\u0131yal\u0131m ve inceleyelim;<\/p>\n<p>printSchema() fonksiyonu ile \u015femay\u0131 inceleyebiliriz.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYucHJpbnRTY2hlbWEoKQoKcm9vdAogfC0tIGlkOiBzdHJpbmcgKG51bGxhYmxlID0gdHJ1ZSkKIHwtLSBuYW1lOiBzdHJpbmcgKG51bGxhYmxlID0gdHJ1ZSkKIHwtLSBjaXR5OiBzdHJpbmcgKG51bGxhYmxlID0gdHJ1ZSkKIHwtLSBhZ2U6IHN0cmluZyAobnVsbGFibGUgPSB0cnVlKQogfC0tIGdlbmRlcjogc3RyaW5nIChudWxsYWJsZSA9IHRydWUpCiB8LS0gY2FsbGRhdGU6IHN0cmluZyAobnVsbGFibGUgPSB0cnVlKQogfC0tIGNhbGx0aW1lOiBzdHJpbmcgKG51bGxhYmxlID0gdHJ1ZSk=[\/fusion_syntax_highlighter]<\/p>\n<p>Genel olarak datay\u0131 incelemek i\u00e7in ise show() fonksiyonunu kullanaca\u011f\u0131z.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYuc2hvdygxMCxGYWxzZSkKCistLS0rLS0tLS0rLS0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSsKfGlkIHxuYW1lIHxjaXR5ICAgIHxhZ2V8Z2VuZGVyfGNhbGxkYXRlfGNhbGx0aW1lfAorLS0tKy0tLS0tKy0tLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rCnwxICB8VG9sZ2F8aXN0YW5idWx8MjQgfEUgICAgIHwyMDIxMDExNnwxNSAgICAgIHwKfDIgIHxFY2UgIHxNYW5pc2EgIHwyMSB8SyAgICAgfDIwMjAxMDE0fDIwICAgICAgfAp8NCAgfFRvbGdhfGFua2FyYSAgfDExIHxFICAgICB8MjAyMTA1MDZ8NTAgICAgICB8CnwxICB8VG9sZ2F8aXN0YW5idWx8MjQgfEUgICAgIHwyMDIxMTExMXwzMCAgICAgIHwKfDMgIHxCdXJha3xIYXRheSAgIHw0MSB8RSAgICAgfDIwMjAwOTA4fDE4ICAgICAgfAp8NSAgfE1lcnZlfGl6bWlyICAgfDI3IHxLICAgICB8MjAxOTA1MDZ8MjIgICAgICB8Cnw3ICB8U2FtZXR8b3JkdSAgICB8NjQgfEUgICAgIHwyMDE5MDEwMXw4OSAgICAgIHwKfDkgIHxlbGlmIHxtYXJkaW4gIHw1NCB8SyAgICAgfDIwMjAxMDEwfDM2ICAgICAgfAp8NCAgfFRvbGdhfGFua2FyYSAgfDExIHxFICAgICB8MjAyMTA2MDd8MjIgICAgICB8Cnw2ICB8QmlsYWx8QnVyc2EgICB8MjEgfEUgICAgIHwyMDIxMDkwOXwxMiAgICAgIHwKKy0tLSstLS0tLSstLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKw==[\/fusion_syntax_highlighter]<\/p>\n<p>Burada parantez i\u00e7indeki ilk de\u011fer g\u00f6rmek istedi\u011fim sat\u0131r say\u0131s\u0131n\u0131, ikinci de\u011fer ise t\u00fcm s\u00fctunlar\u0131 g\u00f6rmek istedi\u011fimi belirtiyor.<\/p>\n<p>Datam\u0131z \u00fczerinde \u00f6rnekler yapmaya ba\u015flayal\u0131m;<\/p>\n<p><strong>1. S\u0131ralama Fonksiyonlar\u0131<\/strong><\/p>\n<p><strong>1.1. row_number()<\/strong>:\u00a01\u2019den ba\u015flayarak her window partition\u0131n sonuna kadar s\u0131ral\u0131 sat\u0131r numaras\u0131 verir.<\/p>\n<p>Bu ve di\u011fer \u00f6rnekler i\u00e7in olu\u015fturulan \u00a0window\u2019da \u201cid\u201d kolonu partition kolonu olarak belirlenmi\u015f ve s\u0131ralama \u201ccalldate\u201d kolonuna g\u00f6re yap\u0131lm\u0131\u015ft\u0131r.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]bXlfdz1XaW5kb3cucGFydGl0aW9uQnkoImlkIikub3JkZXJCeSgiY2FsbGRhdGUiKQpkZjI9ZGYud2l0aENvbHVtbigicm93X251bSIscm93X251bWJlcigpLm92ZXIobXlfdykpLnNob3coMTUsRmFsc2UpCgorLS0tKy0tLS0tKy0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSstLS0tLS0tKwp8aWQgfG5hbWUgfGNpdHkgICB8YWdlfGdlbmRlcnxjYWxsZGF0ZXxjYWxsdGltZXxyb3dfbnVtfAorLS0tKy0tLS0tKy0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSstLS0tLS0tKwp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDE4MDIyMHwxOCAgICAgIHwxICAgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDE5MDEwMXw4OSAgICAgIHwyICAgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDE5MDYwNHw4OSAgICAgIHwzICAgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMDcxNnwyNiAgICAgIHw0ICAgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMTAxMXwzNiAgICAgIHw1ICAgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMTAxOHw0MCAgICAgIHw2ICAgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMTAxOHw2NSAgICAgIHw3ICAgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIxMDYwOHwxMSAgICAgIHw4ICAgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDE3MDYwNHwzNSAgICAgIHwxICAgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMDUxNnw4NSAgICAgIHwyICAgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMDgxNHwxNyAgICAgIHwzICAgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMDkxNHw0MSAgICAgIHw0ICAgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMTExOHwzNSAgICAgIHw1ICAgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMTExOHwyMiAgICAgIHw2ICAgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIxMTExOHwzMyAgICAgIHw3ICAgICAgfAorLS0tKy0tLS0tKy0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSstLS0tLS0tKw==[\/fusion_syntax_highlighter]<\/p>\n<p>\u00c7\u0131kt\u0131n\u0131n idlere g\u00f6re grupland\u0131\u011f\u0131n\u0131 ve her grubun da kendi i\u00e7inde calldate\u2019e g\u00f6re s\u0131raland\u0131\u011f\u0131n\u0131 g\u00f6r\u00fcyoruz. Her grubun row_number\u2019\u0131 da kendi i\u00e7inde artan \u015fekilde verilmi\u015ftir.<\/p>\n<p><strong>1.2.rank():<\/strong> Bir window partition\u2019lar\u0131 i\u00e7in elde edilen sonucu\u00e7lar\u0131 kendi i\u00e7lerinde s\u0131ralar. Tekrar eden de\u011ferler varsa sonrakine ge\u00e7i\u015fte de\u011feri tekrar etti\u011fi kadar artt\u0131r\u0131r. Daha iyi anlamak i\u00e7in id de\u011feri 7 olan ki\u015fiye ait son 3 sat\u0131r\u0131 inceleyebiliriz.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYzPWRmLndpdGhDb2x1bW4oInJhbmsiLHJhbmsoKS5vdmVyKG15X3cpKS5zaG93KDE1LEZhbHNlKQoKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLSsKfGlkIHxuYW1lIHxjaXR5ICAgfGFnZXxnZW5kZXJ8Y2FsbGRhdGV8Y2FsbHRpbWV8cmFua3wKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLSsKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxODAyMjB8MTggICAgICB8MSAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTAxMDF8ODkgICAgICB8MiAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTA2MDR8ODkgICAgICB8MyAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDA3MTZ8MjYgICAgICB8NCAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTF8MzYgICAgICB8NSAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NDAgICAgICB8NiAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NjUgICAgICB8NiAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMTA2MDh8MTEgICAgICB8OCAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAxNzA2MDR8MzUgICAgICB8MSAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA1MTZ8ODUgICAgICB8MiAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA4MTR8MTcgICAgICB8MyAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA5MTR8NDEgICAgICB8NCAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MzUgICAgICB8NSAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MjIgICAgICB8NSAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMTExMTh8MzMgICAgICB8NyAgIHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLSs=[\/fusion_syntax_highlighter]<\/p>\n<p><strong>1.3.dense_rank():<\/strong> rank() fonksiyonu ile benzer i\u015fleve sahiptir ancak s\u0131ralamada tekrarlayan de\u011ferler olsa bile bo\u015fluk b\u0131rakmaz (de\u011fer atlamaz).<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYzPWRmLndpdGhDb2x1bW4oImRlbnNlX3JhbmsiLGRlbnNlX3JhbmsoKS5vdmVyKG15X3cpKS5zaG93KDE1LEZhbHNlKQoKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLSsKfGlkIHxuYW1lIHxjaXR5ICAgfGFnZXxnZW5kZXJ8Y2FsbGRhdGV8Y2FsbHRpbWV8ZGVuc2VfcmFua3wKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLSsKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxODAyMjB8MTggICAgICB8MSAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTAxMDF8ODkgICAgICB8MiAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTA2MDR8ODkgICAgICB8MyAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDA3MTZ8MjYgICAgICB8NCAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTF8MzYgICAgICB8NSAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NDAgICAgICB8NiAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NjUgICAgICB8NiAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMTA2MDh8MTEgICAgICB8NyAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAxNzA2MDR8MzUgICAgICB8MSAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA1MTZ8ODUgICAgICB8MiAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA4MTR8MTcgICAgICB8MyAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA5MTR8NDEgICAgICB8NCAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MzUgICAgICB8NSAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MjIgICAgICB8NSAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMTExMTh8MzMgICAgICB8NiAgICAgICAgIHwgICAgICAgIHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLSs=[\/fusion_syntax_highlighter]<\/p>\n<p><strong>1.4.percent_rank():<\/strong> Temelde rank fonksiyonu ile benzer \u00e7al\u0131\u015f\u0131r.Ancak belli farkl\u0131l\u0131klar vard\u0131r. Her window partition i\u00e7indeki ilk de\u011fer 0 son de\u011fer ise 1 de\u011ferini al\u0131r. Aradakiler i\u00e7inse 0-1 aral\u0131\u011f\u0131 eleman say\u0131s\u0131na b\u00f6l\u00fcn\u00fcr ve sonraki sat\u0131ra ge\u00e7tik\u00e7e 0\u2019dan ba\u015fyarak \u00e7\u0131kan de\u011fer kadar artt\u0131r\u0131l\u0131r.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGY0PWRmLndpdGhDb2x1bW4oInBlcmNlbnRfcmFuayIscGVyY2VudF9yYW5rKCkub3ZlcihteV93KSkuc2hvdygxNSxGYWxzZSkKCistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0rCnxpZCB8bmFtZSB8Y2l0eSAgIHxhZ2V8Z2VuZGVyfGNhbGxkYXRlfGNhbGx0aW1lfHBlcmNlbnRfcmFuayAgICAgICB8CistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0rCnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMTgwMjIwfDE4ICAgICAgfDAuMCAgICAgICAgICAgICAgICB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMTkwMTAxfDg5ICAgICAgfDAuMTQyODU3MTQyODU3MTQyODV8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMTkwNjA0fDg5ICAgICAgfDAuMjg1NzE0Mjg1NzE0Mjg1NyB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAwNzE2fDI2ICAgICAgfDAuNDI4NTcxNDI4NTcxNDI4NTV8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAxMDExfDM2ICAgICAgfDAuNTcxNDI4NTcxNDI4NTcxNCB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAxMDE4fDQwICAgICAgfDAuNzE0Mjg1NzE0Mjg1NzE0MyB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAxMDE4fDY1ICAgICAgfDAuNzE0Mjg1NzE0Mjg1NzE0MyB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjEwNjA4fDExICAgICAgfDEuMCAgICAgICAgICAgICAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMTcwNjA0fDM1ICAgICAgfDAuMCAgICAgICAgICAgICAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAwNTE2fDg1ICAgICAgfDAuMTY2NjY2NjY2NjY2NjY2NjZ8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAwODE0fDE3ICAgICAgfDAuMzMzMzMzMzMzMzMzMzMzMyB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAwOTE0fDQxICAgICAgfDAuNSAgICAgICAgICAgICAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAxMTE4fDM1ICAgICAgfDAuNjY2NjY2NjY2NjY2NjY2NiB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAxMTE4fDIyICAgICAgfDAuNjY2NjY2NjY2NjY2NjY2NiB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjExMTE4fDMzICAgICAgfDEuMCAgICAgICAgICAgICAgICB8CistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0r[\/fusion_syntax_highlighter]<\/p>\n<p>\u015eu ana kadar inceledi\u011fimiz fonksiyonlar\u0131n i\u015flevleri daha kolay ay\u0131rt edebilmek i\u00e7in a\u015fa\u011f\u0131daki tabloya bakabiliriz;<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYud2l0aENvbHVtbigicm93X251bSIscm93X251bWJlcigpLm92ZXIobXlfdykpXAogIC53aXRoQ29sdW1uKCJyYW5rIixyYW5rKCkub3ZlcihteV93KSlcCiAgLndpdGhDb2x1bW4oImRlbnNlX3JhbmsiLGRlbnNlX3JhbmsoKS5vdmVyKG15X3cpKVwKICAud2l0aENvbHVtbigicGVyY2VudF9yYW5rIixwZXJjZW50X3JhbmsoKS5vdmVyKG15X3cpKS5zaG93KDIwLEZhbHNlKQoKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLSstLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSsKfGlkIHxuYW1lIHxjaXR5ICAgfGFnZXxnZW5kZXJ8Y2FsbGRhdGV8Y2FsbHRpbWV8cm93X251bXxyYW5rfGRlbnNlX3Jhbmt8cGVyY2VudF9yYW5rICAgICAgIHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLSstLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSsKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxODAyMjB8MTggICAgICB8MSAgICAgIHwxICAgfDEgICAgICAgICB8MC4wICAgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTAxMDF8ODkgICAgICB8MiAgICAgIHwyICAgfDIgICAgICAgICB8MC4xNDI4NTcxNDI4NTcxNDI4NXwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTA2MDR8ODkgICAgICB8MyAgICAgIHwzICAgfDMgICAgICAgICB8MC4yODU3MTQyODU3MTQyODU3IHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDA3MTZ8MjYgICAgICB8NCAgICAgIHw0ICAgfDQgICAgICAgICB8MC40Mjg1NzE0Mjg1NzE0Mjg1NXwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTF8MzYgICAgICB8NSAgICAgIHw1ICAgfDUgICAgICAgICB8MC41NzE0Mjg1NzE0Mjg1NzE0IHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NDAgICAgICB8NiAgICAgIHw2ICAgfDYgICAgICAgICB8MC43MTQyODU3MTQyODU3MTQzIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NjUgICAgICB8NyAgICAgIHw2ICAgfDYgICAgICAgICB8MC43MTQyODU3MTQyODU3MTQzIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMTA2MDh8MTEgICAgICB8OCAgICAgIHw4ICAgfDcgICAgICAgICB8MS4wICAgICAgICAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAxNzA2MDR8MzUgICAgICB8MSAgICAgIHwxICAgfDEgICAgICAgICB8MC4wICAgICAgICAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA1MTZ8ODUgICAgICB8MiAgICAgIHwyICAgfDIgICAgICAgICB8MC4xNjY2NjY2NjY2NjY2NjY2NnwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA4MTR8MTcgICAgICB8MyAgICAgIHwzICAgfDMgICAgICAgICB8MC4zMzMzMzMzMzMzMzMzMzMzIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA5MTR8NDEgICAgICB8NCAgICAgIHw0ICAgfDQgICAgICAgICB8MC41ICAgICAgICAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MzUgICAgICB8NSAgICAgIHw1ICAgfDUgICAgICAgICB8MC42NjY2NjY2NjY2NjY2NjY2IHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MjIgICAgICB8NiAgICAgIHw1ICAgfDUgICAgICAgICB8MC42NjY2NjY2NjY2NjY2NjY2IHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMTExMTh8MzMgICAgICB8NyAgICAgIHw3ICAgfDYgICAgICAgICB8MS4wICAgICAgICAgICAgICAgIHwKfDMgIHxCdXJha3xIYXRheSAgfDQxIHxFICAgICB8MjAxNTA2MTd8MzYgICAgICB8MSAgICAgIHwxICAgfDEgICAgICAgICB8MC4wICAgICAgICAgICAgICAgIHwKfDMgIHxCdXJha3xIYXRheSAgfDQxIHxFICAgICB8MjAxODAxMzB8MTIgICAgICB8MiAgICAgIHwyICAgfDIgICAgICAgICB8MC4xNjY2NjY2NjY2NjY2NjY2NnwKfDMgIHxCdXJha3xIYXRheSAgfDQxIHxFICAgICB8MjAyMDAzMzB8MTMgICAgICB8MyAgICAgIHwzICAgfDMgICAgICAgICB8MC4zMzMzMzMzMzMzMzMzMzMzIHwKfDMgIHxCdXJha3xIYXRheSAgfDQxIHxFICAgICB8MjAyMDA2MDh8NTYgICAgICB8NCAgICAgIHw0ICAgfDQgICAgICAgICB8MC41ICAgICAgICAgICAgICAgIHwKfDMgIHxCdXJha3xIYXRheSAgfDQxIHxFICAgICB8MjAyMDA5MDh8MTggICAgICB8NSAgICAgIHw1ICAgfDUgICAgICAgICB8MC42NjY2NjY2NjY2NjY2NjY2IHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLSstLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSs=[\/fusion_syntax_highlighter]<\/p>\n<p><strong>1.5.ntile():<\/strong> Bir window partition i\u00e7indeki sonu\u00e7 sat\u0131rlar\u0131n\u0131n g\u00f6reli s\u0131ras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. \u0130lk \u00f6rnekte ntile fonksiyonuna parametre olarak 2\u2019yi verdik yani sonu\u00e7lar 1 ya da 2 de\u011ferini alacak \u015fekilde gelecek. \u0130kinci \u00f6rnekte ise prametre olarak 3\u2019\u00fc verdik bu durumda da 1-2-3 de\u011ferleri al\u0131nabilir.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYud2l0aENvbHVtbigibnRpbGUiLG50aWxlKDIpLm92ZXIobXlfdykpLnNob3coMTUsRmFsc2UpCgorLS0tKy0tLS0tKy0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSstLS0tLSsKfGlkIHxuYW1lIHxjaXR5ICAgfGFnZXxnZW5kZXJ8Y2FsbGRhdGV8Y2FsbHRpbWV8bnRpbGV8CistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tKwp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDE4MDIyMHwxOCAgICAgIHwxICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTAxMDF8ODkgICAgICB8MSAgICB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMTkwNjA0fDg5ICAgICAgfDEgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMDcxNnwyNiAgICAgIHwxICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTF8MzYgICAgICB8MiAgICB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAxMDE4fDQwICAgICAgfDIgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMTAxOHw2NSAgICAgIHwyICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMTA2MDh8MTEgICAgICB8MiAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMTcwNjA0fDM1ICAgICAgfDEgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMDUxNnw4NSAgICAgIHwxICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA4MTR8MTcgICAgICB8MSAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAwOTE0fDQxICAgICAgfDEgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMTExOHwzNSAgICAgIHwyICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MjIgICAgICB8MiAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjExMTE4fDMzICAgICAgfDIgICAgfAorLS0tKy0tLS0tKy0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSstLS0tLSs=[\/fusion_syntax_highlighter]<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYud2l0aENvbHVtbigibnRpbGUiLG50aWxlKDMpLm92ZXIobXlfdykpLnNob3coMTUsRmFsc2UpCgorLS0tKy0tLS0tKy0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSstLS0tLSsKfGlkIHxuYW1lIHxjaXR5ICAgfGFnZXxnZW5kZXJ8Y2FsbGRhdGV8Y2FsbHRpbWV8bnRpbGV8CistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tKwp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDE4MDIyMHwxOCAgICAgIHwxICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTAxMDF8ODkgICAgICB8MSAgICB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMTkwNjA0fDg5ICAgICAgfDEgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMDcxNnwyNiAgICAgIHwyICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTF8MzYgICAgICB8MiAgICB8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAxMDE4fDQwICAgICAgfDIgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMTAxOHw2NSAgICAgIHwzICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMTA2MDh8MTEgICAgICB8MyAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMTcwNjA0fDM1ICAgICAgfDEgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMDUxNnw4NSAgICAgIHwxICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA4MTR8MTcgICAgICB8MSAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAwOTE0fDQxICAgICAgfDIgICAgfAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMTExOHwzNSAgICAgIHwyICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MjIgICAgICB8MyAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjExMTE4fDMzICAgICAgfDMgICAgfAorLS0tKy0tLS0tKy0tLS0tLS0rLS0tKy0tLS0tLSstLS0tLS0tLSstLS0tLS0tLSstLS0tLSs=[\/fusion_syntax_highlighter]<\/p>\n<p><strong>2. Analitik Fonksiyonlar<\/strong><\/p>\n<p><strong>2.1.cume_dist():<\/strong> Bir window partition i\u00e7indeki de\u011ferlerin k\u00fcm\u00fclatif da\u011f\u0131l\u0131m\u0131n\u0131 eldek etmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYud2l0aENvbHVtbigiY3VtZV9kaXN0IixjdW1lX2Rpc3QoKS5vdmVyKG15X3cpKS5zaG93KDE1LEZhbHNlKQoKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSsKfGlkIHxuYW1lIHxjaXR5ICAgfGFnZXxnZW5kZXJ8Y2FsbGRhdGV8Y2FsbHRpbWV8Y3VtZV9kaXN0ICAgICAgICAgIHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSsKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxODAyMjB8MTggICAgICB8MC4xMjUgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTAxMDF8ODkgICAgICB8MC4yNSAgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTA2MDR8ODkgICAgICB8MC4zNzUgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDA3MTZ8MjYgICAgICB8MC41ICAgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTF8MzYgICAgICB8MC42MjUgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NDAgICAgICB8MC44NzUgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NjUgICAgICB8MC44NzUgICAgICAgICAgICAgIHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMTA2MDh8MTEgICAgICB8MS4wICAgICAgICAgICAgICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAxNzA2MDR8MzUgICAgICB8MC4xNDI4NTcxNDI4NTcxNDI4NXwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA1MTZ8ODUgICAgICB8MC4yODU3MTQyODU3MTQyODU3IHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA4MTR8MTcgICAgICB8MC40Mjg1NzE0Mjg1NzE0Mjg1NXwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA5MTR8NDEgICAgICB8MC41NzE0Mjg1NzE0Mjg1NzE0IHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MzUgICAgICB8MC44NTcxNDI4NTcxNDI4NTcxIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDExMTh8MjIgICAgICB8MC44NTcxNDI4NTcxNDI4NTcxIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMTExMTh8MzMgICAgICB8MS4wICAgICAgICAgICAgICAgIHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSs=[\/fusion_syntax_highlighter]<\/p>\n<p><strong>2.2.lead():<\/strong> Fonksiyonun ald\u0131\u011f\u0131 parametredeki offset de\u011ferine g\u00f6re sonraki sat\u0131r verisini getiren fonksiyondur. Sql\u2019deki lead fonksiyonu ile ayn\u0131 i\u015flevdedir. A\u015fa\u011f\u0131daki \u00f6rnekte her ki\u015finin sonraki arama tarihinin yeni kolona yazd\u0131r\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6rebiliriz.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYud2l0aENvbHVtbigic29ucmFraSIsIGZ1bmMubGVhZChjb2woImNhbGxkYXRlIikpLm92ZXIobXlfdykpLnNob3coMTUsRmFsc2UpCistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKwp8aWQgfG5hbWUgfGNpdHkgICB8YWdlfGdlbmRlcnxjYWxsZGF0ZXxjYWxsdGltZXxzb25yYWtpIHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rCnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMTgwMjIwfDE4ICAgICAgfDIwMTkwMTAxfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDE5MDEwMXw4OSAgICAgIHwyMDE5MDYwNHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTA2MDR8ODkgICAgICB8MjAyMDA3MTZ8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAwNzE2fDI2ICAgICAgfDIwMjAxMDExfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMTAxMXwzNiAgICAgIHwyMDIwMTAxOHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NDAgICAgICB8MjAyMDEwMTh8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAxMDE4fDY1ICAgICAgfDIwMjEwNjA4fAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIxMDYwOHwxMSAgICAgIHxudWxsICAgIHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAxNzA2MDR8MzUgICAgICB8MjAyMDA1MTZ8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAwNTE2fDg1ICAgICAgfDIwMjAwODE0fAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMDgxNHwxNyAgICAgIHwyMDIwMDkxNHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA5MTR8NDEgICAgICB8MjAyMDExMTh8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAxMTE4fDM1ICAgICAgfDIwMjAxMTE4fAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMTExOHwyMiAgICAgIHwyMDIxMTExOHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMTExMTh8MzMgICAgICB8bnVsbCAgICB8CistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKw==[\/fusion_syntax_highlighter]<\/p>\n<p><strong>2.3.lag():<\/strong> Fonksiyonun ald\u0131\u011f\u0131 parametredeki offset de\u011ferine g\u00f6re \u00f6nceki sat\u0131r verisini getiren fonksiyondur. Sql\u2019deki lag fonksiyonu ile ayn\u0131 i\u015flevdedir. A\u015fa\u011f\u0131daki \u00f6rnekte her ki\u015finin \u00f6nceki arama tarihinin yeni kolona yazd\u0131r\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6rebiliriz.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZGYud2l0aENvbHVtbigiw7ZuY2VraSIsIGZ1bmMubGFnKGNvbCgiY2FsbGRhdGUiKSkub3ZlcihteV93KSkuc2hvdygxNSxGYWxzZSkKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rCnxpZCB8bmFtZSB8Y2l0eSAgIHxhZ2V8Z2VuZGVyfGNhbGxkYXRlfGNhbGx0aW1lfMO2bmNla2kgIHwKKy0tLSstLS0tLSstLS0tLS0tKy0tLSstLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rCnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMTgwMjIwfDE4ICAgICAgfG51bGwgICAgfAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDE5MDEwMXw4OSAgICAgIHwyMDE4MDIyMHwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAxOTA2MDR8ODkgICAgICB8MjAxOTAxMDF8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAwNzE2fDI2ICAgICAgfDIwMTkwNjA0fAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIwMTAxMXwzNiAgICAgIHwyMDIwMDcxNnwKfDcgIHxTYW1ldHxvcmR1ICAgfDY0IHxFICAgICB8MjAyMDEwMTh8NDAgICAgICB8MjAyMDEwMTF8Cnw3ICB8U2FtZXR8b3JkdSAgIHw2NCB8RSAgICAgfDIwMjAxMDE4fDY1ICAgICAgfDIwMjAxMDE4fAp8NyAgfFNhbWV0fG9yZHUgICB8NjQgfEUgICAgIHwyMDIxMDYwOHwxMSAgICAgIHwyMDIwMTAxOHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAxNzA2MDR8MzUgICAgICB8bnVsbCAgICB8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAwNTE2fDg1ICAgICAgfDIwMTcwNjA0fAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMDgxNHwxNyAgICAgIHwyMDIwMDUxNnwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMDA5MTR8NDEgICAgICB8MjAyMDA4MTR8CnwxMSB8YWxpICB8YW50YWx5YXw1MyB8RSAgICAgfDIwMjAxMTE4fDM1ICAgICAgfDIwMjAwOTE0fAp8MTEgfGFsaSAgfGFudGFseWF8NTMgfEUgICAgIHwyMDIwMTExOHwyMiAgICAgIHwyMDIwMTExOHwKfDExIHxhbGkgIHxhbnRhbHlhfDUzIHxFICAgICB8MjAyMTExMTh8MzMgICAgICB8MjAyMDExMTh8CistLS0rLS0tLS0rLS0tLS0tLSstLS0rLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKw==[\/fusion_syntax_highlighter]<\/p>\n<p><strong>3. Toplama (Aggregate) Fonksiyonlar\u0131<\/strong><\/p>\n<p>Her window partition i\u00e7in sum, avg, max, min de\u011ferlerini hesaplayabiliriz. Bunun i\u00e7in a\u015fa\u011f\u0131daki \u00f6rne\u011fi inceleyelim.<\/p>\n<p>[fusion_syntax_highlighter theme=&#8221;&#8221; language=&#8221;x-sh&#8221; line_numbers=&#8221;&#8221; line_wrapping=&#8221;&#8221; copy_to_clipboard=&#8221;&#8221; copy_to_clipboard_text=&#8221;&#8221; hide_on_mobile=&#8221;small-visibility,medium-visibility,large-visibility&#8221; class=&#8221;&#8221; id=&#8221;&#8221; font_size=&#8221;&#8221; border_size=&#8221;&#8221; border_color=&#8221;&#8221; border_style=&#8221;&#8221; background_color=&#8221;&#8221; line_number_background_color=&#8221;&#8221; line_number_text_color=&#8221;&#8221; margin_top=&#8221;&#8221; margin_right=&#8221;&#8221; margin_bottom=&#8221;&#8221; margin_left=&#8221;&#8221;]ZnJvbSBweXNwYXJrLnNxbC5mdW5jdGlvbnMgaW1wb3J0IGNvbCxhdmcsc3VtLG1pbixtYXgscm93X251bWJlciAKZGYud2l0aENvbHVtbigicm93Iixyb3dfbnVtYmVyKCkub3ZlcihteV93KSkgXAogIC53aXRoQ29sdW1uKCJhdmciLCBhdmcoY29sKCJjYWxsdGltZSIpKS5vdmVyKG15X3cyKSkgXAogIC53aXRoQ29sdW1uKCJzdW0iLCBzdW0oY29sKCJjYWxsdGltZSIpKS5vdmVyKG15X3cyKSkgXAogIC53aXRoQ29sdW1uKCJtaW4iLCBtaW4oY29sKCJjYWxsdGltZSIpKS5vdmVyKG15X3cyKSkgXAogIC53aXRoQ29sdW1uKCJtYXgiLCBtYXgoY29sKCJjYWxsdGltZSIpKS5vdmVyKG15X3cyKSkgXAogIC53aGVyZShjb2woInJvdyIpPT0xKS5zZWxlY3QoImlkIiwibmFtZSIsImF2ZyIsInN1bSIsIm1pbiIsIm1heCIpLnNob3coMTUsRmFsc2UpCistLS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLSstLS0rLS0tKwp8aWQgfG5hbWUgIHxhdmcgICAgICAgICAgICAgICB8c3VtICB8bWlufG1heHwKKy0tLSstLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tKy0tLSstLS0rCnw3ICB8U2FtZXQgfDQ2Ljc1ICAgICAgICAgICAgIHwzNzQuMHwxMSB8ODkgfAp8MTEgfGFsaSAgIHwzOC4yODU3MTQyODU3MTQyODV8MjY4LjB8MTcgfDg1IHwKfDMgIHxCdXJhayB8MzEuMTQyODU3MTQyODU3MTQyfDIxOC4wfDEyIHw2NiB8Cnw4ICB8QnVya2F5fDQ3Ljg3NSAgICAgICAgICAgIHwzODMuMHwxNCB8NzUgfAp8NSAgfE1lcnZlIHwzMy42MzYzNjM2MzYzNjM2MyB8MzcwLjB8MTMgfDc3IHwKfDYgIHxCaWxhbCB8NDAuMDkwOTA5MDkwOTA5MDkgfDQ0MS4wfDEyIHw3MCB8Cnw5ICB8ZWxpZiAgfDI2LjUgICAgICAgICAgICAgIHwxMDYuMHwxMiB8NDAgfAp8MSAgfFRvbGdhIHwzNi43Nzc3Nzc3Nzc3Nzc3OCB8MzMxLjB8MTEgfDk4IHwKfDQgIHxUb2xnYSB8MjkuNSAgICAgICAgICAgICAgfDM1NC4wfDEwIHw1NSB8CnwxNCB8YnVzZSAgfDM4Ljc3Nzc3Nzc3Nzc3Nzc4IHwzNDkuMHwxMCB8OTkgfAp8MiAgfEVjZSAgIHw0MC44ICAgICAgICAgICAgICB8NjEyLjB8MTUgfDc3IHwKKy0tLSstLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tKy0tLSstLS0r[\/fusion_syntax_highlighter]<\/p>\n<p>id de\u011feri 7 olan kayd\u0131 ele al\u0131rsak ortalama konu\u015fma s\u00fcresinin 46.75 s, toplam konu\u015fma s\u00fcresinin 374 s, min konu\u015fma s\u00fcresinin 11 s ve max konu\u015fma s\u00fcresinin 89 s oldu\u011funu g\u00f6zlemleyebiliriz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar bug\u00fcnk\u00fc yaz\u0131mda size PySpark Window Functions\u2019\u0131n\u00a0 i\u015flevinden ve PySpark Sql ve PySpark DataFrame API ile kullan\u0131m\u0131ndan bahsedece\u011fim. Pyspark: Apache Spark, Scala [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":5925,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[87],"tags":[137,138],"class_list":["post-6123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-pyspark-tr","tag-window-funtions-tr"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PySpark Window Functions - Bentego<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PySpark Window Functions - Bentego\" \/>\n<meta property=\"og:description\" content=\"Merhabalar bug\u00fcnk\u00fc yaz\u0131mda size PySpark Window Functions\u2019\u0131n\u00a0 i\u015flevinden ve PySpark Sql ve PySpark DataFrame API ile kullan\u0131m\u0131ndan bahsedece\u011fim. Pyspark: Apache Spark, Scala [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Bentego\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-01T14:12:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-20T16:09:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bentego\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bentego\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/\"},\"author\":{\"name\":\"Bentego\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e\"},\"headline\":\"PySpark Window Functions\",\"datePublished\":\"2022-03-01T14:12:09+00:00\",\"dateModified\":\"2025-10-20T16:09:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/\"},\"wordCount\":3838,\"publisher\":{\"@id\":\"https:\/\/bentego.com\/tr\/#organization\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png\",\"keywords\":[\"pyspark\",\"window funtions\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"tr\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/\",\"url\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/\",\"name\":\"PySpark Window Functions - Bentego\",\"isPartOf\":{\"@id\":\"https:\/\/bentego.com\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png\",\"datePublished\":\"2022-03-01T14:12:09+00:00\",\"dateModified\":\"2025-10-20T16:09:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage\",\"url\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png\",\"contentUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png\",\"width\":2400,\"height\":1600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bentego.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PySpark Window Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bentego.com\/tr\/#website\",\"url\":\"https:\/\/bentego.com\/tr\/\",\"name\":\"Bentego\",\"description\":\"Turning data into enterprise value\",\"publisher\":{\"@id\":\"https:\/\/bentego.com\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bentego.com\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/bentego.com\/tr\/#organization\",\"name\":\"Bentego\",\"url\":\"https:\/\/bentego.com\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg\",\"contentUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg\",\"width\":433,\"height\":109,\"caption\":\"Bentego\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e\",\"name\":\"Bentego\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PySpark Window Functions - Bentego","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/","og_locale":"tr_TR","og_type":"article","og_title":"PySpark Window Functions - Bentego","og_description":"Merhabalar bug\u00fcnk\u00fc yaz\u0131mda size PySpark Window Functions\u2019\u0131n\u00a0 i\u015flevinden ve PySpark Sql ve PySpark DataFrame API ile kullan\u0131m\u0131ndan bahsedece\u011fim. Pyspark: Apache Spark, Scala [&hellip;]","og_url":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/","og_site_name":"Bentego","article_published_time":"2022-03-01T14:12:09+00:00","article_modified_time":"2025-10-20T16:09:26+00:00","og_image":[{"width":2400,"height":1600,"url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png","type":"image\/png"}],"author":"Bentego","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Bentego","Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#article","isPartOf":{"@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/"},"author":{"name":"Bentego","@id":"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e"},"headline":"PySpark Window Functions","datePublished":"2022-03-01T14:12:09+00:00","dateModified":"2025-10-20T16:09:26+00:00","mainEntityOfPage":{"@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/"},"wordCount":3838,"publisher":{"@id":"https:\/\/bentego.com\/tr\/#organization"},"image":{"@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png","keywords":["pyspark","window funtions"],"articleSection":["Blog"],"inLanguage":"tr"},{"@type":"WebPage","@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/","url":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/","name":"PySpark Window Functions - Bentego","isPartOf":{"@id":"https:\/\/bentego.com\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage"},"image":{"@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png","datePublished":"2022-03-01T14:12:09+00:00","dateModified":"2025-10-20T16:09:26+00:00","breadcrumb":{"@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bentego.com\/tr\/pyspark-window-functions\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#primaryimage","url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png","contentUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-85__.png","width":2400,"height":1600},{"@type":"BreadcrumbList","@id":"https:\/\/bentego.com\/tr\/pyspark-window-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bentego.com\/tr\/"},{"@type":"ListItem","position":2,"name":"PySpark Window Functions"}]},{"@type":"WebSite","@id":"https:\/\/bentego.com\/tr\/#website","url":"https:\/\/bentego.com\/tr\/","name":"Bentego","description":"Turning data into enterprise value","publisher":{"@id":"https:\/\/bentego.com\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bentego.com\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/bentego.com\/tr\/#organization","name":"Bentego","url":"https:\/\/bentego.com\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg","contentUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg","width":433,"height":109,"caption":"Bentego"},"image":{"@id":"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e","name":"Bentego"}]}},"_links":{"self":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/comments?post=6123"}],"version-history":[{"count":1,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6123\/revisions"}],"predecessor-version":[{"id":6247,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6123\/revisions\/6247"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/media\/5925"}],"wp:attachment":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/media?parent=6123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/categories?post=6123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/tags?post=6123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}