TypeError: ожидаемая строка, байты или объект os.PathLike, а не NoneType в Python ⇐ Python

[Anonymous]

Я пытаюсь прочитать файл csv из папки C:\Users\Downloads\etc.csv и пытаюсь создать файлы Excel в папке C:\Users\Downloads\CHECKS07112024. Он создает папку C:\Users\Downloads\CHECKS07112024, но затем произошел сбой с ошибкой в ​​строке os.path.dirname(output_path) как:
TypeError: expected str, bytes or os.PathLike object, not NoneType

Ниже приведен мой код Python:
import pandas as pd
import csv
import os
import warnings
import base64
from datetime import datetime

csv_file_path = r'C:\Users\Downloads\etc.csv' # Path to your local CSV file

now = datetime.now()
now_str = now.strftime("%m-%d-%Y")
temp_path=r'C:\Users\Downloads\CHECKS' + now_str
output_path= os.makedirs(temp_path, exist_ok = True)

output_directory = os.path.dirname(output_path)

with open(csv_file_path, mode='r', encoding='utf-8-sig') as file:
reader = csv.reader(file)
queries = [(row[0], row[1]) for row in reader if row] # Skip empty rows

# Execute each query and save results to separate Excel files
for i, (query, filename) in enumerate(queries):
try:
# Execute the query using SQLAlchemy engine
df = pd.read_sql(query, engine)

# Define the output Excel file name
output_file = os.path.join(output_directory, f'{filename}.xlsx')

# Save the DataFrame to an Excel file
df.to_excel(output_file, index=False)
print(f'Saved results of query {i + 1} to {output_file}')


Подробнее здесь: https://stackoverflow.com/questions/791 ... -in-python