2024-05-19 21:18:33,169 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,175 INFO: Successfully recorded entry for habit: smoke weed
Data ingestion complete for smoke weed from ./assets\1-21-24-Smoking_Tracking_Spreadsheet.xlsx.
2024-05-19 21:18:33,177 INFO: Connected to existing database: habitrack.db
2024-05-19 21:18:33,177 INFO: Successfully checked 'habits' table exists
2024-05-19 21:18:33,177 INFO: Successfully checked 'habit_entries' table exists
2024-05-19 21:18:33,178 INFO: Habit 'smoke weed' already exists
Skipping invalid date: Days
2024-05-19 21:18:33,200 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,205 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,211 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,216 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,221 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,226 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,231 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,237 INFO: Successfully recorded entry for habit: smoke weed
2024-05-19 21:18:33,243 INFO: Successfully recorded entry for habit: smoke weed
Traceback (most recent call last):
File "C:\Users\dae\.vscode\Software\HabiTracker\habitracker\utils\ingest_spreadsheets.py", line 98, in <module>
main()
File "C:\Users\dae\.vscode\Software\HabiTracker\habitracker\utils\ingest_spreadsheets.py", line 87, in main
ingest_smokes_data(filepath, args.habit_name)
File "C:\Users\dae\.vscode\Software\HabiTracker\habitracker\utils\ingest_spreadsheets.py", line 41, in ingest_smokes_data
smokes = row[1:5].sum() # Sum the smokes from the relevant columns
^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\series.py", line 6528, in sum
return NDFrame.sum(self, axis, skipna, numeric_only, min_count, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\generic.py", line 12506, in sum
return self._min_count_stat_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\generic.py", line 12489, in _min_count_stat_function
return self._reduce(
^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\series.py", line 6457, in _reduce
return op(delegate, skipna=skipna, **kwds)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\nanops.py", line 85, in _f
return f(*args, **kwargs)
^^^^^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\nanops.py", line 404, in new_func
result = func(values, axis=axis, skipna=skipna, mask=mask, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\nanops.py", line 477, in newfunc
return func(values, axis=axis, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\pandas\core\nanops.py", line 646, in nansum
the_sum = values.sum(axis, dtype=dtype_sum)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dae\.vscode\Software\HabiTracker\.venv\Lib\site-packages\numpy\core\_methods.py", line 49, in _sum
return umr_sum(a, axis, dtype, out, keepdims, initial, where)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: unsupported operand type(s) for +: 'int' and 'str'
traceback: