{"id":2286,"date":"2026-06-15T11:49:42","date_gmt":"2026-06-15T11:49:42","guid":{"rendered":"https:\/\/berenkudaygorun.com\/blog\/?p=2286"},"modified":"2026-06-15T11:49:42","modified_gmt":"2026-06-15T11:49:42","slug":"pandas-derin-ogrenme-gun-3","status":"publish","type":"post","link":"https:\/\/berenkudaygorun.com\/blog\/blog\/2026\/06\/15\/pandas-derin-ogrenme-gun-3\/","title":{"rendered":"Pandas \u2013 Derin \u00d6\u011frenme G\u00fcn 3"},"content":{"rendered":"

E\u011fitim Pandas k\u00fct\u00fcphanesi analtmakla devam ediyor. Bug\u00fcn e\u011fitim i\u00e7erisinde verileri okuduktan sonra dataframe i\u00e7erisinde uygun formata nas\u0131l getirebilece\u011fimizi g\u00f6rd\u00fck. \u00d6rnek olmas\u0131 a\u00e7\u0131s\u0131ndan mesela a\u015fa\u011f\u0131daki gibi bir veri olabilir.<\/p>\n

\u015eehir,Tarih,S\u0131cakl\u0131k(\u00b0C)\n\u0130stanbul,2024-06-15,24.8\nAnkara,2024-06-15,\n\u0130zmir,2024-06-15,29.6\nAntalya,2024-06-15,18.2\nBursa,2024-06-15,23.8\nGaziantep,2024-06-15,32.6\n\u0130stanbul,2024-06-16,\nAnkara,2024-06-16,28.0\n\u0130zmir,2024-06-16,\nAntalya,2024-06-16,32.2\nBursa,2024-06-16,33.8\nGaziantep,2024-06-16,16.5\n\u0130stanbul,2024-06-17,23.2\nAnkara,2024-06-17,20.1\n\u0130zmir,2024-06-17,25.4\nAntalya,2024-06-17,32.9\nBursa,2024-06-17,30.7\nGaziantep,2024-06-17,30.6\n\u0130stanbul,2024-06-18,20.5\nAnkara,2024-06-18,22.5\n\u0130zmir,2024-06-18,33.8\nAntalya,2024-06-18,23.3\nBursa,2024-06-18,\nGaziantep,2024-06-18,24.7\n\u0130stanbul,2024-06-19,23.6\nAnkara,2024-06-19,19.5\n\u0130zmir,2024-06-19,30.0\nAntalya,2024-06-19,18.8\nBursa,2024-06-19,\nGaziantep,2024-06-19,32.9\n\u0130stanbul,2024-06-20,24.0\nAnkara,2024-06-20,34.3\n\u0130zmir,2024-06-20,31.6\nAntalya,2024-06-20,19.6\nBursa,2024-06-20,27.0\nGaziantep,2024-06-20,25.8\n\u0130stanbul,2024-06-21,15.4\nAnkara,2024-06-21,24.4\n\u0130zmir,2024-06-21,30.9\nAntalya,2024-06-21,21.8\nBursa,2024-06-21,30.8\nGaziantep,2024-06-21,27.5\n\u0130stanbul,2024-06-22,30.7\nAnkara,2024-06-22,28.4\n\u0130zmir,2024-06-22,\nAntalya,2024-06-22,25.1\nBursa,2024-06-22,\nGaziantep,2024-06-22,31.2\n\u0130stanbul,2024-06-23,\nAnkara,2024-06-23,25.5\n\u0130zmir,2024-06-23,18.5\nAntalya,2024-06-23,22.1\nBursa,2024-06-23,31.6\nGaziantep,2024-06-23,25.6\n\u0130stanbul,2024-06-24,29.1\nAnkara,2024-06-24,29.9\n\u0130zmir,2024-06-24,24.1\nAntalya,2024-06-24,20.4\nBursa,2024-06-24,\nGaziantep,2024-06-24,31.9<\/code><\/pre>\n
Burada g\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere asl\u0131nda \u015fehir isimleri tekrar ediyor ve bunu dataframe ile sanki bir pivot tablo gibi g\u00f6stermek isteyebiliriz. index k\u0131sm\u0131nda tarihler, column k\u0131sm\u0131nda \u015eehirler ve data k\u0131sm\u0131nda ise s\u0131cakl\u0131klar olmal\u0131d\u0131r. Bunun i\u00e7in yap\u0131lmas\u0131 gereken d\u00f6n\u00fc\u015f\u00fcm bu \u015fekildedeir.<\/p>\n
import numpy as np\nimport pandas as pd\n\ndata = pd.read_csv('hava_durumu.csv')\nprint("Orijinal veri:")\nprint(data.head())\n\n#Seri'den 2 boyutlu DataFrame'e d\u00f6n\u00fc\u015ft\u00fcrme\ncount_Tarih = len(data["Tarih"].unique())\ncount_Sehir = len(data["\u015eehir"].unique())\nsicakliklar = data["S\u0131cakl\u0131k(\u00b0C)"].values.reshape(count_Tarih, count_Sehir)\n\ndf = pd.DataFrame(columns=data["\u015eehir"].unique(), index=data["Tarih"].unique(), data=sicakliklar)\nprint(df)<\/code><\/pre>\n
Orijinal veri:\n      \u015eehir       Tarih  S\u0131cakl\u0131k(\u00b0C)\n0  \u0130stanbul  2024-06-15          24.8\n1    Ankara  2024-06-15           NaN\n2     \u0130zmir  2024-06-15          29.6\n3   Antalya  2024-06-15          18.2\n4     Bursa  2024-06-15          23.8\n            \u0130stanbul  Ankara  \u0130zmir  Antalya  Bursa  Gaziantep\n2024-06-15      24.8     NaN   29.6     18.2   23.8       32.6\n2024-06-16       NaN    28.0    NaN     32.2   33.8       16.5\n2024-06-17      23.2    20.1   25.4     32.9   30.7       30.6\n2024-06-18      20.5    22.5   33.8     23.3    NaN       24.7\n2024-06-19      23.6    19.5   30.0     18.8    NaN       32.9\n2024-06-20      24.0    34.3   31.6     19.6   27.0       25.8\n2024-06-21      15.4    24.4   30.9     21.8   30.8       27.5\n2024-06-22      30.7    28.4    NaN     25.1    NaN       31.2\n2024-06-23       NaN    25.5   18.5     22.1   31.6       25.6\n2024-06-24      29.1    29.9   24.1     20.4    NaN       31.9<\/code><\/pre>\n
G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere burada asl\u0131nda baz\u0131 NaN de\u011ferler var. Bu de\u011ferleri istedi\u011fimiz gibi de\u011fi\u015ftirebiliriz. \u00d6rne\u011fin:<\/p>\n
print("NaN de\u011ferlerini kontrol etme:")\nprint(df.isnull().sum())\n\nprint("NaN de\u011ferlerini ortalama ile doldurma:")\nnew_df = df.fillna(df.mean())\nprint(new_df)<\/code><\/pre>\n
NaN de\u011ferlerini kontrol etme:\n\u0130stanbul     2\nAnkara       1\n\u0130zmir        2\nAntalya      0\nBursa        4\nGaziantep    0\ndtype: int64\nNaN de\u011ferlerini ortalama ile doldurma:\n            \u0130stanbul     Ankara    \u0130zmir  Antalya      Bursa  Gaziantep\n2024-06-15   24.8000  25.844444  29.6000     18.2  23.800000       32.6\n2024-06-16   23.9125  28.000000  27.9875     32.2  33.800000       16.5\n2024-06-17   23.2000  20.100000  25.4000     32.9  30.700000       30.6\n2024-06-18   20.5000  22.500000  33.8000     23.3  29.616667       24.7\n2024-06-19   23.6000  19.500000  30.0000     18.8  29.616667       32.9\n2024-06-20   24.0000  34.300000  31.6000     19.6  27.000000       25.8\n2024-06-21   15.4000  24.400000  30.9000     21.8  30.800000       27.5\n2024-06-22   30.7000  28.400000  27.9875     25.1  29.616667       31.2\n2024-06-23   23.9125  25.500000  18.5000     22.1  31.600000       25.6\n2024-06-24   29.1000  29.900000  24.1000     20.4  29.616667       31.9<\/code><\/pre>\n
Ya da bunlar\u0131 silmek isteyebilirsiniz.<\/p>\n
print("NaN de\u011ferlerini silme:")\nnew_df2 = df.dropna()\nprint(new_df2)<\/code><\/pre>\n
NaN de\u011ferlerini silme:\n            \u0130stanbul  Ankara  \u0130zmir  Antalya  Bursa  Gaziantep\n2024-06-17      23.2    20.1   25.4     32.9   30.7       30.6\n2024-06-20      24.0    34.3   31.6     19.6   27.0       25.8\n2024-06-21      15.4    24.4   30.9     21.8   30.8       27.5<\/code><\/pre>\n
NaN de\u011ferlerle \u00f6rnekler yap\u0131ld\u0131ktan sonra k\u0131saca gruplama olay\u0131ndan bahsedildi.
\n\u00d6rnek verim \u015fu \u015fekilde:<\/p>\n
Tarih,\u015eehir,\u00dcr\u00fcn,Sat\u0131\u015f_Tutar\u0131,Miktar\n2024-06-01,\u0130zmir,Tablet,3406.3,1\n2024-06-01,Antalya,Kulakl\u0131k,3414.95,3\n2024-06-01,Bursa,Tablet,1655.22,8\n2024-06-01,Bursa,Telefon,4315.35,4\n2024-06-01,Ankara,Telefon,3235.14,9\n2024-06-01,Bursa,Tablet,1185.02,8\n2024-06-01,Ankara,Bilgisayar,3561.93,6\n2024-06-02,Ankara,Telefon,1552.01,3\n2024-06-02,Bursa,Telefon,3806.52,7\n2024-06-02,Ankara,Bilgisayar,1115.12,3\n2024-06-02,Ankara,Telefon,2284.68,10\n2024-06-02,Ankara,Kulakl\u0131k,3520.6,7\n2024-06-02,\u0130zmir,Tablet,735.54,4\n2024-06-02,Bursa,Telefon,1087.88,10\n2024-06-02,Bursa,Telefon,3560.81,2\n2024-06-02,\u0130stanbul,Kulakl\u0131k,2574.94,3\n2024-06-02,Bursa,Bilgisayar,2395.74,7\n2024-06-02,Bursa,Tablet,4122.33,7\n2024-06-02,Antalya,Telefon,2482.54,1\n2024-06-02,\u0130stanbul,Tablet,4538.81,10\n2024-06-02,\u0130stanbul,Kulakl\u0131k,1291.65,9\n2024-06-02,Ankara,Tablet,1261.41,3\n2024-06-03,Bursa,Tablet,1839.05,2\n2024-06-03,\u0130zmir,Telefon,4999.28,2\n2024-06-03,Antalya,Tablet,3094.95,9\n2024-06-03,Ankara,Kulakl\u0131k,1107.28,3\n2024-06-03,Bursa,Bilgisayar,3733.21,5\n2024-06-03,\u0130stanbul,Bilgisayar,2896.66,2\n2024-06-04,\u0130zmir,Bilgisayar,2491.89,6\n2024-06-04,Bursa,Tablet,3655.01,1\n2024-06-04,Ankara,Telefon,3189.93,9\n2024-06-04,\u0130stanbul,Kulakl\u0131k,845.06,10\n2024-06-04,Ankara,Tablet,3372.91,10\n2024-06-04,Ankara,Bilgisayar,1106.56,6\n2024-06-04,Bursa,Telefon,546.84,4\n2024-06-04,Ankara,Tablet,2254.29,3\n2024-06-04,\u0130zmir,Tablet,3882.22,2\n2024-06-04,Ankara,Tablet,3567.46,5\n2024-06-04,Antalya,Bilgisayar,2113.7,7\n2024-06-04,\u0130stanbul,Bilgisayar,2327.68,9\n2024-06-04,Bursa,Kulakl\u0131k,1970.68,1\n2024-06-05,Ankara,Kulakl\u0131k,195.08,3\n2024-06-05,\u0130stanbul,Tablet,2577.36,5\n2024-06-05,Ankara,Bilgisayar,4285.9,5\n2024-06-05,Bursa,Telefon,415.1,2\n2024-06-05,Bursa,Tablet,2247.83,6\n2024-06-05,Antalya,Kulakl\u0131k,4062.43,4\n2024-06-05,\u0130stanbul,Tablet,3964.58,10\n2024-06-05,\u0130stanbul,Bilgisayar,520.57,6\n2024-06-06,\u0130stanbul,Telefon,3052.53,1\n2024-06-06,Antalya,Bilgisayar,2192.65,4\n2024-06-06,\u0130zmir,Bilgisayar,191.72,1\n2024-06-06,\u0130stanbul,Telefon,2568.92,1\n2024-06-06,\u0130stanbul,Bilgisayar,163.3,9\n2024-06-06,Ankara,Bilgisayar,1832.34,6\n2024-06-06,Antalya,Tablet,1881.42,9\n2024-06-06,\u0130zmir,Bilgisayar,957.64,8\n2024-06-06,Bursa,Tablet,3911.05,3\n2024-06-07,Ankara,Telefon,3644.6,9\n2024-06-07,Bursa,Tablet,1745.6,1\n2024-06-07,\u0130stanbul,Telefon,1414.13,4\n2024-06-07,\u0130stanbul,Telefon,3201.04,5\n2024-06-07,\u0130stanbul,Bilgisayar,4395.53,5\n2024-06-08,Bursa,Kulakl\u0131k,1901.66,8\n2024-06-08,Ankara,Telefon,2588.16,3\n2024-06-08,\u0130zmir,Tablet,4451.54,10\n2024-06-08,\u0130zmir,Tablet,2915.2,6\n2024-06-08,Bursa,Tablet,1906.42,9\n2024-06-08,Antalya,Tablet,251.81,2\n2024-06-08,\u0130stanbul,Bilgisayar,3333.39,1\n2024-06-08,\u0130stanbul,Telefon,1643.84,1\n2024-06-08,Ankara,Bilgisayar,4985.31,5\n2024-06-08,Bursa,Kulakl\u0131k,2816.86,10\n2024-06-08,Ankara,Bilgisayar,905.52,4\n2024-06-09,\u0130stanbul,Kulakl\u0131k,1353.1,5\n2024-06-09,Bursa,Bilgisayar,483.06,6\n2024-06-09,\u0130zmir,Tablet,4562.56,8\n2024-06-09,Antalya,Tablet,4436.79,5\n2024-06-09,\u0130zmir,Bilgisayar,2914.2,7\n2024-06-09,\u0130stanbul,Telefon,1071.32,10\n2024-06-09,\u0130stanbul,Telefon,4915.33,4\n2024-06-09,\u0130stanbul,Tablet,2497.44,3\n2024-06-09,\u0130zmir,Tablet,131.26,3\n2024-06-10,Ankara,Telefon,2224.51,5\n2024-06-10,Ankara,Bilgisayar,1766.85,8\n2024-06-10,Antalya,Bilgisayar,4713.13,8\n2024-06-10,\u0130zmir,Kulakl\u0131k,2399.26,1\n2024-06-10,\u0130zmir,Bilgisayar,2502.48,10\n2024-06-10,\u0130zmir,Kulakl\u0131k,3620.7,3\n2024-06-10,\u0130zmir,Bilgisayar,3479.66,9\n2024-06-11,Antalya,Telefon,4902.42,5\n2024-06-11,Antalya,Bilgisayar,3131.02,6\n2024-06-11,\u0130zmir,Tablet,1596.8,1\n2024-06-11,Antalya,Telefon,3953.44,9\n2024-06-11,\u0130stanbul,Telefon,1463.11,6\n2024-06-11,Antalya,Tablet,3217.97,1\n2024-06-12,\u0130zmir,Tablet,4001.7,7\n2024-06-12,Ankara,Kulakl\u0131k,3797.07,10\n2024-06-12,Ankara,Telefon,2257.88,2\n2024-06-12,\u0130stanbul,Telefon,759.1,5\n2024-06-12,Ankara,Kulakl\u0131k,2800.13,8\n2024-06-12,Antalya,Bilgisayar,2702.72,4\n2024-06-12,Ankara,Bilgisayar,3384.2,10\n2024-06-12,Antalya,Bilgisayar,880.89,9\n2024-06-12,Bursa,Kulakl\u0131k,3688.77,8\n2024-06-12,Ankara,Bilgisayar,2505.55,8\n2024-06-12,Ankara,Bilgisayar,2219.21,2\n2024-06-13,\u0130zmir,Tablet,3389.8,10\n2024-06-13,\u0130stanbul,Bilgisayar,2879.7,9\n2024-06-13,\u0130stanbul,Tablet,929.35,2\n2024-06-13,Bursa,Tablet,4679.36,3\n2024-06-13,Bursa,Telefon,916.22,8\n2024-06-13,Bursa,Telefon,2281.49,2\n2024-06-13,Bursa,Tablet,2649.03,2\n2024-06-13,Bursa,Kulakl\u0131k,1441.89,8\n2024-06-13,Bursa,Kulakl\u0131k,2713.81,1\n2024-06-14,\u0130stanbul,Bilgisayar,4849.57,5\n2024-06-14,\u0130stanbul,Telefon,3961.64,2\n2024-06-14,Ankara,Kulakl\u0131k,3958.42,4\n2024-06-14,Ankara,Tablet,3900.24,3\n2024-06-14,Ankara,Bilgisayar,3014.58,8\n2024-06-14,Antalya,Bilgisayar,710.5,4\n2024-06-14,\u0130stanbul,Bilgisayar,939.89,1\n2024-06-14,Antalya,Kulakl\u0131k,1211.54,8\n2024-06-14,\u0130stanbul,Telefon,4151.35,3\n2024-06-14,Bursa,Kulakl\u0131k,1807.25,5\n2024-06-14,Antalya,Tablet,2716.48,1\n2024-06-14,Bursa,Telefon,2568.85,6\n2024-06-15,Antalya,Kulakl\u0131k,3608.38,5\n2024-06-15,\u0130zmir,Tablet,1518.73,6\n2024-06-15,\u0130zmir,Kulakl\u0131k,4162.09,9\n2024-06-15,\u0130zmir,Kulakl\u0131k,555.87,10\n2024-06-15,Antalya,Kulakl\u0131k,224.44,6\n2024-06-16,\u0130stanbul,Tablet,3923.06,8\n2024-06-16,Antalya,Telefon,1168.45,7\n2024-06-16,Bursa,Telefon,2392.07,8\n2024-06-16,Ankara,Telefon,4218.39,1\n2024-06-16,\u0130stanbul,Telefon,2244.88,9\n2024-06-16,Bursa,Kulakl\u0131k,619.19,2\n2024-06-16,\u0130stanbul,Tablet,1821.17,9\n2024-06-16,\u0130zmir,Tablet,2718.89,10\n2024-06-16,Antalya,Kulakl\u0131k,3692.01,1\n2024-06-16,\u0130stanbul,Telefon,1119.86,9\n2024-06-16,Ankara,Tablet,1767.51,7\n2024-06-16,Antalya,Tablet,1874.11,6\n2024-06-16,\u0130stanbul,Bilgisayar,1386.31,2\n2024-06-16,Bursa,Bilgisayar,2992.47,9\n2024-06-17,Antalya,Kulakl\u0131k,1882.49,10\n2024-06-17,Ankara,Kulakl\u0131k,1153.86,3\n2024-06-17,Antalya,Telefon,3130.05,7\n2024-06-17,Antalya,Telefon,3962.67,3\n2024-06-17,Ankara,Bilgisayar,4223.04,7\n2024-06-17,Ankara,Kulakl\u0131k,146.05,6\n2024-06-17,Bursa,Telefon,1519.53,7\n2024-06-18,Bursa,Tablet,3521.98,6\n2024-06-18,\u0130zmir,Kulakl\u0131k,3180.75,8\n2024-06-18,Bursa,Telefon,3895.33,4\n2024-06-18,Bursa,Kulakl\u0131k,1253.38,3\n2024-06-18,Ankara,Kulakl\u0131k,4720.16,6\n2024-06-18,Antalya,Kulakl\u0131k,4393.34,8\n2024-06-18,\u0130stanbul,Kulakl\u0131k,2563.72,4\n2024-06-18,Ankara,Kulakl\u0131k,4732.44,10\n2024-06-19,Ankara,Bilgisayar,968.13,5\n2024-06-19,Bursa,Bilgisayar,223.95,3\n2024-06-19,Ankara,Kulakl\u0131k,2274.05,10\n2024-06-19,Bursa,Kulakl\u0131k,3334.65,9\n2024-06-19,\u0130zmir,Telefon,3716.59,3\n2024-06-19,\u0130zmir,Tablet,1095.62,4\n2024-06-19,\u0130stanbul,Bilgisayar,4814.91,7\n2024-06-19,\u0130stanbul,Telefon,1681.52,4\n2024-06-19,Bursa,Tablet,4791.78,4\n2024-06-19,\u0130zmir,Tablet,2206.85,5\n2024-06-19,\u0130zmir,Bilgisayar,200.92,3\n2024-06-19,Antalya,Telefon,1949.04,8\n2024-06-19,\u0130zmir,Kulakl\u0131k,2885.89,2\n2024-06-19,Ankara,Telefon,4777.43,4\n2024-06-20,Ankara,Tablet,3150.58,2\n2024-06-20,Antalya,Tablet,4002.05,7\n2024-06-20,\u0130stanbul,Kulakl\u0131k,1793.46,8\n2024-06-20,\u0130zmir,Kulakl\u0131k,1380.03,7\n2024-06-20,Antalya,Tablet,422.43,3\n2024-06-20,Bursa,Telefon,3992.26,8\n2024-06-20,\u0130zmir,Kulakl\u0131k,4736.18,1\n2024-06-20,Antalya,Tablet,3066.74,7\n2024-06-20,Bursa,Telefon,1991.96,1\n2024-06-20,Antalya,Kulakl\u0131k,1961.05,7\n2024-06-20,Antalya,Telefon,4334.29,8\n2024-06-20,\u0130zmir,Telefon,1060.98,5\n2024-06-20,\u0130zmir,Bilgisayar,3540.93,7\n2024-06-20,\u0130stanbul,Bilgisayar,2141.87,8\n2024-06-20,\u0130zmir,Bilgisayar,1781.29,9\n2024-06-21,\u0130zmir,Kulakl\u0131k,2204.92,5\n2024-06-21,Bursa,Bilgisayar,4542.21,4\n2024-06-21,\u0130zmir,Bilgisayar,4076.58,9\n2024-06-21,Ankara,Telefon,4449.23,2\n2024-06-21,\u0130stanbul,Kulakl\u0131k,4559.3,7\n2024-06-21,\u0130zmir,Telefon,1546.09,6\n2024-06-21,Bursa,Bilgisayar,1292.83,8\n2024-06-21,Bursa,Kulakl\u0131k,1735.5,4\n2024-06-22,Bursa,Telefon,1128.38,6\n2024-06-22,Antalya,Bilgisayar,3284.66,5\n2024-06-22,Antalya,Tablet,4949.63,5\n2024-06-22,Antalya,Tablet,3675.8,6\n2024-06-22,Antalya,Bilgisayar,2912.36,10\n2024-06-22,Antalya,Kulakl\u0131k,4753.04,2\n2024-06-22,Ankara,Tablet,4234.42,6\n2024-06-23,\u0130stanbul,Kulakl\u0131k,893.6,8\n2024-06-23,\u0130zmir,Bilgisayar,4191.03,6\n2024-06-23,\u0130zmir,Telefon,2531.75,7\n2024-06-23,Ankara,Tablet,2776.7,10\n2024-06-23,\u0130zmir,Bilgisayar,2452.66,8\n2024-06-23,\u0130stanbul,Telefon,1706.07,2\n2024-06-23,Antalya,Bilgisayar,3697.75,8\n2024-06-23,Bursa,Bilgisayar,1823.55,9\n2024-06-23,Ankara,Telefon,3546.45,9\n2024-06-23,Ankara,Tablet,641.51,5\n2024-06-23,\u0130zmir,Kulakl\u0131k,4960.17,5\n2024-06-23,Antalya,Bilgisayar,1950.2,3\n2024-06-23,Antalya,Tablet,1617.26,10\n2024-06-23,\u0130stanbul,Telefon,1455.81,9\n2024-06-23,\u0130stanbul,Kulakl\u0131k,2008.25,6\n2024-06-24,Ankara,Bilgisayar,501.42,7\n2024-06-24,Bursa,Kulakl\u0131k,1119.64,8\n2024-06-24,Ankara,Tablet,2636.88,7\n2024-06-24,Bursa,Kulakl\u0131k,2148.63,5\n2024-06-24,Antalya,Kulakl\u0131k,3787.49,10\n2024-06-24,Ankara,Bilgisayar,2965.25,4\n2024-06-24,Bursa,Bilgisayar,2012.18,9\n2024-06-25,\u0130stanbul,Bilgisayar,4380.48,2\n2024-06-25,Ankara,Bilgisayar,2439.35,9\n2024-06-25,Antalya,Bilgisayar,1354.23,2\n2024-06-25,Antalya,Kulakl\u0131k,578.2,1\n2024-06-25,Ankara,Bilgisayar,2065.83,3\n2024-06-25,\u0130stanbul,Telefon,3897.47,10\n2024-06-25,\u0130zmir,Telefon,1699.08,10\n2024-06-25,Ankara,Telefon,4504.33,10\n2024-06-25,Antalya,Tablet,2364.54,6\n2024-06-25,Antalya,Kulakl\u0131k,1519.17,10\n2024-06-26,Bursa,Bilgisayar,2546.17,6\n2024-06-26,Ankara,Bilgisayar,2459.79,6\n2024-06-26,Bursa,Tablet,3018.7,2\n2024-06-26,\u0130stanbul,Bilgisayar,4499.91,6\n2024-06-26,\u0130stanbul,Tablet,2741.02,8\n2024-06-26,Ankara,Tablet,2768.09,5\n2024-06-26,\u0130stanbul,Kulakl\u0131k,4135.9,2\n2024-06-26,Bursa,Telefon,1092.2,2\n2024-06-26,Bursa,Bilgisayar,354.83,5\n2024-06-26,Antalya,Tablet,3769.98,6\n2024-06-26,\u0130zmir,Kulakl\u0131k,2542.13,2\n2024-06-26,Antalya,Bilgisayar,2220.64,2\n2024-06-26,\u0130stanbul,Kulakl\u0131k,4135.73,5\n2024-06-26,Bursa,Telefon,2810.84,3\n2024-06-27,Antalya,Telefon,3964.7,2\n2024-06-27,Ankara,Tablet,1227.67,7\n2024-06-27,\u0130stanbul,Telefon,2939.8,6\n2024-06-27,\u0130zmir,Kulakl\u0131k,1136.06,5\n2024-06-27,\u0130zmir,Telefon,461.85,5\n2024-06-27,Bursa,Tablet,274.32,8\n2024-06-27,\u0130zmir,Tablet,4787.67,7\n2024-06-27,Ankara,Kulakl\u0131k,2127.93,10\n2024-06-27,\u0130zmir,Bilgisayar,2752.55,3\n2024-06-27,Ankara,Kulakl\u0131k,654.58,4\n2024-06-28,\u0130zmir,Kulakl\u0131k,3660.98,10\n2024-06-28,Antalya,Tablet,1050.06,10\n2024-06-28,\u0130stanbul,Bilgisayar,2588.17,10\n2024-06-28,Ankara,Telefon,3407.36,1\n2024-06-28,Antalya,Bilgisayar,4056.8,10\n2024-06-28,Antalya,Tablet,990.74,8\n2024-06-28,Ankara,Telefon,4785.75,10\n2024-06-28,Bursa,Tablet,807.71,8\n2024-06-28,Antalya,Telefon,1898.47,7\n2024-06-29,Ankara,Bilgisayar,4078.26,5\n2024-06-29,\u0130stanbul,Kulakl\u0131k,2136.91,2\n2024-06-29,Ankara,Telefon,699.43,8\n2024-06-29,Ankara,Tablet,3292.95,1\n2024-06-29,Antalya,Telefon,4842.75,2\n2024-06-29,\u0130zmir,Bilgisayar,2142.18,10\n2024-06-29,Bursa,Tablet,2313.65,1\n2024-06-29,Antalya,Tablet,3297.28,2\n2024-06-29,\u0130zmir,Kulakl\u0131k,788.32,4\n2024-06-29,Antalya,Kulakl\u0131k,236.51,1\n2024-06-29,Antalya,Tablet,859.45,8\n2024-06-29,Antalya,Telefon,2330.06,1\n2024-06-29,Antalya,Telefon,3244.8,10\n2024-06-30,Bursa,Telefon,2318.83,4\n2024-06-30,Antalya,Bilgisayar,4561.34,7\n2024-06-30,Antalya,Kulakl\u0131k,681.43,3\n2024-06-30,Bursa,Telefon,2260.76,8\n2024-06-30,Antalya,Kulakl\u0131k,3555.09,4\n2024-06-30,Ankara,Bilgisayar,1834.74,9\n2024-06-30,Bursa,Tablet,743.93,9\n2024-06-30,Bursa,Telefon,3145.38,10\n2024-06-30,\u0130zmir,Kulakl\u0131k,2788.25,7\n2024-06-30,Antalya,Tablet,3152.89,1<\/code><\/pre>\n
Bu verilerle basit bir gruplama \u00f6rne\u011fi ve \u00e7\u0131kt\u0131s\u0131:<\/p>\n
print("Gruplama \u00f6rne\u011fi:")\ndata = pd.read_csv('sat\u0131\u015f_verisi.csv')\nprint(data.head())\n\nprint("\u015eehre g\u00f6re ortalama sat\u0131\u015f tutar\u0131:")\nprint(data.groupby('\u015eehir')['Sat\u0131\u015f_Tutar\u0131'].mean())\n<\/code><\/pre>\n
Gruplama \u00f6rne\u011fi:\n        Tarih    \u015eehir      \u00dcr\u00fcn  Sat\u0131\u015f_Tutar\u0131  Miktar\n0  2024-06-01    \u0130zmir    Tablet       3406.30       1\n1  2024-06-01  Antalya  Kulakl\u0131k       3414.95       3\n2  2024-06-01    Bursa    Tablet       1655.22       8\n3  2024-06-01    Bursa   Telefon       4315.35       4\n4  2024-06-01   Ankara   Telefon       3235.14       9\n\u015eehre g\u00f6re ortalama sat\u0131\u015f tutar\u0131:\n\u015eehir\nAnkara      2681.631719\nAntalya     2701.565781\nBursa       2259.140323\n\u0130stanbul    2578.303208\n\u0130zmir       2590.071176\nName: Sat\u0131\u015f_Tutar\u0131, dtype: float64<\/code><\/pre>\n
E\u011fitimde son olarakda join i\u015flemleri anlat\u0131ld\u0131. Burada iki farkl\u0131 kaynak ile \u00e7al\u0131\u015f\u0131ld\u0131\u011f\u0131ndaki durum sim\u00fcle ediliyor. Kaynaklar a\u015fa\u011f\u0131daki gibidir.<\/p>\n
M\u00fc\u015fteriID,Ad,\u015eehir,Email\n1,Ahmet,\u0130stanbul,ahmet@mail.com\n2,Bet\u00fcl,Ankara,betul@mail.com\n3,Cem,\u0130zmir,cem@mail.com\n4,Deniz,Antalya,deniz@mail.com\n5,Eda,Bursa,eda@mail.com\n6,Fatih,Gaziantep,fatih@mail.com<\/code><\/pre>\n
Siparii\u015fID,M\u00fc\u015fteriID,\u00dcr\u00fcn,Tutar\n101,1,Laptop,5000\n102,2,Telefon,3000\n103,2,Tablet,2000\n104,3,Kulakl\u0131k,500\n105,5,Bilgisayar,4000\n106,7,Monit\u00f6r,1500\n107,8,Yaz\u0131c\u0131,800\n108,4,Fare,200<\/code><\/pre>\n
\u0130lk \u00f6rneket inner join g\u00f6steriliyor.<\/p>\n
#join i\u015flemi\nprint("Join i\u015flemi \u00f6rne\u011fi:")\ndata = pd.read_csv('m\u00fc\u015fteriler.csv')\ndata2 = pd.read_csv('sipari\u015fler.csv')\nprint("M\u00fc\u015fteriler tablosu:")\nprint(data.head())\nprint("Sipari\u015fler tablosu:")        \nprint(data2.head())\nprint("Inner Join i\u015flemi:")\ninner_join = pd.merge(data, data2, on='M\u00fc\u015fteriID', how='inner')\nprint(inner_join)<\/code><\/pre>\n
Join i\u015flemi \u00f6rne\u011fi:\nM\u00fc\u015fteriler tablosu:\n   M\u00fc\u015fteriID     Ad     \u015eehir           Email\n0          1  Ahmet  \u0130stanbul  ahmet@mail.com\n1          2  Bet\u00fcl    Ankara  betul@mail.com\n2          3    Cem     \u0130zmir    cem@mail.com\n3          4  Deniz   Antalya  deniz@mail.com\n4          5    Eda     Bursa    eda@mail.com\nSipari\u015fler tablosu:\n   Siparii\u015fID  M\u00fc\u015fteriID        \u00dcr\u00fcn  Tutar\n0         101          1      Laptop   5000\n1         102          2     Telefon   3000\n2         103          2      Tablet   2000\n3         104          3    Kulakl\u0131k    500\n4         105          5  Bilgisayar   4000\nInner Join i\u015flemi:\n   M\u00fc\u015fteriID     Ad     \u015eehir           Email  Siparii\u015fID        \u00dcr\u00fcn  Tutar\n0          1  Ahmet  \u0130stanbul  ahmet@mail.com         101      Laptop   5000\n1          2  Bet\u00fcl    Ankara  betul@mail.com         102     Telefon   3000\n2          2  Bet\u00fcl    Ankara  betul@mail.com         103      Tablet   2000\n3          5    Eda     Bursa    eda@mail.com         105  Bilgisayar   4000\n4          3    Cem     \u0130zmir    cem@mail.com         104    Kulakl\u0131k    500\n5          4  Deniz   Antalya  deniz@mail.com         108        Fare    200<\/code><\/pre>\n
Left join:<\/p>\n
print("Left Join i\u015flemi:")\nleft_join = pd.merge(data, data2, on='M\u00fc\u015fteriID', how='left')\nprint(left_join)  <\/code><\/pre>\n
Left Join i\u015flemi:\n   M\u00fc\u015fteriID     Ad      \u015eehir           Email  Siparii\u015fID        \u00dcr\u00fcn   Tutar\n0          1  Ahmet   \u0130stanbul  ahmet@mail.com       101.0      Laptop  5000.0\n1          2  Bet\u00fcl     Ankara  betul@mail.com       102.0     Telefon  3000.0\n2          2  Bet\u00fcl     Ankara  betul@mail.com       103.0      Tablet  2000.0\n3          3    Cem      \u0130zmir    cem@mail.com       104.0    Kulakl\u0131k   500.0\n4          4  Deniz    Antalya  deniz@mail.com       108.0        Fare   200.0\n5          5    Eda      Bursa    eda@mail.com       105.0  Bilgisayar  4000.0\n6          6  Fatih  Gaziantep  fatih@mail.com         NaN         NaN     NaN<\/code><\/pre>\n
Right Join:<\/p>\n
print("Right Join i\u015flemi:")\nright_join = pd.merge(data, data2, on='M\u00fc\u015fteriID', how='right')\nprint(right_join) <\/code><\/pre>\n
Right Join i\u015flemi:\n   M\u00fc\u015fteriID     Ad     \u015eehir           Email  Siparii\u015fID        \u00dcr\u00fcn  Tutar\n0          1  Ahmet  \u0130stanbul  ahmet@mail.com         101      Laptop   5000\n1          2  Bet\u00fcl    Ankara  betul@mail.com         102     Telefon   3000\n2          2  Bet\u00fcl    Ankara  betul@mail.com         103      Tablet   2000\n3          3    Cem     \u0130zmir    cem@mail.com         104    Kulakl\u0131k    500\n4          5    Eda     Bursa    eda@mail.com         105  Bilgisayar   4000\n5          7    NaN       NaN             NaN         106     Monit\u00f6r   1500\n6          8    NaN       NaN             NaN         107      Yaz\u0131c\u0131    800\n7          4  Deniz   Antalya  deniz@mail.com         108        Fare    200<\/code><\/pre>\n
Outer Join:<\/p>\n
print("Outer Join i\u015flemi:")\nouter_join = pd.merge(data, data2, on='M\u00fc\u015fteriID', how='outer')\nprint(outer_join)<\/code><\/pre>\n
Outer Join i\u015flemi:\n   M\u00fc\u015fteriID     Ad      \u015eehir           Email  Siparii\u015fID        \u00dcr\u00fcn   Tutar\n0          1  Ahmet   \u0130stanbul  ahmet@mail.com       101.0      Laptop  5000.0\n1          2  Bet\u00fcl     Ankara  betul@mail.com       102.0     Telefon  3000.0\n2          2  Bet\u00fcl     Ankara  betul@mail.com       103.0      Tablet  2000.0\n3          3    Cem      \u0130zmir    cem@mail.com       104.0    Kulakl\u0131k   500.0\n4          4  Deniz    Antalya  deniz@mail.com       108.0        Fare   200.0\n5          5    Eda      Bursa    eda@mail.com       105.0  Bilgisayar  4000.0\n6          6  Fatih  Gaziantep  fatih@mail.com         NaN         NaN     NaN\n7          7    NaN        NaN             NaN       106.0     Monit\u00f6r  1500.0\n8          8    NaN        NaN             NaN       107.0      Yaz\u0131c\u0131   800.0<\/code><\/pre>\n
Son olarak ise append olay\u0131ndan bahsedilmi\u015ftir. Burada asl\u0131nda loop olarak yapmak istedi\u011fimiz i\u015flemleri append ile kolay \u015fekilde ger\u00e7ekle\u015ftirebiliyoruz. \u00d6rnek a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p>\n
print("Append i\u015flemi \u00f6rne\u011fi:")\n\ndef degerlendirme(data):\n    if data >= 24:\n        return "S\u0131cak"\n    elif data >= 15 and data < 24:\n        return "Il\u0131k"\n    else:\n        return "So\u011fuk"\n\ndata = pd.read_csv('hava_durumu.csv')\ncount_Tarih = len(data["Tarih"].unique())\ncount_Sehir = len(data["\u015eehir"].unique())\nsicakliklar = data["S\u0131cakl\u0131k(\u00b0C)"].values.reshape(count_Tarih, count_Sehir)\ndf = pd.DataFrame(columns=data["\u015eehir"].unique(), index=data["Tarih"].unique(), data=sicakliklar)\nprint("Orijinal DataFrame:")\nprint(df)\nprint("Sadece \u0130stanbul s\u00fctunu:")\nnew_df = pd.DataFrame(df["\u0130stanbul"])\nprint(new_df)\nprint("Yeni s\u00fctun ekleme:")\nnew_df["\u0130stanbul_De\u011ferlendirme"] = new_df["\u0130stanbul"].apply(degerlendirme)\nprint(new_df)<\/code><\/pre>\n
\u0130\u015fte \u00c7\u0131kt\u0131s\u0131:<\/p>\n
Append i\u015flemi \u00f6rne\u011fi:\nOrijinal DataFrame:\n            \u0130stanbul  Ankara  \u0130zmir  Antalya  Bursa  Gaziantep\n2024-06-15      24.8     NaN   29.6     18.2   23.8       32.6\n2024-06-16       NaN    28.0    NaN     32.2   33.8       16.5\n2024-06-17      23.2    20.1   25.4     32.9   30.7       30.6\n2024-06-18      20.5    22.5   33.8     23.3    NaN       24.7\n2024-06-19      23.6    19.5   30.0     18.8    NaN       32.9\n2024-06-20      24.0    34.3   31.6     19.6   27.0       25.8\n2024-06-21      15.4    24.4   30.9     21.8   30.8       27.5\n2024-06-22      30.7    28.4    NaN     25.1    NaN       31.2\n2024-06-23       NaN    25.5   18.5     22.1   31.6       25.6\n2024-06-24      29.1    29.9   24.1     20.4    NaN       31.9\nSadece \u0130stanbul s\u00fctunu:\n            \u0130stanbul\n2024-06-15      24.8\n2024-06-16       NaN\n2024-06-17      23.2\n2024-06-18      20.5\n2024-06-19      23.6\n2024-06-20      24.0\n2024-06-21      15.4\n2024-06-22      30.7\n2024-06-23       NaN\n2024-06-24      29.1\nYeni s\u00fctun ekleme:\n            \u0130stanbul \u0130stanbul_De\u011ferlendirme\n2024-06-15      24.8                  S\u0131cak\n2024-06-16       NaN                  So\u011fuk\n2024-06-17      23.2                   Il\u0131k\n2024-06-18      20.5                   Il\u0131k\n2024-06-19      23.6                   Il\u0131k\n2024-06-20      24.0                  S\u0131cak\n2024-06-21      15.4                   Il\u0131k\n2024-06-22      30.7                  S\u0131cak\n2024-06-23       NaN                  So\u011fuk\n2024-06-24      29.1                  S\u0131cak<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
E\u011fitim Pandas k\u00fct\u00fcphanesi analtmakla devam ediyor. Bug\u00fcn e\u011fitim i\u00e7erisinde verileri okuduktan sonra dataframe i\u00e7erisinde uygun formata nas\u0131l getirebilece\u011fimizi g\u00f6rd\u00fck. \u00d6rnek olmas\u0131 a\u00e7\u0131s\u0131ndan mesela a\u015fa\u011f\u0131daki gibi…<\/p>\n
Devam\u0131n\u0131 okuPandas \u2013 Derin \u00d6\u011frenme G\u00fcn 3<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[708],"tags":[731],"class_list":["post-2286","post","type-post","status-publish","format-standard","hentry","category-derin-ogrenme","tag-pandas","entry"],"_links":{"self":[{"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/posts\/2286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/comments?post=2286"}],"version-history":[{"count":1,"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/posts\/2286\/revisions"}],"predecessor-version":[{"id":2287,"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/posts\/2286\/revisions\/2287"}],"wp:attachment":[{"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/media?parent=2286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/categories?post=2286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/berenkudaygorun.com\/blog\/wp-json\/wp\/v2\/tags?post=2286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}