w3resource

Pandas SQL Query: 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:

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?



Follow us on Facebook and Twitter for latest update.