{"id":5861,"date":"2015-07-24T12:15:17","date_gmt":"2015-07-24T09:15:17","guid":{"rendered":"http:\/\/www.webcodegeeks.com\/?p=5861"},"modified":"2015-07-12T11:49:09","modified_gmt":"2015-07-12T08:49:09","slug":"python-converting-wordpress-posts-csv-format","status":"publish","type":"post","link":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/","title":{"rendered":"Python: Converting WordPress posts in CSV format"},"content":{"rendered":"<p>Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some analysis in R.<\/p>\n<p><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_06-59-02.png\"><img decoding=\"async\" class=\"alignright wp-image-5870 size-full\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_06-59-02.png\" alt=\"2015-07-07_06-59-02\" width=\"313\" height=\"101\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_06-59-02.png 313w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_06-59-02-300x97.png 300w\" sizes=\"(max-width: 313px) 100vw, 313px\" \/><\/a><\/p>\n<p>I found a couple of WordPress CSV plugins but unfortunately I couldn\u2019t get any of them to work and ended up working with the raw XML data that WordPress produces when you \u2018export\u2019 a blog.<\/p>\n<p>I had the problem of the <a href=\"http:\/\/beerpla.net\/2012\/04\/13\/how-to-fix-incomplete-wordpress-wxr-exports\/\">export being incomplete<\/a> which I \u2018solved\u2019 by importing the posts in two parts of a few years each.<\/p>\n<p>I then spent quite a few hours struggling to get the data into shape using R\u2019s <a href=\"http:\/\/blog.rstudio.org\/2014\/11\/24\/rvest-easy-web-scraping-with-r\/\">rvest<\/a> library but eventually decided to do the scraping using Python\u2019s beautifulsoup and save it to a CSV file for analysis in R.<\/p>\n<p>The structure of the XML that we want to extract is as follows:<\/p>\n<pre class=\"brush:xml\">\r\n&lt;rss version=\"2.0\"\r\n\txmlns:excerpt=\"http:\/\/wordpress.org\/export\/1.2\/excerpt\/\"\r\n\txmlns:content=\"http:\/\/purl.org\/rss\/1.0\/modules\/content\/\"\r\n\txmlns:wfw=\"http:\/\/wellformedweb.org\/CommentAPI\/\"\r\n\txmlns:dc=\"http:\/\/purl.org\/dc\/elements\/1.1\/\"\r\n\txmlns:wp=\"http:\/\/wordpress.org\/export\/1.2\/\"\r\n&gt;\r\n...\r\n    &lt;channel&gt;\r\n\t\t&lt;item&gt;\r\n\t\t&lt;title&gt;First thoughts on Ruby...&lt;\/title&gt;\r\n\t\t&lt;link&gt;http:\/\/www.markhneedham.com\/blog\/2006\/08\/29\/first-thoughts-on-ruby\/&lt;\/link&gt;\r\n\t\t&lt;pubDate&gt;Tue, 29 Aug 2006 13:31:05 +0000&lt;\/pubDate&gt;\r\n...\r\n<\/pre>\n<p>I wrote the following script to parse the files:<\/p>\n<pre class=\" brush:py\">from bs4 import BeautifulSoup\r\nfrom soupselect import select\r\nfrom dateutil import parser\r\n\u00a0\r\nimport csv\r\n\u00a0\r\ndef read_page(page):\r\n    return BeautifulSoup(open(page, 'r').read())\r\n\u00a0\r\nwith open(\"posts.csv\", \"w\") as file:\r\n    writer = csv.writer(file, delimiter=\",\")\r\n    writer.writerow([\"title\", \"date\"])\r\n\u00a0\r\n    for row in select(read_page(\"part2.xml\"), \"item\"):\r\n        title = select(row, \"title\")[0].text.encode(\"utf-8\")\r\n        date = parser.parse(select(row, \"pubdate\")[0].text)\r\n        writer.writerow([title, date])\r\n\u00a0\r\n    for row in select(read_page(\"part1.xml\"), \"item\"):\r\n        title = select(row, \"title\")[0].text.encode(\"utf-8\")\r\n        date = parser.parse(select(row, \"pubdate\")[0].text)\r\n        writer.writerow([title, date])<\/pre>\n<p>We end up with a CSV file that looks like this:<\/p>\n<pre class=\" brush:bash\">$ head -n 10 posts.csv\r\ntitle,date\r\nFunctional C#: Writing a 'partition' function,2010-02-01 23:34:02+00:00\r\nCoding: Wrapping\/not wrapping 3rd party libraries and DSLs,2010-02-02 23:54:21+00:00\r\nFunctional C#: LINQ vs Method chaining,2010-02-05 18:06:28+00:00\r\nF#: function keyword,2010-02-07 02:54:13+00:00\r\nWilled vs Forced designs,2010-02-08 22:48:05+00:00\r\nFunctional C#: Extracting a higher order function with generics,2010-02-08 23:17:47+00:00\r\nJavascript: File encoding when using string.replace,2010-02-10 00:02:02+00:00\r\nF#: Inline functions and statically resolved type parameters,2010-02-10 23:06:14+00:00\r\nJavascript: Passing functions around with call and apply,2010-02-12 20:18:02+00:00<\/pre>\n<p>Let\u2019s quickly look over the data in R and check it\u2019s being correctly exported:<\/p>\n<pre class=\" brush:php\">require(dplyr)\r\nrequire(lubridate)\r\n\u00a0\r\ndf = read.csv(\"posts.csv\")\r\n\u00a0\r\n&gt; df %&gt;% count()\r\nSource: local data frame [1 x 1]\r\n\u00a0\r\n     n\r\n1 1501<\/pre>\n<p>So we\u2019ve exported 1501 posts. Let\u2019s cross check with the WordPress dashboard:<\/p>\n<p><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_07-06-02.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-5871\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_07-06-02.png\" alt=\"2015-07-07_07-06-02\" width=\"598\" height=\"152\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_07-06-02.png 598w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/07\/2015-07-07_07-06-02-300x76.png 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/a><\/p>\n<p>We\u2019ve gained two extra posts! A bit more exploration of the WordPress dashboard reveals that there are actually 2 draft posts lying around.<\/p>\n<p>We probably want to remove those from the export and luckily there\u2019s a \u2018status\u2019 tag for each post that we can check. We want to make sure it doesn\u2019t have the value \u2018draft&#8217;:<\/p>\n<pre class=\" brush:py\">from bs4 import BeautifulSoup\r\nfrom soupselect import select\r\nfrom dateutil import parser\r\n\u00a0\r\nimport csv\r\n\u00a0\r\ndef read_page(page):\r\n    return BeautifulSoup(open(page, 'r').read())\r\n\u00a0\r\nwith open(\"posts.csv\", \"w\") as file:\r\n    writer = csv.writer(file, delimiter=\",\")\r\n    writer.writerow([\"title\", \"date\"])\r\n\u00a0\r\n    for row in select(read_page(\"part2.xml\"), \"item\"):\r\n        if (not row.find(\"wp:status\")) or row.find(\"wp:status\").text != \"draft\":\r\n            title = select(row, \"title\")[0].text.encode(\"utf-8\")\r\n            date = parser.parse(select(row, \"pubdate\")[0].text)\r\n            writer.writerow([title, date])\r\n\u00a0\r\n    for row in select(read_page(\"part1.xml\"), \"item\"):\r\n        if (not row.find(\"wp:status\")) or row.find(\"wp:status\").text != \"draft\":\r\n            title = select(row, \"title\")[0].text.encode(\"utf-8\")\r\n            date = parser.parse(select(row, \"pubdate\")[0].text)\r\n            writer.writerow([title, date])<\/pre>\n<p>I also had to check if that tag actually existed since there were a couple of posts which didn\u2019t have it but had been published. If we check the resulting CSV file in R we can see that we\u2019ve now got all the posts:<\/p>\n<pre class=\" brush:php\">&gt; df = read.csv(\"posts.csv\")\r\n&gt; df %&gt;% count()\r\nSource: local data frame [1 x 1]\r\n\u00a0\r\n     n\r\n1 1499<\/pre>\n<p>Now we\u2019re ready to test a couple of hypotheses that I have but that\u2019s for another post!<\/p>\n<div class=\"attribution\">\n<table>\n<tbody>\n<tr>\n<td><span class=\"reference\">Reference: <\/span><\/td>\n<td><a href=\"http:\/\/www.markhneedham.com\/blog\/2015\/07\/07\/python-converting-wordpress-posts-in-csv-format\/\">Python: Converting WordPress posts in CSV format<\/a> from our <a href=\"http:\/\/www.webcodegeeks.com\/wcg\/\">WCG partner<\/a> Mark Needham at the <a href=\"http:\/\/www.markhneedham.com\/blog\/\">Mark Needham Blog<\/a> blog.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some analysis in R. I found a couple of WordPress CSV plugins but unfortunately I couldn\u2019t get any of them to work and ended up working &hellip;<\/p>\n","protected":false},"author":48,"featured_media":1651,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-5861","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python: Converting WordPress posts in CSV format - Web Code Geeks - 2026<\/title>\n<meta name=\"description\" content=\"Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python: Converting WordPress posts in CSV format - Web Code Geeks - 2026\" \/>\n<meta property=\"og:description\" content=\"Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webcodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-24T09:15:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mark Needham\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webcodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@webcodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Needham\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/\"},\"author\":{\"name\":\"Mark Needham\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e\"},\"headline\":\"Python: Converting WordPress posts in CSV format\",\"datePublished\":\"2015-07-24T09:15:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/\"},\"wordCount\":346,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/\",\"name\":\"Python: Converting WordPress posts in CSV format - Web Code Geeks - 2026\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"datePublished\":\"2015-07-24T09:15:17+00:00\",\"description\":\"Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webcodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python\",\"item\":\"https:\/\/www.webcodegeeks.com\/category\/python\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Python: Converting WordPress posts in CSV format\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"name\":\"Web Code Geeks\",\"description\":\"Web Developers Resource Center\",\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webcodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webcodegeeks\",\"https:\/\/x.com\/webcodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e\",\"name\":\"Mark Needham\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g\",\"caption\":\"Mark Needham\"},\"sameAs\":[\"http:\/\/www.markhneedham.com\/blog\/\"],\"url\":\"https:\/\/www.webcodegeeks.com\/author\/mark-needham\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python: Converting WordPress posts in CSV format - Web Code Geeks - 2026","description":"Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some","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:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/","og_locale":"en_US","og_type":"article","og_title":"Python: Converting WordPress posts in CSV format - Web Code Geeks - 2026","og_description":"Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some","og_url":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/","og_site_name":"Web Code Geeks","article_publisher":"https:\/\/www.facebook.com\/webcodegeeks","article_published_time":"2015-07-24T09:15:17+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","type":"image\/jpeg"}],"author":"Mark Needham","twitter_card":"summary_large_image","twitter_creator":"@webcodegeeks","twitter_site":"@webcodegeeks","twitter_misc":{"Written by":"Mark Needham","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#article","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/"},"author":{"name":"Mark Needham","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e"},"headline":"Python: Converting WordPress posts in CSV format","datePublished":"2015-07-24T09:15:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/"},"wordCount":346,"commentCount":0,"publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","articleSection":["Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/","url":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/","name":"Python: Converting WordPress posts in CSV format - Web Code Geeks - 2026","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","datePublished":"2015-07-24T09:15:17+00:00","description":"Over the weekend I wanted to look into the WordPress data behind this blog (very meta!) and wanted to get the data in CSV format so I could do some","breadcrumb":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#primaryimage","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.webcodegeeks.com\/python\/python-converting-wordpress-posts-csv-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webcodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Python","item":"https:\/\/www.webcodegeeks.com\/category\/python\/"},{"@type":"ListItem","position":3,"name":"Python: Converting WordPress posts in CSV format"}]},{"@type":"WebSite","@id":"https:\/\/www.webcodegeeks.com\/#website","url":"https:\/\/www.webcodegeeks.com\/","name":"Web Code Geeks","description":"Web Developers Resource Center","publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webcodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webcodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.webcodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webcodegeeks","https:\/\/x.com\/webcodegeeks"]},{"@type":"Person","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e","name":"Mark Needham","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g","caption":"Mark Needham"},"sameAs":["http:\/\/www.markhneedham.com\/blog\/"],"url":"https:\/\/www.webcodegeeks.com\/author\/mark-needham\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/5861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/comments?post=5861"}],"version-history":[{"count":0,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/5861\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media\/1651"}],"wp:attachment":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media?parent=5861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/categories?post=5861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/tags?post=5861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}