Employees Sample Data (CSV and JSON)

Updated: August 4, 2023 By: Goodman Post a comment

This article brings to the table sample data of employees in an imaginary software company for the purposes of learning, practicing, or testing software. The data will be in CSV and JSON format for you to choose from.

Table Of Contents

1 employees.csv

2 employees.json

3 Limitation

employees.csv

Below is the URL of the employees.csv file:

https://api.slingacademy.com/v1/sample-data/files/employees.csv

It has the following fields:

First Name
Last Name
Email

Phone
Gender
Age

Job Title
Years Of Experience
Salary

Department

You can download the file to your local computer or read it programmatically with your favorite programming language like Python, Javascript, etc.

Here’s an example of how to do so with pandas (Python):

import pandas as pd

import ssl
ssl._create_default_https_context = ssl._create_unverified_context

file_path = 'https://api.slingacademy.com/v1/sample-data/files/employees.csv'
dataframe = pd.read_csv(file_path, storage_options={
                        'User-Agent': 'Mozilla/5.0'})

print(dataframe.head())
print(dataframe.describe())

Output:

  First Name Last Name  ... Salary Department
0       Jose     Lopez  ...   8500    Product
1      Diane    Carter  ...   7000    Product
2      Shawn    Foster  ...  17000    Product
3     Brenda    Fisher  ...  10000    Product
4       Sean    Hunter  ...  14500    Product

[5 rows x 10 columns]
              Age  Years Of Experience        Salary
count  320.000000           320.000000    320.000000
mean    31.587500             7.687500  10175.000000
std      4.607323             4.428729   2615.483196
min     23.000000             1.000000   5500.000000
25%     28.000000             4.000000   8000.000000
50%     32.000000             7.500000  10000.000000
75%     35.000000            12.000000  12000.000000
max     41.000000            15.000000  17000.000000

employees.json

You can download or send a GET request to our employees.json file at the URL below:

https://api.slingacademy.com/v1/sample-data/files/employees.json

The content of the file will look like this:

[
  {
    "id": 1,
    "first_name": "Jose",
    "last_name": "Lopez",
    "email": "[email protected]",
    "phone": "+1-971-533-4552x1542",
    "gender": "male",
    "age": 25,
    "job_title": "Project Manager",
    "years_of_experience": 1,
    "salary": 8500,
    "department": "Product"
  },
  // other employees
]

Let us know what you think about this dataset in the comments.