{"id":138534,"date":"2026-02-20T09:00:13","date_gmt":"2026-02-20T03:30:13","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=138534"},"modified":"2026-02-20T09:00:14","modified_gmt":"2026-02-20T03:30:14","slug":"skills-trend","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/","title":{"rendered":"Skills Trend"},"content":{"rendered":"\n<p>This project helps you find which data skills are trending by analysing real job listings and comparing them over time. The goal is to build a small dataset of job posts, extract skills from job descriptions, and then visualise how demand for each skill changes across months or weeks. By the end, you will have a clean, portfolio-ready project that shows both Python skills and analytical thinking.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Project Goal<\/h3>\n\n\n\n<p>Analyse job listings for roles like Data Analyst or Business Analyst and track skill trends such as Python, SQL, Excel, Power BI, Tableau, statistics, and machine learning basics across different time periods.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Define scope and collect data<\/h3>\n\n\n\n<p>Choose a role level and a time window, such as \u201clast 3 months\u201d or \u201clast 6 months.\u201d Collect 40 to 100 job listings. Save these fields in a CSV:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>job_id<\/li>\n\n\n\n<li>title<\/li>\n\n\n\n<li>company<\/li>\n\n\n\n<li>location<\/li>\n\n\n\n<li>date_posted<\/li>\n\n\n\n<li>description_text<\/li>\n\n\n\n<li>source<\/li>\n<\/ul>\n\n\n\n<p>You can collect manually (copy-paste into a sheet) or use an API or dataset if available. Manual collection is acceptable for a portfolio project because you will still analyse the data in Python.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Create a skill dictionary<\/h3>\n\n\n\n<p>Create a list of skills and keywords for matching. Example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Python: python<\/li>\n\n\n\n<li>SQL: sql, mysql, postgresql<\/li>\n\n\n\n<li>Excel: excel<\/li>\n\n\n\n<li>Power BI: power bi, powerbi<\/li>\n\n\n\n<li>Tableau: tableau<\/li>\n\n\n\n<li>Statistics: statistics, hypothesis, regression<\/li>\n\n\n\n<li>Machine learning: machine learning, sklearn, scikit-learn<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Clean and prepare the dataset<\/h3>\n\n\n\n<p>In Python:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>parse date_posted into a proper date<\/li>\n\n\n\n<li>remove duplicates<\/li>\n\n\n\n<li>standardise text (lowercase, remove extra spaces)<\/li>\n\n\n\n<li>handle missing descriptions<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Extract skills using keyword matching<\/h3>\n\n\n\n<p>For each job post, create columns like has_python, has_sql, has_excel, etc. Set the value to 1 if the keyword appears in the description, otherwise 0. Keep the matching logic simple and explain it in your README.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Build trend metrics<\/h3>\n\n\n\n<p>Group by time period (month or week) and calculate:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>total job posts per period<\/li>\n\n\n\n<li>share of jobs requiring each skill per period (percentage)<\/li>\n<\/ul>\n\n\n\n<p>This ensures your trend is not distorted when total job posts change.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 6: Visualise trends<\/h3>\n\n\n\n<p>Create charts such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>line chart showing skill share over time for top 6 skills<\/li>\n\n\n\n<li>bar chart of most demanded skills in the latest month<\/li>\n\n\n\n<li>heatmap of skill combinations (optional)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 7: Insights and deliverables<\/h3>\n\n\n\n<p>Write insights such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>top skills consistently demanded<\/li>\n\n\n\n<li>skills growing fastest<\/li>\n\n\n\n<li>skill combinations that appear together often<\/li>\n\n\n\n<li>what a learner should prioritise<\/li>\n<\/ul>\n\n\n\n<p>Deliverables:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>cleaned CSV<\/li>\n\n\n\n<li>Python notebook<\/li>\n\n\n\n<li>charts saved as images<\/li>\n\n\n\n<li>a README explaining dataset, method, and key findings<\/li>\n<\/ul>\n\n\n\n<p>This project is valuable because it demonstrates data collection, text processing, feature creation, time-based analysis, and storytelling with charts.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.vskills.in\/certification\/data-analysis-with-python-certification-course\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\" alt=\"\" class=\"wp-image-138496\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png 960w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2-300x47.png 300w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This project helps you find which data skills are trending by analysing real job listings and comparing them over time. The goal is to build a small dataset of job posts, extract skills from job descriptions, and then visualise how demand for each skill changes across months or weeks. By the end, you will have&#8230;<\/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-138534","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Skills Trend - Tutorial<\/title>\n<meta name=\"description\" content=\"This project helps you find which data skills are in trend by analysing real job listings and comparing them over time.\" \/>\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\/skills-trend\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Skills Trend - Tutorial\" \/>\n<meta property=\"og:description\" content=\"This project helps you find which data skills are in trend by analysing real job listings and comparing them over time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/\" \/>\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:30:14+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<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/\",\"name\":\"Skills Trend - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\",\"datePublished\":\"2026-02-20T03:30:13+00:00\",\"dateModified\":\"2026-02-20T03:30:14+00:00\",\"description\":\"This project helps you find which data skills are in trend by analysing real job listings and comparing them over time.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#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\/skills-trend\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Skills Trend\"}]},{\"@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":"Skills Trend - Tutorial","description":"This project helps you find which data skills are in trend by analysing real job listings and comparing them over time.","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\/skills-trend\/","og_locale":"en_US","og_type":"article","og_title":"Skills Trend - Tutorial","og_description":"This project helps you find which data skills are in trend by analysing real job listings and comparing them over time.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2026-02-20T03:30:14+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"}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/","name":"Skills Trend - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","datePublished":"2026-02-20T03:30:13+00:00","dateModified":"2026-02-20T03:30:14+00:00","description":"This project helps you find which data skills are in trend by analysing real job listings and comparing them over time.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/skills-trend\/#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\/skills-trend\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Skills Trend"}]},{"@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\/138534","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=138534"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138534\/revisions"}],"predecessor-version":[{"id":138535,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138534\/revisions\/138535"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=138534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=138534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=138534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}