{"id":12478,"date":"2022-09-30T21:51:11","date_gmt":"2022-09-30T16:21:11","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/"},"modified":"2022-09-30T21:51:11","modified_gmt":"2022-09-30T16:21:11","slug":"solved-i-have-developed-the-program-and-i-am-facing-problems-in-it","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/","title":{"rendered":"[Solved] i have developed the program and i am facing problems in it"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-46252267\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"46252267\" data-parentid=\"46243613\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>You can try to  pivot the table. Which may give the format you require. <\/p>\n<p>Considering the information you gave as as <code>ActionsOnly.csv<\/code><\/p>\n<pre><code>userId,movieId,rating\n18,9,3\n32,204,4\n49,2817,1\n62,160438,4\n70,667,5\n73,1599,1\n73,4441,3\n73,4614,3.5\n73,86142,4\n95,4636,2\n103,71,1\n118,3769,4\n150,4866,2\n<\/code><\/pre>\n<p>You wan to find out what user rated what movie out of 5.<\/p>\n<p>The <code>userId<\/code> is the index column, the <code>movieId<\/code> becomes the header row and the <code>rating<\/code> is what decides the values. If there is no Value it will display <code>NaN<\/code> or <code>Not A Number<\/code><\/p>\n<pre><code>movie_pivot = movie.pivot_table(index='userId', columns=\"movieId\", values=\"rating\")\n<\/code><\/pre>\n<p>To Save a file in Pandas to CSV there is a simple command <code>to_csv<\/code><\/p>\n<p>so<\/p>\n<pre><code>movie_pivot.to_csv('ActionsOnly_pivot.csv')\n<\/code><\/pre>\n<p>Will save to csv.<\/p>\n<p>So the full code you need is:<\/p>\n<pre><code>import pandas as pd\n\nmovie = pd.read_csv('movies.csv')\n\nmovie_pivot = movie.pivot_table(index='userId', columns=\"movieId\", values=\"rating\")\n\nmovie_pivot.to_csv('movies_pivot.csv')\n<\/code><\/pre>\n<p>I also strongly recommend reading about pandas, It is surprisingly easy and logical \ud83d\ude42<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">5<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved i have developed the program and i am facing problems in it <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] You can try to pivot the table. Which may give the format you require. Considering the information you gave as as ActionsOnly.csv userId,movieId,rating 18,9,3 32,204,4 49,2817,1 62,160438,4 70,667,5 73,1599,1 73,4441,3 73,4614,3.5 73,86142,4 95,4636,2 103,71,1 118,3769,4 150,4866,2 You wan to find out what user rated what movie out of 5. The userId is the index &#8230; <a title=\"[Solved] i have developed the program and i am facing problems in it\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\" aria-label=\"More on [Solved] i have developed the program and i am facing problems in it\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[483,415,349],"class_list":["post-12478","post","type-post","status-publish","format-standard","hentry","category-solved","tag-csv","tag-pandas","tag-python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] i have developed the program and i am facing problems in it - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] i have developed the program and i am facing problems in it - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You can try to pivot the table. Which may give the format you require. Considering the information you gave as as ActionsOnly.csv userId,movieId,rating 18,9,3 32,204,4 49,2817,1 62,160438,4 70,667,5 73,1599,1 73,4441,3 73,4614,3.5 73,86142,4 95,4636,2 103,71,1 118,3769,4 150,4866,2 You wan to find out what user rated what movie out of 5. The userId is the index ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-30T16:21:11+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] i have developed the program and i am facing problems in it\",\"datePublished\":\"2022-09-30T16:21:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\"},\"wordCount\":125,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"csv\",\"pandas\",\"python\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\",\"name\":\"[Solved] i have developed the program and i am facing problems in it - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-30T16:21:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] i have developed the program and i am facing problems in it\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] i have developed the program and i am facing problems in it - JassWeb","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:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] i have developed the program and i am facing problems in it - JassWeb","og_description":"[ad_1] You can try to pivot the table. Which may give the format you require. Considering the information you gave as as ActionsOnly.csv userId,movieId,rating 18,9,3 32,204,4 49,2817,1 62,160438,4 70,667,5 73,1599,1 73,4441,3 73,4614,3.5 73,86142,4 95,4636,2 103,71,1 118,3769,4 150,4866,2 You wan to find out what user rated what movie out of 5. The userId is the index ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/","og_site_name":"JassWeb","article_published_time":"2022-09-30T16:21:11+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] i have developed the program and i am facing problems in it","datePublished":"2022-09-30T16:21:11+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/"},"wordCount":125,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["csv","pandas","python"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/","url":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/","name":"[Solved] i have developed the program and i am facing problems in it - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-30T16:21:11+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-i-have-developed-the-program-and-i-am-facing-problems-in-it\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] i have developed the program and i am facing problems in it"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=12478"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12478\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=12478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=12478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=12478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}