{"id":6974,"date":"2025-01-31T06:46:31","date_gmt":"2025-01-31T06:46:31","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=6974"},"modified":"2025-01-31T07:04:26","modified_gmt":"2025-01-31T07:04:26","slug":"how-to-rename-columns-in-pandas","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/","title":{"rendered":"How to Rename Columns in Pandas"},"content":{"rendered":"\n<p>Python developers often use Pandas library to store and manipulate data in a tabular manner. Pandas Dataframes are very efficient in allowing you to query data using rows &amp; columns. Sometimes, Python developers need to change the names of columns of dataframe. There are several ways to to do this. In this article, we will learn how to rename columns in Pandas.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#How_to_Rename_Columns_in_Pandas\" >How to Rename Columns in Pandas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#1_Using_columns_property\" >1. Using columns property<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#2_Using_rename_function\" >2. Using rename function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#3_Using_Lambda_function\" >3. Using Lambda function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#4_Using_zip_function\" >4. Using zip function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#5_Add_Prefix_or_Suffix_to_Column_Names\" >5. Add Prefix or Suffix to Column Names<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#6_Replace_one_or_more_characters_in_Column_names\" >6. Replace one or more characters in Column names<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#7_Using_set_axis\" >7. Using set_axis()<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#Conclusion\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#FAQs\" >FAQs<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Rename_Columns_in_Pandas\"><\/span>How to Rename Columns in Pandas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here are the different ways to change column names in Pandas dataframe. Let us say you have the following dataframe with 3 columns &#8211; $id, $name, $marks.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">import pandas as pd<br>data = {<br>  \"$id\": [1, 2, 3],<br>  \"$name\": ['John','Jim','Jane'],<br>  \"$marks\": [40, 45, 50]<br>}<br>df = pd.DataFrame(data)<br>print(df)<\/pre>\n\n\n\n<p>Here is the dataframe output you will see.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">   $id $name  $marks<br>0    1  John      40<br>1    2   Jim      45<br>2    3  Jane      50<\/pre>\n\n\n\n<p>Let us say you want to rename columns $id, $name and $marks to id, name and marks respectively. Here are the different ways to do this.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Using_columns_property\"><\/span>1. Using columns property<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Every Pandas dataframe has a built in property called columns. It contains a list of all column names. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">print(df.columns)<\/pre>\n\n\n\n<p>Here is the output.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Index(['$id', '$name', '$marks'], dtype='object')<\/pre>\n\n\n\n<p>You can rename columns by modifying the items in this list.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df.columns=['id','name','marks']<br>print(df.columns)<\/pre>\n\n\n\n<p>Here is the output after renaming columns.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Index(['id', 'name', 'marks'], dtype='object')<\/pre>\n\n\n\n<p>Here is the dataframe after renaming columns.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">print(df)<br><br># Output<br>   id  name  marks<br>0   1  John     40<br>1   2   Jim     45<br>2   3  Jane     50<\/pre>\n\n\n\n<p>Please note, when you modify columns attribute, you will have to provide a completely new list of column names. The number of items in this new list must be equal to the number of columns in your dataframe. Otherwise, you will get an error.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df.columns=['id','name']<br>print(df.columns)<br><br>## Output<br>ValueError: Length mismatch: Expected axis has 3 elements, new values have 2 elements<\/pre>\n\n\n\n<p>Along the same lines, you cannot modify just a single column name by this method. You need to provide column names for all the columns in dataframe.<\/p>\n\n\n\n<p>Another thing to remember is that the order of new column names must match that of old column names otherwise, wrong name will be assigned to the columns.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">## incorrect order<br>df.columns=['id','marks','name']<br><br>## correct order<br>df.columns=['id','name','marks']<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Using_rename_function\"><\/span>2. Using rename function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Every dataframe supports a rename() function that allows you to easily rename dataframe columns. It takes in a dictionary of key-value pairs where keys are old column names and values are their new names. Here is its syntax.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df.rename(columns={'old_column_name':'new_column_name',...}, inplace=True)<\/pre>\n\n\n\n<p>Here is an example to rename our columns.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df.rename(columns={'$id':'id','$name':'name','$marks':'marks'}, inplace=True)<br>print(df)<\/pre>\n\n\n\n<p>Here is the dataframe with modified column names.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">   id  name  marks<br>0   1  John     40<br>1   2   Jim     45<br>2   3  Jane     50<\/pre>\n\n\n\n<p>Please note, in the above example, we have used inplace=True option. Without this, rename() function will create a copy of the dataframe, with new column names but same data.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df1=df.rename(columns={'$id':'id','$name':'name','$marks':'marks'})<br>print(df1)<br>print(df)<br><br>## Output<br><br>   id  name  marks<br>0   1  John     40<br>1   2   Jim     45<br>2   3  Jane     50<br><br>   $id $name  $marks<br>0    1  John      40<br>1    2   Jim      45<br>2    3  Jane      50<\/pre>\n\n\n\n<p>This solution allows you to rename one or more columns as per your requirement. While providing column names, you do not need to follow any order. Here is an example to rename just first column and leave the rest unchanged.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df.rename(columns={'$id':'id'}, inplace=True)<br>print(df)<br><br>## Output<br>   id $name  $marks<br>0   1  John      40<br>1   2   Jim      45<br>2   3  Jane      50<\/pre>\n\n\n\n<p>This is a very useful solution because it allows you to rename columns in place, or create a new dataframe with new column names and same data. It also allows you to rename one or more columns, as per your requirement, instead of renaming all columns, every single time.<\/p>\n\n\n\n<p>In rename() function, if the old column names you mention do not exist in the dataframe, then Python will silently skip it, instead of giving any error.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Using_Lambda_function\"><\/span>3. Using Lambda function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In each of the above solutions, you need to mention both the old and new column names. What if your dataframe has many columns, like 100 columns? Then it becomes very tedious to rename each of them. <\/p>\n\n\n\n<p>In such cases, you can use a lambda function to replace certain patterns in columns names. This method is useful if you want to replace a specific pattern in each of your column names. For example, if you want to remove $ sign from each of your column name, then you can use the following lambda function, inside rename() function.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df.rename(lambda x: x[1:], axis='columns', inplace=True)<br>OR<br>df.rename(lambda x: x[1:], axis=1, inplace=True)<br>print(df)<br><br>## output<br><br>   id  name  marks<br>0   1  John     40<br>1   2   Jim     45<br>2   3  Jane     50<\/pre>\n\n\n\n<p>In the above code, we define a lambda function which basically slices each column name. It extracts all characters of the column name except the first character and re-assigns it back to each column.<\/p>\n\n\n\n<p>This approach is very useful if you have many columns, each with certain pattern in them. This is a common requirement, if your dataframes are programmatically generated from a feed or file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Using_zip_function\"><\/span>4. Using zip function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If your old and new column names are present as two separate lists, then you can use zip() function to club the two lists into a single dict and pass it in rename() function. Here is an example to illustrate it.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">old_names = ['$id', '$name', '$marks'] <br>new_names = ['id', 'name', 'marks']<br>df.rename(columns=dict(zip(old_names, new_names)), inplace=True)<br>print(df)<br><br>## Output<br>   id  name  marks<br>0   1  John     40<br>1   2   Jim     45<br>2   3  Jane     50<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_Add_Prefix_or_Suffix_to_Column_Names\"><\/span>5. Add Prefix or Suffix to Column Names<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sometimes, all you want to do is add a small prefix or suffix to each of your column names. For this purpose, manually specifying new name of each column, seems tedious. Luckily, Pandas provides add_prefix() and add_suffix() functions to add prefix and suffix respectively. They are built in functions readily available for each dataframe.<\/p>\n\n\n\n<p>Here is an example to add prefix &#8216;x_&#8217; to each column name.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df1=df.add_prefix('x_')<br>print(df1)<br><br>## Output<br><br>   x_$id x_$name  x_$marks<br>0      1    John        40<br>1      2     Jim        45<br>2      3    Jane        50<\/pre>\n\n\n\n<p>Similarly, here is an example to show how to add suffix &#8216;_y&#8217;.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df1=df.add_suffix('_y')<br>print(df1)<br><br>## output<br><br>   $id_y $name_y  $marks_y<br>0      1    John        40<br>1      2     Jim        45<br>2      3    Jane        50<\/pre>\n\n\n\n<p>Please note, both add_prefix() and add_suffix() functions will create a copy of your dataframe, and modify each column name. They will leave your original dataframe unchanged.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_Replace_one_or_more_characters_in_Column_names\"><\/span>6. Replace one or more characters in Column names<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sometimes, you want to replace a character or substring with another character or substring. For this purpose, you can use str.replace(). It is available for columns property in solution #1 above. Here is an example to replace $ character in each column name with _ character.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df.columns = df.columns.str.replace('$', '_')<br>print(df)<br><br>## Output<br><br>   _id _name  _marks<br>0    1  John      40<br>1    2   Jim      45<br>2    3  Jane      50<\/pre>\n\n\n\n<p>Please note, in this case, the original dataframe is modified and no new copy is created.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_Using_set_axis\"><\/span>7. Using set_axis()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Every dataframe supports set_axis() that accepts a list of new column names and an axis (0 for rows and 1 for columns). Here is an example to illustrate it.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df1=df.set_axis(['id', 'name', 'marks'], axis=1)<br>print(df1)<br><br>## Output<br><br>   id  name  marks<br>0   1  John     40<br>1   2   Jim     45<br>2   3  Jane     50<\/pre>\n\n\n\n<p>Please note, set_axis() will create a copy of the dataframe, change its column names. It will leave the original dataframe unchanged. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this article, we have learnt several simple ways to easily rename columns in pandas dataframe. We have also covered many different use cases commonly required by Python developers. If you want to rename all columns in your dataframe, then you can use its <em>columns<\/em> attribute. If you want to selectively rename one or more columns, then you can use rename() column. <\/p>\n\n\n\n<p>If your dataframe has many columns, then you can try to use lambda function to do pattern matching and rename columns in bulk. If all you want to do is add a prefix\/suffix to each of your column names use add_prefix\/add_suffix functions for this purpose. If you want to replace a character\/substring in each of your column names, then use str.replace() function.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>1. How to rename only certain columns in dataframe?<\/strong><\/p>\n\n\n\n<p>You can use rename() function with a dict of key-value pairs, where key is the old column name and value is the new column name. It is mentioned above in solution #2.<\/p>\n\n\n\n<p><strong>2. How to add prefix or suffix to each column name?<\/strong><\/p>\n\n\n\n<p>Every dataframe supports add_prefix and add_suffix functions to add prefix and suffix respectively. Use add_prefix() to add prefix to each column name. Use add_suffix() function to add suffix to each column name.<\/p>\n\n\n\n<p><strong>3. How to replace specific characters in each column name?<\/strong><\/p>\n\n\n\n<p>Use df.column.str.replace() function that is available for each dataframe&#8217;s column attribute.<\/p>\n\n\n\n<p>Also read:<\/p>\n\n\n\n<p><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-select-rows-from-dataframe-based-on-column-values\/\">How to Select Rows in Pandas Dataframe<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-concatenate-two-lists-in-python\/\">How to Concatenate Two Lists in Python<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-list-all-files-in-directory\/\">How to List All Files in Directory<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes Python developers need to rename columns in Pandas Dataframe. Here are several ways to change column names in Pandas.<\/p>\n","protected":false},"author":1,"featured_media":6990,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[301],"tags":[384],"class_list":["post-6974","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python","tag-rename-columns"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Rename Columns in Pandas - Ubiq BI<\/title>\n<meta name=\"description\" content=\"Sometimes Python developers need to rename columns in Pandas Dataframe. Here are several ways to change column names in Pandas.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Rename Columns in Pandas - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"Sometimes Python developers need to rename columns in Pandas Dataframe. Here are several ways to change column names in Pandas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-31T06:46:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-31T07:04:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/01\/rename-column-pandas.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"258\" \/>\n\t<meta property=\"og:image:height\" content=\"171\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How to Rename Columns in Pandas\",\"datePublished\":\"2025-01-31T06:46:31+00:00\",\"dateModified\":\"2025-01-31T07:04:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/\"},\"wordCount\":1195,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/rename-column-pandas.jpg?fit=258%2C171&ssl=1\",\"keywords\":[\"rename columns\"],\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/\",\"name\":\"How to Rename Columns in Pandas - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/rename-column-pandas.jpg?fit=258%2C171&ssl=1\",\"datePublished\":\"2025-01-31T06:46:31+00:00\",\"dateModified\":\"2025-01-31T07:04:26+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"Sometimes Python developers need to rename columns in Pandas Dataframe. Here are several ways to change column names in Pandas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/rename-column-pandas.jpg?fit=258%2C171&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/rename-column-pandas.jpg?fit=258%2C171&ssl=1\",\"width\":258,\"height\":171,\"caption\":\"rename column in pandas\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-rename-columns-in-pandas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Rename Columns in Pandas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sreeram-sreenivasan\\\/\"],\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/author\\\/wordpress\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Rename Columns in Pandas - Ubiq BI","description":"Sometimes Python developers need to rename columns in Pandas Dataframe. Here are several ways to change column names in Pandas.","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:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/","og_locale":"en_US","og_type":"article","og_title":"How to Rename Columns in Pandas - Ubiq BI","og_description":"Sometimes Python developers need to rename columns in Pandas Dataframe. Here are several ways to change column names in Pandas.","og_url":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2025-01-31T06:46:31+00:00","article_modified_time":"2025-01-31T07:04:26+00:00","og_image":[{"width":258,"height":171,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/01\/rename-column-pandas.jpg","type":"image\/jpeg"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How to Rename Columns in Pandas","datePublished":"2025-01-31T06:46:31+00:00","dateModified":"2025-01-31T07:04:26+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/"},"wordCount":1195,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/01\/rename-column-pandas.jpg?fit=258%2C171&ssl=1","keywords":["rename columns"],"articleSection":["Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/","url":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/","name":"How to Rename Columns in Pandas - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/01\/rename-column-pandas.jpg?fit=258%2C171&ssl=1","datePublished":"2025-01-31T06:46:31+00:00","dateModified":"2025-01-31T07:04:26+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"Sometimes Python developers need to rename columns in Pandas Dataframe. Here are several ways to change column names in Pandas.","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/01\/rename-column-pandas.jpg?fit=258%2C171&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/01\/rename-column-pandas.jpg?fit=258%2C171&ssl=1","width":258,"height":171,"caption":"rename column in pandas"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-rename-columns-in-pandas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How to Rename Columns in Pandas"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/01\/rename-column-pandas.jpg?fit=258%2C171&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-1Ou","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/6974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=6974"}],"version-history":[{"count":29,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/6974\/revisions"}],"predecessor-version":[{"id":7006,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/6974\/revisions\/7006"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/6990"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=6974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=6974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=6974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}