Pandas SQL Query: Extract first 7 records from employees file

Last update on May 03 2025 13:10:02 (UTC/GMT +8 hours)

3. Extract First 7 Records from EMPLOYEES File

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

EMPLOYEES.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("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:

For more Practice: Solve these Related Problems:

Write a Pandas program to extract the first 7 records from EMPLOYEES.csv using the head() function.
Write a Pandas program to extract the first 7 records by slicing the DataFrame and then display them.
Write a Pandas program to extract the first 7 records after sorting EMPLOYEES.csv by joining date.
Write a Pandas program to extract the first 7 records from EMPLOYEES.csv where salary exceeds a given threshold.

Go to:

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.

Python Code Editor:

Structure of HR database :

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