I'm trying to read a file downloaded from Google Drive using Pandas, in Python. I'm running the code under Python 3.9, using Pipedream.

Using the following code:

import pandas as pd
import openpyxl

def handler(pipedream: "pipedream"):
    # Reference data from previous steps
    #print(pipedream.steps["trigger"]["context"]["id"])


    df = pd.read_excel('/tmp/file.xlsx', sheet_name='LIST_Client_2023-05-04-')

    # Return data for use in future steps
    return df

Using this file content enter image description here

I'm getting this error which seems to be related to the data? but I'm not doing anything particular.

enter image description here

0

There are 0 best solutions below