Learn practical skills, build real-world projects, and advance your career
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df1 = pd.read_csv("datascience.csv",encoding="utf-8")
df2 = pd.read_csv("machinelearning.csv",encoding="utf-8")


df = pd.concat([df1,df2], axis=0).drop_duplicates()
df.shape
(1048, 5)
print(df)
Title Location \ 0 Data Analyst Bengaluru 1 Sr. Data Analyst Bengaluru 2 Senior Software Development Engineer in Test (... Bengaluru 3 Sr Data Analyst Bengaluru 4 Lead Engineer Bengaluru 5 Sr. Manager DSA Bengaluru 6 Sr Data Scientist Bengaluru 7 Engineer Bengaluru 8 Data Science Researcher Bengaluru 9 Data Science Analyst Bengaluru 10 Data Analyst Gurgaon 11 Data Science (Jupyter/Azure Mumbai 12 Data Science Specialist Bengaluru 13 Data Scientist – Gurgaon 14 Data Science Analyst Bengaluru 15 Data Scientist Hyderabad 16 Analyst-Data Analytics Chennai 17 Data Scientist Bengaluru 18 Data Scientist Mumbai 19 Associate Data Analyst Gurgaon 20 Quant Data Analyst Noida 21 Data Analyst I Bengaluru 22 Data Scientist Bengaluru 23 Data Science Developer Bengaluru 24 Data Scientist Chennai 25 Python Engineer Bengaluru 26 Data Science Manager (NLP, Speech Engineer) Gurgaon 27 Data Science - Intern Bengaluru 28 Data Engineer Bengaluru 29 Data Scientist: Artificial Intelligence Kolkata .. ... ... 536 Lendingkart - Telesales Role - Loan Vertical (... Ahmedabad 537 Lead Data Scientist Bengaluru 538 Software Development Engineer II Bengaluru 539 Software Engineering - Machine Learning Platfo... Bengaluru 541 Research Scientist II Chennai 542 Data Scientist Bengaluru 543 Data Scientist India 544 Data Scientist Hyderabad 545 NaN Mumbai 546 Software Engineer - JavaScript Bengaluru 547 Data Scientist Bengaluru 548 Research Data Scientist Bengaluru 549 Data Scientist Bengaluru 550 Product Owner- Machine Learning Bengaluru 551 Data Scientist Pune 552 Data Scientist Chennai 553 Product Designer ( Bengaluru 554 Lead Data Scientist Pune 555 Data Scientist Noida 556 Senior Data Analyst - Ad Tech Gurgaon 557 Senior Developer Bengaluru 558 Data Scientist Chennai 559 Data Scientist Bengaluru 560 Data Scientist Pune 561 Data Scientist India 563 Data Scientist Gurgaon 564 Data Scientist Bengaluru 567 Data Scientist Chennai 568 Devops Engineer with Security for Machine Lear... Bengaluru 569 Program Manager, Search and Sensei Noida Company Rating \ 0 Target 4.0 1 Target 4.0 2 AutoGrid None 3 Target 4.0 4 Target 4.0 5 Target 4.0 6 Target 4.0 7 Target 4.0 8 Shell 3.9 9 AIG 3.1 10 GroundTruth None 11 Accenture 3.9 12 Accenture 3.9 13 Mobileum 3.5 14 Dell 3.9 15 Neustar None 16 Verizon 3.6 17 Intuit 4.1 18 Star TV Network 3.6 19 Fidelity International 3.5 20 Barclays 3.8 21 HP Inc. 4.1 22 ExxonMobil 3.8 23 Oracle 3.5 24 Shell 3.9 25 AutoGrid None 26 UnitedHealth Group 3.4 27 zeotap None 28 GE Healthcare 3.9 29 IBM 3.7 .. ... ... 536 Lendingkart 3.9 537 Tavant technologies ltd 3.6 538 Microsoft 4.1 539 Chase None 541 Amazon 4.1 542 Altair Engineering None 543 Leoforce None 544 SoulPage IT Solutions 4.5 545 Han Digital Solution (P) Ltd. None 546 Instart Logic None 547 Tech Mahindra 3.9 548 Analytics Quotient 3.4 549 Eka Software 3.6 550 SuccessFactors None 551 Nihilent None 552 Crayon Data 4.0 553 ThoughtSpot None 554 Qualys 2.3 555 Gauge Data Solutions 3.1 556 Saavn 4.4 557 J.P. Morgan 3.9 558 Magna Infotech 2.9 559 Xebia 4.1 560 Nitor Infotech 2.4 561 DBS Bank None 563 Mobileum 3.5 564 Travash Software Solutions 4.0 567 Saaki Argus And Averil Consulting 4.3 568 SuccessFactors None 569 Adobe 4.2 Description 0 Description: About us: Target is an iconic b... 1 Description: Education/Experience: Bachelors ... 2 Description: Education/Experience: Bachelors ... 3 Description: Education/Experience: Bachelors ... 4 Description: Education/Experience: Bachelors ... 5 Description: Education/Experience: Bachelors ... 6 Description: Education/Experience: Bachelors ... 7 Description: Education/Experience: Bachelors ... 8 Description: Education/Experience: Bachelors ... 9 Description: Education/Experience: Bachelors ... 10 Description: Education/Experience: Bachelors ... 11 Description: Education/Experience: Bachelors ... 12 Description: Education/Experience: Bachelors ... 13 Description: Education/Experience: Bachelors ... 14 Description: Education/Experience: Bachelors ... 15 Description: Education/Experience: Bachelors ... 16 Description: Education/Experience: Bachelors ... 17 Description: Education/Experience: Bachelors ... 18 Description: Education/Experience: Bachelors ... 19 Description: Education/Experience: Bachelors ... 20 Description: Education/Experience: Bachelors ... 21 Description: Education/Experience: Bachelors ... 22 Description: Education/Experience: Bachelors ... 23 Description: Education/Experience: Bachelors ... 24 Description: Education/Experience: Bachelors ... 25 Description: Education/Experience: Bachelors ... 26 Description: Education/Experience: Bachelors ... 27 Description: Education/Experience: Bachelors ... 28 Description: Education/Experience: Bachelors ... 29 Description: Education/Experience: Bachelors ... .. ... 536 About the company: Aspagteq is a high-end, lea... 537 About the company: Aspagteq is a high-end, lea... 538 About the company: Aspagteq is a high-end, lea... 539 About the company: Aspagteq is a high-end, lea... 541 We're looking for highly qualified Data Scient... 542 We're looking for highly qualified Data Scient... 543 We're looking for highly qualified Data Scient... 544 We're looking for highly qualified Data Scient... 545 We're looking for highly qualified Data Scient... 546 We're looking for highly qualified Data Scient... 547 We're looking for highly qualified Data Scient... 548 We're looking for highly qualified Data Scient... 549 We're looking for highly qualified Data Scient... 550 We're looking for highly qualified Data Scient... 551 We're looking for highly qualified Data Scient... 552 We're looking for highly qualified Data Scient... 553 We're looking for highly qualified Data Scient... 554 We're looking for highly qualified Data Scient... 555 We're looking for highly qualified Data Scient... 556 We're looking for highly qualified Data Scient... 557 We're looking for highly qualified Data Scient... 558 We're looking for highly qualified Data Scient... 559 We're looking for highly qualified Data Scient... 560 We're looking for highly qualified Data Scient... 561 We're looking for highly qualified Data Scient... 563 We're looking for highly qualified Data Scient... 564 We're looking for highly qualified Data Scient... 567 We're looking for highly qualified Data Scient... 568 We're looking for highly qualified Data Scient... 569 We're looking for highly qualified Data Scient... [1048 rows x 5 columns]
#companies with top 20 highest number of job listings
counts = df.groupby("Company").count()["Title"].sort_values(ascending=False)[:20]
counts.plot("bar",figsize=(20,5))
<matplotlib.axes._subplots.AxesSubplot at 0x148a7782780>
Notebook Image
#Locations with top 10 highest number of job listings
loc_counts = df.groupby("Location").count()["Title"].sort_values(ascending=False)[:10]
loc_counts
Location
Bengaluru    384
Pune         111
Gurgaon      101
Hyderabad     96
Mumbai        74
Chennai       51
Noida         44
New Delhi     41
India         28
Ahmedabad     21
Name: Title, dtype: int64