Extract values from CSV file to use in python

I’m very interested in doing my own weather forecasts.
I started by getting historical data and creating a model to predict the weather with keras and python, but that should be irrelevant.
To get the current weather I’m using the OpenWeather API, that I got working even if quite painfully. I’m outputting the data “directly” to the dashboard and saving it to a CSV file.
So I would want to get this file out of HA, which is running within a proxmox VM, and into a folder that I can use python to make the forecast.
After that I would want to send the file with the forecasts into HA where I would read it and display it.
My yaml files are as follow:
automation.yaml:

- id: '1702240662555'
  trigger:
  - platform: time_pattern
    minutes: '0'
  action:
  - service: notify.write_to_csv
    data:
      message: "\n {{ states('sensor.date_time_iso')[0:4] | int }}, {{ states('sensor.date_time_iso')[5:7]|
        int }}, {{ states('sensor.date_time_iso')[8:10] | int }}, {{ states('sensor.date_time_iso')[11:13]|
        int }}, {{ states('sensor.current_temperature') | float }}, {{ states('sensor.current_pressure')|
        float }}, {{ states('sensor.current_wind_speed') | float }}, {{ states('sensor.current_wind_direction_val')|
        int }}, {{ states('sensor.current_humidity') | int }}, {{ states('sensor.current_percipitation')|
        float }}"
- id: '1702240662556'
  trigger:
  - platform: time_pattern
    minutes: '59'
  - platform: time_pattern
    minutes: '44'
  - platform: time_pattern
    minutes: '29'
  - platform: time_pattern
    minutes: '14'
  action:
  - service: homeassistant.update_entity
    target:
      entity_id:
      - sensor.current_humidity
      - sensor.current_percipitation
      - sensor.current_pressure
      - sensor.current_temperature
      - sensor.current_wind_direction
      - sensor.current_wind_direction_val
      - sensor.current_wind_speed
    data: {}

The sensors in sensor.yaml look like:

- platform: rest
  resource: https://api.openweathermap.org/data/2.5/weather?lat=LATITUDE&lon=LONGITUDE&units=metric&appid=APIKEY
  method: GET
  name: "Current Temperature"
  value_template: '{{ (value_json["main"]["temp"] | float ) }}'
  unit_of_measurement: 'ºC'
  scan_interval: 36000

The config.yaml:

# Loads default set of integrations. Do not remove.
default_config:

# Load frontend themes from the themes folder
frontend:
  themes: !include_dir_merge_named themes

automation: !include automations.yaml
script: !include scripts.yaml
scene: !include scenes.yaml

switch:
  - platform: virtual
    name: Switch 1
    initial_availability: True

input_button:
  study_night:
    name: Study Night
    icon: mdi:account-school-outline
  study_day:
    name: Study Day
    icon: mdi:account-school
  relax:
    name: Relax
    icon: mdi:glass-mug-variant
  turn_off:
    name: Turn Off
    icon: mdi:alarm-light-off
  party:
    name: Party
    icon: mdi:party-popper

sensor: !include sensors.yaml

homeassistant:
  allowlist_external_dirs:
    - "/config"
    - "/config/data_stuff"

notify:
  - name: write_to_csv
    platform: file
    filename: /config/data_stuff/data.csv

logger:
  default: info
  logs:
    homeassistant.components.automation: debug

template:
  - sensor:
      - name: "Date and time"
        state: "{{ as_timestamp(states('sensor.date_time_iso')) | timestamp_custom('%A %B %-d, %I:%M %p') }}"
        icon: "mdi:calendar-clock"

And finally the CSV file looks like this:

Year,Month,Day,Hour,Temperature,Surface Pressure,Wind Speed,Wind Direction,Relative Humidity,Percipitation
2024, 7, 6, 19, 19.53, 100.6, 53.712, 340, 61, 0.0

Any help would be apreciated!