🔒 Incosistency with pandas | Python | Page 1

edgy wedge May 23, 2024, 8:27 AM

#

I get this error when changing file names, although nothing has changed in the files as far as I know

proper gyroBOT May 23, 2024, 8:27 AM

#

edgy wedge I get this error when changing file names, although nothing has changed in the f...

#

@edgy wedge

Python help channel opened

Remember to:

Ask your Python question, not if you can ask or if there's an expert who can help.
Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

edgy wedge May 23, 2024, 8:27 AM

#

Code:

haPreviousDataFile = 'Data/HA_20052024.xlsx'
haCurrentDataFile = 'Data/HA_23052024.xlsx'
i = 0


file1 = pd.read_excel(haPreviousDataFile,
                       sheet_name=0,
                        header=0,
                        index_col=False,
                        keep_default_na=True
                            )


file2 = pd.read_excel(haCurrentDataFile,
                      sheet_name=0,
                      header=0,
                      index_col=False,
                      keep_default_na=True)

endFile1 = len(file1)
endFile2 = len(file2)

file1 = file1[~file1['Reservation ID'].isin(file2['Reservation ID'])] * 0

fileName1 = 'HA_20052024UPDATE.xlsx'
fileName2 = 'HA_23052024.xlsx'

file1.to_excel(fileName1)
file2.to_excel(fileName2)```

#

previous rendition of code

#

haPreviousDataFile = 'Data/HA_19052024.xlsx'
haCurrentDataFile = 'Data/HA_20052024.xlsx'
i = 0


file1 = pd.read_excel(haPreviousDataFile,
                       sheet_name=0,
                        header=0,
                        index_col=False,
                        keep_default_na=True
                            )


file2 = pd.read_excel(haCurrentDataFile,
                      sheet_name=0,
                      header=0,
                      index_col=False,
                      keep_default_na=True)

endFile1 = len(file1)
endFile2 = len(file2)

file1 = file1[~file1['Reservation ID'].isin(file2['Reservation ID'])] * 0

fileName1 = 'HA_19052024UPDATE.xlsx'
fileName2 = 'HA_20052024.xlsx'

file1.to_excel(fileName1)
file2.to_excel(fileName2)```

fair glade May 23, 2024, 9:06 AM

#

edgy wedge I get this error when changing file names, although nothing has changed in the f...

send the entire traceback

edgy wedge May 23, 2024, 9:06 AM

#

alright

#

  File "c:\Users\Kurasperry\Documents\Keyview Prograns\HostAway\main.py", line 26, in <module>
    file1 = file1[~file1['Reservation ID'].isin(file2['Reservation ID'])] * 0```

fair glade May 23, 2024, 9:07 AM

#

why are you multiplying it by 0?

edgy wedge May 23, 2024, 9:07 AM

#

it sets the bool to false

#

which then removes all the data

#

in the series

hard yew May 23, 2024, 9:08 AM

#

nice dp

edgy wedge May 23, 2024, 9:09 AM

#

ong

fair glade May 23, 2024, 9:09 AM

#

huh

#

well somehow it seems like it's implicitly converting the data to datetime

hard yew May 23, 2024, 9:10 AM

#

if you multiply by 0 then doesnt the file1 become another datatype rather than a dataframe

fair glade May 23, 2024, 9:10 AM

#

no

hard yew May 23, 2024, 9:11 AM

#

ok

edgy wedge May 23, 2024, 9:12 AM

#

fair glade well somehow it seems like it's implicitly converting the data to datetime

pandas is weird

fair glade May 23, 2024, 9:12 AM

#

so the goal of file1[~file1['Reservation ID'].isin(file2['Reservation ID'])] * 0 is to effectively remove a column's data?

edgy wedge May 23, 2024, 9:12 AM

#

fair glade so the goal of `file1[~file1['Reservation ID'].isin(file2['Reservation ID'])] * ...

yes

#

forcing pandas to loop through the dataframe instead of doing it manually\

fair glade May 23, 2024, 9:13 AM

#

you can just drop columns though why multiply by 0

edgy wedge May 23, 2024, 9:13 AM

#

how would that look

hard yew May 23, 2024, 9:13 AM

#

in this case you are multiplying the whole dataframe by 0 not just that one column

edgy wedge May 23, 2024, 9:13 AM

#

hard yew in this case you are multiplying the whole dataframe by 0 not just that one colu...

that's the idea

#

if the res ID is found in file2 the entire record should be removed

hard yew May 23, 2024, 9:14 AM

#

ohoo

#

then * 0 is not needed

#

ig

fair glade May 23, 2024, 9:14 AM

#

edgy wedge how would that look

!e

import pandas as pd

a = pd.DataFrame({'a':[1,2,3,4], 'b':[5,6,7,8]})
print(a)
a = a.drop(columns='b')
print(a)

proper gyroBOT May 23, 2024, 9:14 AM

#

fair glade !e ```py import pandas as pd a = pd.DataFrame({'a':[1,2,3,4], 'b':[5,6,7,8]}) p...

:white_check_mark: Your 3.12 eval job has completed with return code 0.

001 |    a  b
002 | 0  1  5
003 | 1  2  6
004 | 2  3  7
005 | 3  4  8
006 |    a
007 | 0  1
008 | 1  2
009 | 2  3
010 | 3  4

edgy wedge May 23, 2024, 9:15 AM

#

so basically

#

do the check

#

throw into a new variable

#

im stupid

hard yew May 23, 2024, 9:16 AM

#

file1 = file1[~file1['Reservation ID'].isin(file2['Reservation ID'])]

this alone returns the remaining values that are not in file2

fair glade May 23, 2024, 9:16 AM

#

file1[~file1['Reservation ID'].isin(file2['Reservation ID'])] this filters all the records by itself

edgy wedge May 23, 2024, 9:16 AM

#

in a series?

#

then just drop according to the series

fair glade May 23, 2024, 9:16 AM

#

just drop from the result of that

hard yew May 23, 2024, 9:16 AM

#

no a dataframe

#

file1[~file1['Reservation ID'].isin(file2['Reservation ID'])]

this returns a dataframe

edgy wedge May 23, 2024, 9:18 AM

#

and it works

#

thankies

hard yew May 23, 2024, 9:19 AM

#

🙂

edgy wedge May 23, 2024, 9:19 AM

#

!close

proper gyroBOT May 23, 2024, 9:19 AM

#

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.

#🔒 Incosistency with pandas