{"id":3880,"date":"2024-04-04T15:20:32","date_gmt":"2024-04-04T15:20:32","guid":{"rendered":"http:\/\/van-maanen.com\/?p=3880"},"modified":"2024-04-04T15:20:32","modified_gmt":"2024-04-04T15:20:32","slug":"reading-a-csv-file-and-translate-into-dataframe","status":"publish","type":"post","link":"http:\/\/van-maanen.com\/?p=3880","title":{"rendered":"Reading a CSV file and translate into dataframe"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Below, a script is provided that reads a CSV file and translate the outcome into a dataframe:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">import csv\nimport pandas as pd\n\nwith open(r\"C:\\Users\\tomva\\SynologyDrive\\python\\pandas\\Incomplete\\banking.csv\",\"r\") as csv_file:\n    csv_reader = csv.reader(csv_file, delimiter = ',')\n    print(type(csv_reader))\n    df = pd.DataFrame()  \n    i = 0\n    for row in csv_reader:\n        if i == 0:\n            cols = row\n        if i > 0:\n            for j in range(len(row)):\n                df.loc[i, j] = row[j]\n        if i%1000 == 0:\n            print(i)\n        i = i + 1\n    print(cols)\n    df = df.rename(columns={0: 'age', 1: 'job', 2: 'marital', 3: 'education', 4: 'default', 5: 'housing', 6: 'loan', 7: 'contact', 8: 'month', 9: 'day_of_week', 10: 'duration', 11: 'campaign', 12: 'pdays', 13: 'previous', 14: 'poutcome', 15: 'emp_var_rate', 16: 'cons_price_idx', 17: 'cons_conf_idx', 18: 'euribor3m', 19: 'nr_employed', 20: 'y'})    \n    df.info()\nprint('********* Klaar ********************')\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Below, a script is provided that reads a CSV file and translate the outcome into a dataframe: import csv import pandas as pd with open(r&#8221;C:\\Users\\tomva\\SynologyDrive\\python\\pandas\\Incomplete\\banking.csv&#8221;,&#8221;r&#8221;) as csv_file: csv_reader = csv.reader(csv_file, delimiter = &#8216;,&#8217;) print(type(csv_reader)) df = pd.DataFrame() i = 0 for row in csv_reader: if i == 0: cols = row if i > 0: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-3880","post","type-post","status-publish","format-standard","hentry","category-niet-gecategoriseerd"],"_links":{"self":[{"href":"http:\/\/van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3880"}],"version-history":[{"count":0,"href":"http:\/\/van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3880\/revisions"}],"wp:attachment":[{"href":"http:\/\/van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3880"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}