Currency Conversion Script with pandas and forex-python
This Python script performs currency conversion on an Excel file containing sales data. It utilizes the powerful data manipulation library, pandas, to handle Excel data and the forex-python library to fetch daily updated exchange rates. The converted data is then saved to a new Excel file using openpyxl.
- Converts currency values from Krone (CZK) to Euro (EUR) based on daily exchange rates
- Uses pandas for efficient data manipulation
- Retrieves exchange rates from forex-python
- Saves the results to a new Excel file with openpyxl
- Python 3.x
- pandas==<2.1.3>
- forex-python==<1.6>
- openpyxl==<3.1.2>
- Install the required packages:
pip install -r requirements.txt
- Run the script:
python currency_conversion_script.py