/
Oxanita
/
Homework_1
Обзор
Документация
Войти
/
Oxanita
/
Homework_1
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/reading_excel.py
23 строки
627 B
Oxana-Bobrysheva
fixed lintens
31 окт 2024, 00:42
31 окт 2024, 00:42
0f8d9bb
Код
Авторство
О чём код?
from typing import Any import pandas as pd def reading_xlsx(file_name: str) -> Any: """This function allows to read data from Excel files and returns a list of dictionaries.""" transactions = [] try: df = pd.read_excel(file_name) for index, row in df.iterrows(): transactions.append(row.to_dict()) except FileNotFoundError: print(f"File {file_name} was not found.") except Exception as e: print(f"Error occurred: {e}.") return transactions if __name__ == "__main__": result = reading_xlsx("../data/transactions_excel.xlsx") print(result[:3])