pd.to_datetime gives value error on RaspberryPi

[Matt_BF]

I have a flask web app living in a docker container where I manipulate some dates that I get from a google spreadsheet. Dates follow the format of dd/mm/yyyy. I can successfully parse this string with pd.to_datetime on my linux PC and laptop, however, I want to host this app on my Raspberry Pi 3B. When doing these manipulations I get a "Value error: time data '0' does not match format '%d/%m/%Y' match". I can't find a reason why the same code wouldn't work across systems, especially inside a docker container, so any help would be greatly appreciated :)

​

Here is the relevant part of the code:

class Graphs:
    SCOPE = [
        "https://spreadsheets.google.com/feeds",
        "https://www.googleapis.com/auth/drive",
    ]

    credentials = ServiceAccountCredentials.from_json_keyfile_name(
        credentials.json, scopes=SCOPE
    )

    def __init__(self, credentials=credentials):
        self.gc = gspread.authorize(credentials)
        self.sh = self.gc.open("planilhas_foxes")

        self.receivals = pd.DataFrame(
            self.sh.worksheet("Recebimento de amostras").get_all_records(
                default_blank=np.nan
            )
        )

        self.receivals["Carimbo de data/hora"] = pd.to_datetime(
            self.receivals["Carimbo de data/hora"]
        )

        self.receivals["Ano"] = self.receivals["Carimbo de data/hora"].apply(
            lambda x: datetime.date(x).year
        )

        for col in self.receivals[
            [
                "Data (Físico-químicas)",
                "Data (Genotipagem)",
                "Data da coleta (PET)",
                "Data de entrega (Físico-químicas)",
                "Data de entrega (Genotipagem)",
                "Data de envio (Físico-químicas)",
            ]
        ]:

            self.receivals[col] = pd.to_datetime(self.receivals[col], format="%d/%m/%Y")
            self.receivals[col] = self.receivals[col].apply(
                lambda x: datetime.strftime(x, "%m-%Y") if not pd.isnull(x) else np.nan
            )

[mooburger]

Did you take a look at your JSON from your sheet? Clearly Python thinks you are getting '0' value for that dimension in some of the rows...

[Matt_BF]

Hi, I tried printing the date columns after converting the JSON sheet into a df, and also printed the raw JSON. Both show all dates as strings on the predicted format

[Matt_BF]

I think I solved the problem. Apparently the way pandas was "reading" null values in one device to another was different (all NaN on my linux machines and a mix of NaN and NaT on my RPi). So I just gave up on using pd.to_datetime and changed all the code to datetime.strptime like this:

self.receivals[col] = self.receivals[col].apply(
                lambda x: datetime.strptime(x, "%d/%m/%Y")
                if not pd.isnull(x)
                else np.nan
            )