"yearBorn":1919,"yearDied":1987}

data = data.to_json(orient='records')

"yearBorn":1919.0,"yearDied":1987.0}

import requests
import xlrd
import json
import csv
import pandas as pd
from pandas.io.json import json_normalize

apicounter = 1
xls = pd.ExcelFile('data.xlsx')
local_materials = xls.parse(xls.sheet_names[0])
local_materials = pd.DataFrame(local_materials)
row_count = local_materials.shape[0]
data = local_materials.loc[local_materials['id'] == apicounter]
data = data.to_json(orient='records')