w3resource

Pandas SQL Query: Display the details of jobs in descending sequence on job title

Pandas HR database Queries: Exercise-23 with Solution

Write a Pandas program to display the details of jobs in descending sequence on job title.

JOBS.csv

Sample Solution :

Python Code :

import pandas as pd
employees = pd.read_csv(r"EMPLOYEES.csv")
departments = pd.read_csv(r"DEPARTMENTS.csv")
job_history = pd.read_csv(r"JOB_HISTORY.csv")
jobs = pd.read_csv(r"JOBS.csv")
countries = pd.read_csv(r"COUNTRIES.csv")
regions = pd.read_csv(r"REGIONS.csv")
locations = pd.read_csv(r"LOCATIONS.csv")
print("job_id      Job ID                                min_salary  max_salary")
result = jobs.sort_values('job_title')
for index, row in result.iterrows():
    print(row['job_id'].ljust(15),row['job_title'].ljust(35),str(row['min_salary']).ljust(9),row['max_salary'])

Sample Output:

job_id      Job ID                                min_salary  max_salary
FI_ACCOUNT      Accountant                          4200      9000
AC_MGR          Accounting Manager                  8200      16000
AD_ASST         Administration Assistant            3000      6000
AD_VP           Administration Vice President       15000     30000
FI_MGR          Finance Manager                     8200      16000
HR_REP          Human Resources Representative      4000      9000
MK_MAN          Marketing Manager                   9000      15000
MK_REP          Marketing Representative            4000      9000
AD_PRES         President                           20000     40000
IT_PROG         Programmer                          4000      10000
AC_ACCOUNT      Public Accountant                   4200      9000
PR_REP          Public Relations Representative     4500      10500
PU_CLERK        Purchasing Clerk                    2500      5500
PU_MAN          Purchasing Manager                  8000      15000
SA_MAN          Sales Manager                       10000     20000
SA_REP          Sales Representative                6000      12000
SH_CLERK        Shipping Clerk                      2500      5500
ST_CLERK        Stock Clerk                         2000      5000
ST_MAN          Stock Manager                       5500      8500

Click to view the table contain:

Employees Table

Departments Table

Countries Table

Job_History Table

Jobs Table

Locations Table

Regions Table

Python Code Editor:

Structure of HR database :

HR database

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to calculate minimum, maximum and mean salary from employees file.
Next: Write a Pandas program to display the first and last name and date of joining of the employees who is either Sales Representative or Sales Man.

What is the difficulty level of this exercise?



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://198.211.115.131/python-exercises/pandas/sql/python-pandas-hr-database-queries-exercise-23.php