w3resource

Pandas HR database: Extract first 7 records from employees file

Pandas HR database Queries: Exercise-3 with Solution

Write a Pandas program to extract first 7 records from employees file.

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("First 7 records from employees file:")
print(employees.head(7))

Sample Output:

First 7 records from employees file:
   employ_id first_name      ...      manager_id department_id
0        100     Steven      ...             NaN          90.0
1        101      Neena      ...           100.0          90.0
2        102        Lex      ...           100.0          90.0
3        103  Alexander      ...           102.0          60.0
4        104      Bruce      ...           103.0          60.0
5        105      David      ...           103.0          60.0
6        106      Valli      ...           103.0          60.0

[7 rows x 11 columns]

Equivalent SQL Syntax:

SELECT  * FROM EMPLOYEES limit 7; 

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 display all the location id from locations file.
Next: Write a Pandas program to select distinct department id from employees file.

What is the difficulty level of this exercise?



Python: Tips of the Day

Checks if the given number falls within the given range.

Example:

def tips_range(n, start, end = 0):
  return start <= n <= end if end >= start else end <= n <= start
print(tips_range(2, 4, 6))
print(tips_range(4, 8))
print(tips_range(1, 3, 5))
print(tips_range(1, 3))

Output:

False
True
False
True