{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"SQL: Csv Dosyalar\u0131nda GROUP BY \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"kAHr2afnNo\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sql-csv-dosyalarinda-group-by-islemi-nasil-yapilir\/\">SQL: Csv Dosyalar\u0131nda GROUP BY \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sql-csv-dosyalarinda-group-by-islemi-nasil-yapilir\/embed\/#?secret=kAHr2afnNo\" width=\"600\" height=\"338\" title=\"&#8220;SQL: Csv Dosyalar\u0131nda GROUP BY \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"kAHr2afnNo\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"CSV dosyalar\u0131ndaki ham verileri anlaml\u0131 \u00f6zetlere d\u00f6n\u00fc\u015ft\u00fcrmek, i\u015f zekas\u0131 ve veri analizi s\u00fcre\u00e7lerinin vazge\u00e7ilmez bir par\u00e7as\u0131d\u0131r. Bu makale, yayg\u0131n olarak kullan\u0131lan CSV format\u0131ndaki verilere SQL'deki GROUP BY mant\u0131\u011f\u0131n\u0131 nas\u0131l uygulayaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131klayacak, b\u00f6ylece veri y\u0131\u011f\u0131nlar\u0131ndan de\u011ferli i\u00e7g\u00f6r\u00fcler elde etmenize yard\u0131mc\u0131 olacakt\u0131r. \u00d6zellikle Python ve Pandas k\u00fct\u00fcphanesi \u00fczerinden pratik \u00e7\u00f6z\u00fcmler sunaca\u011f\u0131z."}