{"id":9179,"date":"2023-11-07T18:32:22","date_gmt":"2023-11-07T13:02:22","guid":{"rendered":"https:\/\/python-programs.com\/?p=9179"},"modified":"2023-11-10T12:21:33","modified_gmt":"2023-11-10T06:51:33","slug":"python-add-a-column-to-an-existing-csv-file","status":"publish","type":"post","link":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/","title":{"rendered":"Python: Add a Column to an Existing CSV File"},"content":{"rendered":"<h2>Methods to add a column to an existing CSV File<\/h2>\n<p>In this article, we will discuss how to add a column to an existing CSV file using <code>csv.reader<\/code>\u00a0and\u00a0<code>csv.DictWriter<\/code>\u00a0 classes. Apart from appending the columns, we will also discuss how to insert columns in between other columns of the existing CSV file.<span id=\"more-4283\"><\/span><\/p>\n<h3>Original CSV file content<\/h3>\n<div class=\"cell code_cell rendered selected\">\n<div class=\"output_wrapper\">\n<div class=\"output\">\n<div class=\"output_area\">\n<div class=\"output_subarea output_html rendered_html output_result\">\n<table class=\"dataframe\" border=\"1\">\n<thead>\n<tr>\n<th><\/th>\n<th>total_bill<\/th>\n<th>tip<\/th>\n<th>sex<\/th>\n<th>smoker<\/th>\n<th>day<\/th>\n<th>time<\/th>\n<th>size<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th>0<\/th>\n<td>16.99<\/td>\n<td>1.01<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<th>1<\/th>\n<td>10.34<\/td>\n<td>1.66<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<th>2<\/th>\n<td>21.01<\/td>\n<td>3.50<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<th>3<\/th>\n<td>23.68<\/td>\n<td>3.31<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<th>4<\/th>\n<td>24.59<\/td>\n<td>3.61<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>\n<h3>Method 1-Add a column with the same values to an existing CSV file<\/h3>\n<\/li>\n<\/ul>\n<p>In this, we see how we make one column and add it to our CSV file but all the values in this column are the same.<\/p>\n<p>Steps will be to append a column in CSV file are,<\/p>\n<ol>\n<li>Open \u2018input.csv\u2019 file in read mode and create csv.reader object for this CSV file<\/li>\n<li>Open \u2018output.csv\u2019 file in write mode and create csv.writer object for this CSV file<\/li>\n<li>Using reader object, read the \u2018input.csv\u2019 file line by line<\/li>\n<li>For each row (read like a list ), append default text in the list.<\/li>\n<li>Write this updated list \/ row in the \u2018output.csv\u2019 using csv.writer object for this file.<\/li>\n<li>Close both input.csv and output.csv file.<\/li>\n<\/ol>\n<p>Let see this with the help of an example<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\">from csv import writer\r\nfrom csv import reader\r\ndefault_text = 'New column'\r\n# Open the input_file in read mode and output_file in write mode\r\nwith open('example1.csv', 'r') as read_obj, \\\r\n        open('output_1.csv', 'w', newline='') as write_obj:\r\n    # Create a csv.reader object from the input file object\r\n    csv_reader = reader(read_obj)\r\n    # Create a csv.writer object from the output file object\r\n    csv_writer = writer(write_obj)\r\n    # Read each row of the input csv file as list\r\n    for row in csv_reader:\r\n        # Append the default text in the row \/ list\r\n        row.append(default_text)\r\n        # Add the updated row \/ list to the output file\r\n        csv_writer.writerow(row)\r\noutput_data=pd.read_csv('output_1.csv')\r\noutput_data.head()<\/pre>\n<p>Output<\/p>\n<table class=\"dataframe\" border=\"1\">\n<thead>\n<tr>\n<th><\/th>\n<th>total_bill<\/th>\n<th>tip<\/th>\n<th>sex<\/th>\n<th>smoker<\/th>\n<th>day<\/th>\n<th>time<\/th>\n<th>size<\/th>\n<th>New column<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th>0<\/th>\n<td>16.99<\/td>\n<td>1.01<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<td>New column<\/td>\n<\/tr>\n<tr>\n<th>1<\/th>\n<td>10.34<\/td>\n<td>1.66<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<td>New column<\/td>\n<\/tr>\n<tr>\n<th>2<\/th>\n<td>21.01<\/td>\n<td>3.50<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<td>New column<\/td>\n<\/tr>\n<tr>\n<th>3<\/th>\n<td>23.68<\/td>\n<td>3.31<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<td>New column<\/td>\n<\/tr>\n<tr>\n<th>4<\/th>\n<td>24.59<\/td>\n<td>3.61<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>4<\/td>\n<td>New column<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Here we see that new column is added but all value in this column is same.<\/p>\n<p>Now we see how we can add different values in the column.<\/p>\n<ul>\n<li>\n<h3>\u00a0Method 2-Add a column to an existing CSV file, based on values from other columns<\/h3>\n<\/li>\n<\/ul>\n<p>In this method how we can make a new column but in this column the value we add will be a combination of two or more columns. As we know there is no direct function to achieve so we have to write our own function to achieve this task. Let see the code for this.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\">from csv import writer\r\nfrom csv import reader\r\ndef add_column_in_csv(input_file, output_file, transform_row):\r\n    \"\"\" Append a column in existing csv using csv.reader \/ csv.writer classes\"\"\"\r\n    # Open the input_file in read mode and output_file in write mode\r\n    with open(input_file, 'r') as read_obj, \\\r\n            open(output_file, 'w', newline='') as write_obj:\r\n        # Create a csv.reader object from the input file object\r\n        csv_reader = reader(read_obj)\r\n        # Create a csv.writer object from the output file object\r\n        csv_writer = writer(write_obj)\r\n        # Read each row of the input csv file as list\r\n        for row in csv_reader:\r\n            # Pass the list \/ row in the transform function to add column text for this row\r\n            transform_row(row, csv_reader.line_num)\r\n            # Write the updated row \/ list to the output file\r\n            csv_writer.writerow(row)\r\nadd_column_in_csv('example1.csv', 'output_2.csv', lambda row, line_num: row.append(row[0] + '__' + row[1]))\r\noutput_data=pd.read_csv('output_2.csv')\r\noutput_data.head()<\/pre>\n<p>Output<\/p>\n<table class=\"dataframe\" border=\"1\">\n<thead>\n<tr>\n<th><\/th>\n<th>total_bill<\/th>\n<th>tip<\/th>\n<th>sex<\/th>\n<th>smoker<\/th>\n<th>day<\/th>\n<th>time<\/th>\n<th>size<\/th>\n<th>total_bill__tip<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th>0<\/th>\n<td>16.99<\/td>\n<td>1.01<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<td>16.99__1.01<\/td>\n<\/tr>\n<tr>\n<th>1<\/th>\n<td>10.34<\/td>\n<td>1.66<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<td>10.34__1.66<\/td>\n<\/tr>\n<tr>\n<th>2<\/th>\n<td>21.01<\/td>\n<td>3.50<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<td>21.01__3.5<\/td>\n<\/tr>\n<tr>\n<th>3<\/th>\n<td>23.68<\/td>\n<td>3.31<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<td>23.68__3.31<\/td>\n<\/tr>\n<tr>\n<th>4<\/th>\n<td>24.59<\/td>\n<td>3.61<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>4<\/td>\n<td>24.59__3.61<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Here we see the new column is formed as the combination of the values of the 1st and 2nd column.<\/p>\n<p>Explanation:<\/p>\n<p>In the Lambda function, we received each row as a list and the line number. It then added a value in the list and the value is a merger of the first and second value of the list. It appended the column in the contents of example1.csv by merging values of the first and second columns and then saved the changes as output_2.csv files.<\/p>\n<ul>\n<li>\n<h3>Method 3-Add a list as a column to an existing csv file<\/h3>\n<\/li>\n<\/ul>\n<p>In this method, we will add our own value in the column by making a list of our values and pass this into the function that we will make. Let see the code for this.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\">from csv import writer\r\nfrom csv import reader\r\ndef add_column_in_csv(input_file, output_file, transform_row):\r\n    \"\"\" Append a column in existing csv using csv.reader \/ csv.writer classes\"\"\"\r\n    # Open the input_file in read mode and output_file in write mode\r\n    with open(input_file, 'r') as read_obj, \\\r\n            open(output_file, 'w', newline='') as write_obj:\r\n        # Create a csv.reader object from the input file object\r\n        csv_reader = reader(read_obj)\r\n        # Create a csv.writer object from the output file object\r\n        csv_writer = writer(write_obj)\r\n        # Read each row of the input csv file as list\r\n        for row in csv_reader:\r\n            # Pass the list \/ row in the transform function to add column text for this row\r\n            transform_row(row, csv_reader.line_num)\r\n            # Write the updated row \/ list to the output file\r\n            csv_writer.writerow(row)\r\nl=[]\r\nl.append(\"New Column\")\r\nrows = len(data.axes[0])\r\nfor i in range(rows):\r\n    val=i+1\r\n    l.append(val)\r\nadd_column_in_csv('example1.csv', 'output_3.csv', lambda row, line_num: row.append(l[line_num - 1]))\r\noutput_data=pd.read_csv('output_3.csv')\r\noutput_data.head()<\/pre>\n<p>Output<\/p>\n<div class=\"cell code_cell rendered selected\">\n<div class=\"output_wrapper\">\n<div class=\"output\">\n<div class=\"output_area\">\n<div class=\"output_subarea output_html rendered_html output_result\">\n<div>\n<table class=\"dataframe\" border=\"1\">\n<thead>\n<tr>\n<th><\/th>\n<th>total_bill<\/th>\n<th>tip<\/th>\n<th>sex<\/th>\n<th>smoker<\/th>\n<th>day<\/th>\n<th>time<\/th>\n<th>size<\/th>\n<th>New Column<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th>0<\/th>\n<td>16.99<\/td>\n<td>1.01<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<th>1<\/th>\n<td>10.34<\/td>\n<td>1.66<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<th>2<\/th>\n<td>21.01<\/td>\n<td>3.50<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>3<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<th>3<\/th>\n<td>23.68<\/td>\n<td>3.31<\/td>\n<td>Male<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>2<\/td>\n<td>4<\/td>\n<\/tr>\n<tr>\n<th>4<\/th>\n<td>24.59<\/td>\n<td>3.61<\/td>\n<td>Female<\/td>\n<td>No<\/td>\n<td>Sun<\/td>\n<td>Dinner<\/td>\n<td>4<\/td>\n<td>5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Explanation<\/p>\n<p>In the Lambda function, we received each row as a list and the line number. It then added a value in the list and the value is an entry from our list l at index\u00a0\u00a0line_num \u2013 1.Thus all the entries in the\u00a0<em>list l\u00a0<\/em>are added as a column in the CSV.<\/p>\n<p>So these are some of the methods to add new column in csv.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Methods to add a column to an existing CSV File In this article, we will discuss how to add a column to an existing CSV file using csv.reader\u00a0and\u00a0csv.DictWriter\u00a0 classes. Apart from appending the columns, we will also discuss how to insert columns in between other columns of the existing CSV file. Original CSV file content &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/\"> <span class=\"screen-reader-text\">Python: Add a Column to an Existing CSV File<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[6],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python: Add a Column to an Existing CSV File - Python Programs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python: Add a Column to an Existing CSV File - Python Programs\" \/>\n<meta property=\"og:description\" content=\"Methods to add a column to an existing CSV File In this article, we will discuss how to add a column to an existing CSV file using csv.reader\u00a0and\u00a0csv.DictWriter\u00a0 classes. Apart from appending the columns, we will also discuss how to insert columns in between other columns of the existing CSV file. Original CSV file content &hellip; Python: Add a Column to an Existing CSV File Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Python Programs\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/btechgeeks\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-07T13:02:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-10T06:51:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:site\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mayank Gupta\" \/>\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\":\"Organization\",\"@id\":\"https:\/\/python-programs.com\/#organization\",\"name\":\"BTech Geeks\",\"url\":\"https:\/\/python-programs.com\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/btechgeeks\/\",\"https:\/\/www.linkedin.com\/in\/btechgeeks\",\"https:\/\/in.pinterest.com\/btechgeek\/\",\"https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg\",\"https:\/\/www.facebook.com\/btechgeeks\",\"https:\/\/twitter.com\/btech_geeks\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"contentUrl\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"width\":350,\"height\":70,\"caption\":\"BTech Geeks\"},\"image\":{\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/python-programs.com\/#website\",\"url\":\"https:\/\/python-programs.com\/\",\"name\":\"Python Programs\",\"description\":\"Python Programs with Examples, How To Guides on Python\",\"publisher\":{\"@id\":\"https:\/\/python-programs.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/python-programs.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#webpage\",\"url\":\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/\",\"name\":\"Python: Add a Column to an Existing CSV File - Python Programs\",\"isPartOf\":{\"@id\":\"https:\/\/python-programs.com\/#website\"},\"datePublished\":\"2023-11-07T13:02:22+00:00\",\"dateModified\":\"2023-11-10T06:51:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/python-programs.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python: Add a Column to an Existing CSV File\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#webpage\"},\"author\":{\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/2deaa2ec7f26a4b5e527737709032a41\"},\"headline\":\"Python: Add a Column to an Existing CSV File\",\"datePublished\":\"2023-11-07T13:02:22+00:00\",\"dateModified\":\"2023-11-10T06:51:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#webpage\"},\"wordCount\":634,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/python-programs.com\/#organization\"},\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/2deaa2ec7f26a4b5e527737709032a41\",\"name\":\"Mayank Gupta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d90409993b088dd1f731cb0e2d8b231c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d90409993b088dd1f731cb0e2d8b231c?s=96&d=mm&r=g\",\"caption\":\"Mayank Gupta\"},\"url\":\"https:\/\/python-programs.com\/author\/mayank\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python: Add a Column to an Existing CSV File - Python Programs","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:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/","og_locale":"en_US","og_type":"article","og_title":"Python: Add a Column to an Existing CSV File - Python Programs","og_description":"Methods to add a column to an existing CSV File In this article, we will discuss how to add a column to an existing CSV file using csv.reader\u00a0and\u00a0csv.DictWriter\u00a0 classes. Apart from appending the columns, we will also discuss how to insert columns in between other columns of the existing CSV file. Original CSV file content &hellip; Python: Add a Column to an Existing CSV File Read More &raquo;","og_url":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/","og_site_name":"Python Programs","article_publisher":"https:\/\/www.facebook.com\/btechgeeks","article_published_time":"2023-11-07T13:02:22+00:00","article_modified_time":"2023-11-10T06:51:33+00:00","twitter_card":"summary_large_image","twitter_creator":"@btech_geeks","twitter_site":"@btech_geeks","twitter_misc":{"Written by":"Mayank Gupta","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/python-programs.com\/#organization","name":"BTech Geeks","url":"https:\/\/python-programs.com\/","sameAs":["https:\/\/www.instagram.com\/btechgeeks\/","https:\/\/www.linkedin.com\/in\/btechgeeks","https:\/\/in.pinterest.com\/btechgeek\/","https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg","https:\/\/www.facebook.com\/btechgeeks","https:\/\/twitter.com\/btech_geeks"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/","url":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","contentUrl":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","width":350,"height":70,"caption":"BTech Geeks"},"image":{"@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/python-programs.com\/#website","url":"https:\/\/python-programs.com\/","name":"Python Programs","description":"Python Programs with Examples, How To Guides on Python","publisher":{"@id":"https:\/\/python-programs.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/python-programs.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#webpage","url":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/","name":"Python: Add a Column to an Existing CSV File - Python Programs","isPartOf":{"@id":"https:\/\/python-programs.com\/#website"},"datePublished":"2023-11-07T13:02:22+00:00","dateModified":"2023-11-10T06:51:33+00:00","breadcrumb":{"@id":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/python-programs.com\/"},{"@type":"ListItem","position":2,"name":"Python: Add a Column to an Existing CSV File"}]},{"@type":"Article","@id":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#article","isPartOf":{"@id":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#webpage"},"author":{"@id":"https:\/\/python-programs.com\/#\/schema\/person\/2deaa2ec7f26a4b5e527737709032a41"},"headline":"Python: Add a Column to an Existing CSV File","datePublished":"2023-11-07T13:02:22+00:00","dateModified":"2023-11-10T06:51:33+00:00","mainEntityOfPage":{"@id":"https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#webpage"},"wordCount":634,"commentCount":0,"publisher":{"@id":"https:\/\/python-programs.com\/#organization"},"articleSection":["Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/python-programs.com\/python-add-a-column-to-an-existing-csv-file\/#respond"]}]},{"@type":"Person","@id":"https:\/\/python-programs.com\/#\/schema\/person\/2deaa2ec7f26a4b5e527737709032a41","name":"Mayank Gupta","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d90409993b088dd1f731cb0e2d8b231c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d90409993b088dd1f731cb0e2d8b231c?s=96&d=mm&r=g","caption":"Mayank Gupta"},"url":"https:\/\/python-programs.com\/author\/mayank\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/9179"}],"collection":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/comments?post=9179"}],"version-history":[{"count":2,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/9179\/revisions"}],"predecessor-version":[{"id":11324,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/9179\/revisions\/11324"}],"wp:attachment":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/media?parent=9179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/categories?post=9179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/tags?post=9179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}