ianrussel

[
    {
        "id": "18003908996754290",
        "caption": "Your Easter weekend starts today, and so does ours. \ud83d\ude09 \n\nB&F offices will be closed today and on Monday 21 April. We\u2019ll be back on Tuesday at 8:00am to handle all your paper needs. \n\nMeanwhile, enjoy your Easter break in whatever ways matters to you. \n\n#bfpapers #easter #eastereggs #easterholiday",
        "media_type": "IMAGE",
        "media_url": "https://scontent-hkg1-2.cdninstagram.com/v/t39.30808-6/487851105_1243471344450243_8375694778426906295_n.jpg?stp=dst-jpg_e35_tt6&_nc_cat=107&ccb=1-7&_nc_sid=18de74&_nc_ohc=luaGAxwRd1QQ7kNvwGmcTY0&_nc_oc=AdmGCFeSNsW0ajoFPmjNuHtQfq-v2VuqUuhsFLLTdd__HRL7_PFA0RKwgpD7kD5TgIo&_nc_zt=23&_nc_ht=scontent-hkg1-2.cdninstagram.com&edm=ANo9K5cEAAAA&_nc_gid=UH1oCiLTyP8Yq6cHXXwzuQ&oh=00_AfEVPfxgKmpOpxHbXEe4YqqsbqQIa91H9fYq2BwkP_e_xA&oe=680E4B7B",
        "timestamp": "2025-04-17T22:00:07+0000",
        "permalink": "https://www.instagram.com/p/DIkEwsjpmMM/"
    },
    {

ianrussel

{
    "person": {
        "id": "3c7e0051-751c-4563-9f4b-a89d35189be2",
        "firstname": "Jane",
        "lastname": "Doe",
        "email": "[email protected]",
        "phone": null,
        "status": true,
        "type": "person",
        "photo": "df401229-76dd-4ee9-85a0-be84565c8af8",

ianrussel

<div id="baseModal" class="modal fade" data-backdrop="static" data-keyboard="false" tabindex="-1"
aria-labelledby="staticBackdropLabel" aria-hidden="true">
   <div class="modal-dialog">
        <div class="modal-content rounded-4" style="background-color: black;">
            <div class="modal-body p-4">
                <div class="row">
                    <div class="col-3">
                        <div class="card-body d-flex align-items-center justify-content-between">
                            <img src="/static/img/B_F_icon.png">
                        </div>

ianrussel

[
    {
        "timesheet_employee_number":50142,
        "gusto_uuid":"a1d470c4-5f2e-4d8f-ae44-2cf3ddb97425",
        "firstname":"Carol",
        "lastname":"Canipe",
        "payment_unit":"Week"
    },
    {

ianrussel

{
    "employee_compensations": [
        {
            "excluded": false,
            "payment_method": "Direct Deposit",
            "memo": null,
            "fixed_compensations": [],
            "hourly_compensations": [
                {
                    "compensation_multiplier": 1.5,

ianrussel

{
    "errors": [],
    "processing": {
        "writetostorage": "false",
        "queued": "false",
        "reportuuid": ""
    },
    "report": {
        "IncludeExtendedData": "true",
        "StartDate": "June, 16 2024 00:00:00",

ianrussel

{
    "data": {
        "error": false,
        "response": {
            "errors": [],
            "processing": {
                "queued": "false",
                "reportuuid": "",
                "writetostorage": "false"
            },

ianrussel

{
    "warnings": {},
    "errors": [],
    "report": {
        "RoundToNearest": "0",
        "TotalStandardHours": "0.00",
        "TotalStandardRecordsSplit": "0",
        "TotalPTOHours": "0.00",
        "RecordsExceedingMaxHoursThreshold": "0",
        "OverlappingPeriodsAction": "IGNORE",

ianrussel

{
    "errors": [],
    "processing": {
        "writetostorage": "false",
        "queued": "false",
        "reportuuid": ""
    },
    "report": {
        "TOTALREPORTVARIABLEPAY": "14632.58",
        "IncludedAccountCodes": [

ianrussel

import pandas as pd
import json
import numpy as np


df = pd.read_excel('Analyzer Test Task.xlsx')

# Convert NaN values to None
df = df.replace("", None)
df = df.replace(r'^\s*$', "", regex=True)