{"id":3524,"date":"2023-07-17T01:04:09","date_gmt":"2023-07-17T01:04:09","guid":{"rendered":"https:\/\/statorials.org\/tr\/pandalar-sutun-indeksini-aliyor\/"},"modified":"2023-07-17T01:04:09","modified_gmt":"2023-07-17T01:04:09","slug":"pandalar-sutun-indeksini-aliyor","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/pandalar-sutun-indeksini-aliyor\/","title":{"rendered":"Pandalar: s\u00fctun ad\u0131ndan s\u00fctun dizini nas\u0131l al\u0131n\u0131r?"},"content":{"rendered":"

<\/p>\n

\n

Pandalardaki bir s\u00fctun ad\u0131ndan s\u00fctun dizini de\u011ferini almak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz:<\/span><\/p>\n

Y\u00f6ntem 1: Bir s\u00fctun ad\u0131 i\u00e7in s\u00fctun dizinini alma<\/strong><\/span><\/p>\n

 df. columns<\/span> . get_loc<\/span> (' this_column<\/span> ')\n<\/strong><\/pre>\n
 Y\u00f6ntem 2: Birden \u00e7ok s\u00fctun ad\u0131 i\u00e7in s\u00fctun dizinini al\u0131n<\/strong><\/span><\/p>\n
 cols = [' this_column<\/span> ', ' that_column<\/span> ']\n\n[df. columns<\/span> . get_loc<\/span> (c) for<\/span> c in<\/span> cols if<\/span> c in<\/span> df]<\/strong><\/pre>\n
 A\u015fa\u011f\u0131daki \u00f6rnekler, her y\u00f6ntemin pratikte a\u015fa\u011f\u0131daki pandalar DataFrame ile nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf = pd. DataFrame<\/span> ({' store<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' sales<\/span> ': [18, 10, 14, 13, 19, 24, 25, 29],\n                   ' returns<\/span> ': [1, 2, 2, 3, 2, 3, 5, 4],\n                   ' recalls<\/span> ': [0, 0, 2, 1, 1, 2, 0, 1]})\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  store sales returns recalls\n0 to 18 1 0\n1 to 10 2 0\n2 A 14 2 2\n3 A 13 3 1\n4 B 19 2 1\n5 B 24 3 2\n6 B 25 5 0\n7 B 29 4 1<\/strong><\/pre>\n
 \u00d6rnek 1: Bir s\u00fctun ad\u0131 i\u00e7in s\u00fctun dizinini alma<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki kod, “d\u00f6nd\u00fcr\u00fcr” adl\u0131 s\u00fctun i\u00e7in s\u00fctun dizini de\u011ferinin nas\u0131l al\u0131naca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 #get column index for column with the name 'returns'\n<\/span>df. columns<\/span> . get_loc<\/span> (' returns<\/span> ')\n\n2<\/strong><\/pre>\n
 “Return” isimli s\u00fctunun s\u00fctun indeks de\u011feri 2’dir<\/strong> .<\/span><\/span><\/p>\n
 Not<\/strong> : Python’da s\u00fctun indeks de\u011ferleri 0’dan ba\u015flar. Yani “return” DataFrame’in \u00fc\u00e7\u00fcnc\u00fc s\u00fctunu oldu\u011fundan indeks de\u011feri 2’dir.<\/span><\/p>\n
 \u00d6rnek 2: Birden \u00e7ok s\u00fctun ad\u0131 i\u00e7in s\u00fctun dizinini alma<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki kod, DataFrame’deki birden \u00e7ok s\u00fctun i\u00e7in s\u00fctun dizini de\u011ferinin nas\u0131l al\u0131naca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 #define list of columns to get index for\n<\/span>cols = [' store<\/span> ', ' returns<\/span> ', ' recalls<\/span> ']\n\n#get column index for each column in list\n<\/span>[df. columns<\/span> . get_loc<\/span> (c) for<\/span> c in<\/span> cols if<\/span> c in<\/span> df]\n\n[0, 2, 3]\n<\/strong><\/pre>\n
 Sonu\u00e7tan \u015funlar\u0131 g\u00f6rebiliriz:<\/span><\/p>\n