Python Forum

Python Forum > Python Coding > General Coding Help > datetime.date() - TypeError: an integer is required (got type str)
Full Version: datetime.date() - TypeError: an integer is required (got type str)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

bisoftware

Jan-30-2018, 02:17 PM
If I just want to print out the last day of every month from 2014 through 2017 I can do that no problem with the following code:

import arcpy
import datetime 
from datetime import timedelta
import time

def last_day_of_month(any_day):
    next_month = any_day.replace(day=28) + datetime.timedelta(days=4)
    return next_month - datetime.timedelta(days=next_month.day)
for year in range(2014,2018):
    for month in range(1, 13):
        print (last_day_of_month(datetime.date(year, month, 1)))
But when I try and use it in an "if" statement then it wants me to turn "month" from a string into an integer 
Error:
TypeError: an integer is required (got type str)
.



Here is the "if" statement:

if last_day_of_month(datetime.date(year, month, 1)) >= row[3].date():
                            arcpy.FeatureClassToFeatureClass_conversion(inFeatures, outLocation, outFeatureClass, expression)





Why does it not care that "month" is a string in the "print" statement, but it does with the "if" statement?

buran

Jan-30-2018, 02:20 PM
what is your question? This snippet works for me.

bisoftware

Jan-30-2018, 02:31 PM
@buran I have updated my question. Thanks for the advice. I'm new to the forum

buran

Jan-30-2018, 02:33 PM
Please, post the full traceback, not just the last line as well as the full code snippet

bisoftware

Jan-30-2018, 02:38 PM
Full Code:
import arcpy
import datetime 
from datetime import timedelta
import time
import calendar
from calendar import monthrange

#Document Start Time in-order to calculate Run Time
time1 = time.clock()

# Set environment settings
arcpy.env.workspace = r"C:\arcGIS_Shared\Python\CenterHeatMaps.gdb"

#Declare variables
fc = 'Open_GoHealth_Centers'
fields = ['USER_market_id','USER_GoHealth_ID','USER_GoHealth_Center_Name', 'USER_Opening_Date']
fieldname = 'USER_market_id'

#Define WHERE clause statement
whereclause = """{} = 2000""".format(arcpy.AddFieldDelimiters(fc, fieldname))
sqlclause = (None, 'Order By USER_market_id, USER_GoHealth_ID')

# loop through months
years = [2014, 2015, 2016, 2017]
months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']


#returns last day of each month
def last_day_of_month(any_day):
    next_month = any_day.replace(day=28) + datetime.timedelta(days=4)
    return next_month - datetime.timedelta(days=next_month.day)
for year in range(2014,2018):
    for month in range(1, 13):
        #print (last_day_of_month(datetime.date(year, month, 1)))

        for year in years:
            for month in months:
                with arcpy.da.SearchCursor(in_table = fc, field_names = fields, where_clause=whereclause, sql_clause=(None, 'ORDER BY USER_market_id, USER_GoHealth_ID')) as cursor:
            #Loop through each row established in cursor
                    for row in (cursor):
                # Set local variables for FeatureClasstoFeatureClass
                        inFeatures = "PatientVisitsGeocoded"
                        outLocation = r"C:\arcGIS_Shared\Python\CenterHeatMaps.gdb"
                        outFeatureClass = "Date{2}{3}_NWPatientVisits{0}{1}".format(row[0], row[2], month, year)
                        delimitedfield = arcpy.AddFieldDelimiters(arcpy.env.workspace,"USER_CenterID")

                        expression = """{0} = {1} AND USER_DOSMonth = '{2}' AND USER_DOSYear = {3}""".format(delimitedfield, row[1], month, year)
                
    
#               Execute FeatureClassToFeatureClass
                        if last_day_of_month(datetime.date(year, month, 1)) >= row[3].date():
                            arcpy.FeatureClassToFeatureClass_conversion(inFeatures, outLocation, outFeatureClass, expression)
    
                #Print Results
                            print(row[2])
                            count = arcpy.GetMessageCount()
                            print (arcpy.GetMessage(count-1)) 
    
#Document End Time
time2 = time.clock()

#Run Time in seconds
runtime = (time2-time1)

print (str(timedelta(seconds=runtime)))
Full Traceback:
Error:
runfile('C:/arcGIS_Shared/PythonScripts/CenterHeatMapScripts/Step2_FeatureClasstoFeatureClass_Test3.py', wdir='C:/arcGIS_Shared/PythonScripts/CenterHeatMapScripts')
Traceback (most recent call last):

  File "<ipython-input-13-2d2db8c7b0f6>", line 1, in <module>
    runfile('C:/arcGIS_Shared/PythonScripts/CenterHeatMapScripts/Step2_FeatureClasstoFeatureClass_Test3.py', wdir='C:/arcGIS_Shared/PythonScripts/CenterHeatMapScripts')

  File "C:\Users\mazemar\AppData\Local\Continuum\anaconda3\lib\site-packages\spyder\utils\site\sitecustomize.py", line 710, in runfile
    execfile(filename, namespace)

  File "C:\Users\mazemar\AppData\Local\Continuum\anaconda3\lib\site-packages\spyder\utils\site\sitecustomize.py", line 101, in execfile
    exec(compile(f.read(), filename, 'exec'), namespace)

  File "C:/arcGIS_Shared/PythonScripts/CenterHeatMapScripts/Step2_FeatureClasstoFeatureClass_Test3.py", line 74, in <module>
    if last_day_of_month(datetime.date(year, month, 1)) >= row[3].date():

TypeError: an integer is required (got type str)

buran

Jan-30-2018, 02:45 PM
well, you have line33 where you iterate over months as integers from range(1,13), but after that you have line37 where you use variable month to iterate over list months. all elements in list months are str, what you expect to happen? :-) Of course it will raise TypeError...
Actually you iterate 4*12 times over elements of years list and months list because of lines 32-33
Fix lines 32-37

bisoftware

Jan-30-2018, 07:26 PM
Thanks @buran. I was able to fix it by replacing the month abbreviations in the "months" list with their number identifiers (1-12)

buran

Jan-30-2018, 08:05 PM
(Jan-30-2018, 07:26 PM)bisoftware Wrote: [ -> ]I was able to fix it by replacing the month abbreviations in the "months" list with their number identifiers (1-12)
you don't need to nest year and months loops twice. (lines 32-33 and lines 36-37).. fix this, one pair is enough, now you repeat the same checks 48 times.

see what you have now

years = [2014, 2015, 2016, 2017]
months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
for year in range(2014,2018):
    for month in range(1, 13):
        #print (last_day_of_month(datetime.date(year, month, 1)))
        for year in years:
            for month in months:
                print(year, month)
and the output is

Hide/Show
Python Forum > Python Coding > General Coding Help > datetime.date() - TypeError: an integer is required (got type str)