{"id":429,"date":"2023-02-26T16:04:28","date_gmt":"2023-02-27T00:04:28","guid":{"rendered":"https:\/\/www.antunkarlovac.com\/blog\/?p=429"},"modified":"2023-04-13T11:09:05","modified_gmt":"2023-04-13T19:09:05","slug":"slicing-pandas-dataframe-columns-cheat-sheet","status":"publish","type":"post","link":"https:\/\/www.antunkarlovac.com\/blog\/2023\/02\/26\/slicing-pandas-dataframe-columns-cheat-sheet\/","title":{"rendered":"Slicing Pandas Dataframe Columns Cheat Sheet"},"content":{"rendered":"\n

Here’s my quick cheat-sheet on slicing columns from a Pandas dataframe. Consider this dataset:<\/p>\n\n\n

\ndf = pd.DataFrame([\n                    ["AA", "747", 1],\n                    ["AB", "A380", 1],\n                    ["AA", "737", 0],\n                    ["AB", "747", 1],\n                    ["AA", "737", 0]\n                ],\n                columns=["Airline", "Aircraft", "Class"])\n<\/pre><\/div>\n\n\n
It has 3 columns. You can use the iloc function<\/a> to slice columns:<\/p>\n\n\n\n
Airline<\/td>Aircraft<\/td>Class<\/td><\/tr>
AA<\/td>747<\/td>1<\/td><\/tr>
AB<\/td>A380<\/td>1<\/td><\/tr>
AA<\/td>737<\/td>0<\/td><\/tr>
AB<\/td>747<\/td>1<\/td><\/tr>
AA<\/td>737<\/td>0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
1st column only:<\/strong><\/p>\n\n\n
\ndf.iloc[:, 0:1].values\n\narray([['AA', '747'],\n       ['AB', 'A380'],\n       ['AA', '737'],\n       ['AB', '747'],\n       ['AA', '737']], dtype=object)\n<\/pre><\/div>\n\n\n
1st through last columns (i.e. all columns):<\/strong><\/p>\n\n\n
\ndf.iloc[:, :].values\ndf.iloc[:, 0:].values # Alternate syntax\n\narray([['AA', '747', 1],\n       ['AB', 'A380', 1],\n       ['AA', '737', 0],\n       ['AB', '747', 1],\n       ['AA', '737', 0]], dtype=object)\n<\/pre><\/div>\n\n\n
2nd column only:<\/strong><\/p>\n\n\n
\ndf.iloc[:, 1:2].values\n\narray([['747'],\n       ['A380'],\n       ['737'],\n       ['747'],\n       ['737']], dtype=object)\n<\/pre><\/div>\n\n\n
2nd through last columns:<\/strong><\/p>\n\n\n
\ndf.iloc[:, 1:].values\n\narray([['747', 1],\n       ['A380', 1],\n       ['737', 0],\n       ['747', 1],\n       ['737', 0]], dtype=object)\n<\/pre><\/div>\n\n\n
1st through last-but-one:<\/strong><\/p>\n\n\n
\ndf.iloc[:, :-1].values\ndf.iloc[:, 0:-1].values # Alternate syntax\n\narray([['AA', '747'],\n       ['AB', 'A380'],\n       ['AA', '737'],\n       ['AB', '747'],\n       ['AA', '737']], dtype=object)\n<\/pre><\/div>\n\n\n
Last column only:<\/strong><\/p>\n\n\n
\ndf.iloc[:, -1:].values\n\narray([[1],\n       [1],\n       [0],\n       [1],\n       [0]])\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Here’s my quick cheat-sheet on slicing columns from a Pandas dataframe. Consider this dataset: It has 3 columns. You can use the iloc function to slice columns: Airline Aircraft Class AA 747 1 AB A380 1 AA 737 0 AB 747 1 AA 737 0 1st column only: 1st through last columns (i.e. all columns): … Continue reading Slicing Pandas Dataframe Columns Cheat Sheet<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[20],"tags":[19,18],"_links":{"self":[{"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/posts\/429"}],"collection":[{"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/comments?post=429"}],"version-history":[{"count":1,"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":430,"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/posts\/429\/revisions\/430"}],"wp:attachment":[{"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/media?parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/categories?post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antunkarlovac.com\/blog\/wp-json\/wp\/v2\/tags?post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}