{"id":138466,"date":"2026-02-18T16:29:12","date_gmt":"2026-02-18T10:59:12","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=138466"},"modified":"2026-02-20T09:15:44","modified_gmt":"2026-02-20T03:45:44","slug":"exercise-pandas-basics","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/","title":{"rendered":"Exercise: Pandas Basics"},"content":{"rendered":"\n

This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project. The goal is to load a dataset, explore it, make basic selections and filters, and produce a few simple summaries. Choose a small CSV dataset such as sales data, survey data, student marks, or any public dataset with at least 8 to 10 columns.<\/p>\n\n\n\n

Step 1 is loading the dataset into a DataFrame. After loading, inspect the dataset by viewing the first and last few rows, checking the number of rows and columns, and reviewing the column names. Confirm the data types and identify missing values.<\/p>\n\n\n\n

Step 2 is selecting and filtering. Select a few columns by name, and then filter rows using conditions. For example, filter for a specific region, category, or date range. Create at least two filters: one simple filter using a single condition and one filter using two conditions together.<\/p>\n\n\n\n

Step 3 is basic cleaning. Rename two columns to make them clearer, handle missing values in one column, and remove duplicate rows if they exist. Convert one column to the correct data type, such as converting a date column to datetime or a numeric column stored as text into a number.<\/p>\n\n\n\n

Step 4 is summarising the data. Calculate basic metrics such as total, mean, median, and count for key numeric columns. Then use groupby to summarise one metric by a category column, such as total sales by region or average score by class. Sort the result and identify the top 5 groups.<\/p>\n\n\n\n

Step 5 is saving outputs. Export your cleaned dataset and your summary table to new CSV files. Finally, write 5 to 6 lines explaining what you checked, what you cleaned, and what insights you found.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project. The goal is to load a dataset, explore it, make basic selections and filters, and produce a few simple summaries. Choose a small CSV dataset such as sales data, survey data, student marks, or any public dataset…<\/p>\n","protected":false},"author":21,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-138466","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nExercise: Pandas Basics - Tutorial<\/title>\n<meta name=\"description\" content=\"This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project.\" \/>\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.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exercise: Pandas Basics - Tutorial\" \/>\n<meta property=\"og:description\" content=\"This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-20T03:45:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/\",\"name\":\"Exercise: Pandas Basics - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\",\"datePublished\":\"2026-02-18T10:59:12+00:00\",\"dateModified\":\"2026-02-20T03:45:44+00:00\",\"description\":\"This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#primaryimage\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\",\"width\":960,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exercise: Pandas Basics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exercise: Pandas Basics - Tutorial","description":"This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project.","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.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/","og_locale":"en_US","og_type":"article","og_title":"Exercise: Pandas Basics - Tutorial","og_description":"This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2026-02-20T03:45:44+00:00","og_image":[{"width":960,"height":150,"url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","type":"image\/png"}],"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/","name":"Exercise: Pandas Basics - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","datePublished":"2026-02-18T10:59:12+00:00","dateModified":"2026-02-20T03:45:44+00:00","description":"This exercise helps you practise the essential Pandas skills you will use in almost every data analysis project.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#primaryimage","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","width":960,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/exercise-pandas-basics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exercise: Pandas Basics"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=138466"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138466\/revisions"}],"predecessor-version":[{"id":138570,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138466\/revisions\/138570"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=138466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=138466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=138466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}