DEV Community

Cover image for Job Search API
Anuoluwapo Balogun
Anuoluwapo Balogun

Posted on

Job Search API

#welcome

The purpose of this project is to get data using api.

This is my first project using api to get data

I did this project with guidance from 365 Data Science

Link to the API Documentation I used Job Search API

Importing Necessary Libraries 

import requests
import json

url = "https://jsearch.p.rapidapi.com/search"

querystring = {"query":"Data Analyst in Lagos, Nigeria","num_pages":"1"}

headers = {
    "X-RapidAPI-Key": "374e7caff4mshbdf0dc9feaf2c44p1807dfjsn55b29ff65a00",
    "X-RapidAPI-Host": "jsearch.p.rapidapi.com"
}

response = requests.request("GET", url, headers=headers, params=querystring)

respond = response.json()
Enter fullscreen mode Exit fullscreen mode 
# View the API result

print(json.dumps(respond, indent = 4))
Enter fullscreen mode Exit fullscreen mode 
# View the api keys

respond.keys()

Output
dict_keys(['status', 'request_id', 'data'])
Enter fullscreen mode Exit fullscreen mode 
# View the data key result

print(json.dumps(respond['data'][0], indent=4))
Enter fullscreen mode Exit fullscreen mode 
# View the request_id key

respond["request_id"]

Output
'3702f9d9-3f27-4d12-9224-6040141d9d83'
Enter fullscreen mode Exit fullscreen mode

Turning data into tabular form with pandas with the api collection key (data) 

import pandas
df = pd.DataFrame(respond['data'])
df
Enter fullscreen mode Exit fullscreen mode 
# Optional
# Remove the unecessary columns

data = df.drop(columns = ["job_description", "employer_logo","employer_website", "job_id",
                         "job_posted_at_timestamp", "job_posted_at_datetime_utc", "job_latitude",
                         "job_longitude", "job_google_link","job_offer_expiration_datetime_utc","job_experience_in_place_of_education",
                          "job_min_salary", "job_max_salary","job_salary_currency",
                          "job_salary_period", "job_highlights", "job_benefits"], inplace = True)
Enter fullscreen mode Exit fullscreen mode

Transforming and saving data into a csv file format 

df.to_csv (r'data.csv', encoding = 'utf-8', index = None)

job = pd.read_csv('data.csv')

job.head()
Enter fullscreen mode Exit fullscreen mode 
# Check the data info

job.info()
Enter fullscreen mode Exit fullscreen mode

You should see your saved csv format in the file path you saved it into

Top comments (0)

Read next

hexadecimalsoftware profile image

JavaScript Events Made Easy: A Comprehensive Guide for Beginners đź’»

Hexadecimal -

gautam_kumar_d3daad738680 profile image

Shallow Copy vs. Deep Copy in JavaScript

gautam kumar -

tilakjain123 profile image

5 Must-Know Libraries to Supercharge your Frontend Development

Tilak Jain -

sindbad_x profile image

Built My First CLI Tool in Go

Sindbad_X -