awesome, is there any way you can use pandas to import specific excel rows?
lets say you have a clients database and import just "name" "phone/email" and "Dob" to check for birthday? (im really new into py, sry if its a really obvious question)
sure buddy, since you already gone through my article so I'll suggest a very similar way:
open that excel file in google sheets and click on file menu then download it as .csv
Now open that .csv file with pandas and instead of comparing months and day separately you can compare DOB with today's date
DOB may contain the birth year so you have to ignore it during comparison. You can take DOB as string and the use .split() method to separate out the month, day and year
awesome, is there any way you can use pandas to import specific excel rows?
lets say you have a clients database and import just "name" "phone/email" and "Dob" to check for birthday? (im really new into py, sry if its a really obvious question)
sure buddy, since you already gone through my article so I'll suggest a very similar way:
open that excel file in
google sheetsand click onfilemenu then download it as.csvNow open that
.csvfile withpandasand instead of comparingmonthsanddayseparately you can compareDOBwithtoday's dateawesome gonna look into that. thank you!!