variable problem in python function, is not defined

Question

I am currently working with Python on Azure Databricks. Recently the cluster you are working in had an update and now my solution does not run correctly. Precisely the error I have today is:

NameError: ("name 'ajuste_fecha' is not defined", 'occurred at index 0')

The code is the following:

from pyspark.sql.types import *
from pyspark.sql.functions import *
import pandas as pd
import datetime
# from datetime import datetime  
from pyspark.sql import SQLContext
import json
import re
import requests
from pandas.io.json import json_normalize
import json
import os
from os import listdir
from os.path import isfile, join
import io

def f_ajuste_fecha(fecha):
  global ajuste_fecha
  if fecha[0:3] == "Ene" :
    ajuste_fecha = "01"
  elif fecha[0:3] == "Feb" :
    ajuste_fecha = "02"
  elif fecha[0:3] == "Mar" :
    ajuste_fecha = "03"
  elif fecha[0:3] == "Abr" :
    ajuste_fecha = "04"
  elif fecha[0:3] == "May" :
    ajuste_fecha = "05"
  elif fecha[0:3] == "Jun" :
    ajuste_fecha = "06"
  elif fecha[0:3] == "Jul" :
    ajuste_fecha = "07"
  elif fecha[0:3] == "Ago" :
    ajuste_fecha = "08"
  elif fecha[0:3] == "Sep" :
    ajuste_fecha = "09"
  elif fecha[0:3] == "Oct" :
    ajuste_fecha = "10"
  elif fecha[0:3] == "Nov" :
    ajuste_fecha = "11"
  elif fecha[0:3] == "Dic" :
    ajuste_fecha = "12"
  return ajuste_fecha

res = requests.get("https://estadisticas.bcrp.gob.pe/estadisticas/series/api/PD04637PD/csv/")
df = pd.read_csv(io.StringIO(res.text.strip().replace("<br>","\n")), engine='python')

df.rename(columns={'Tipo de cambio - TC Interbancario (S/ por US$) - Compra':'valor'} , inplace=True)
df.rename(columns={'D&iacute;a/Mes/A&ntilde;o':'fecha'} , inplace=True)

df['periodo_temp'] = df.apply(lambda x : x['fecha'][3:9],axis=1)
df['periodo_temp_2'] = df.apply(lambda x : '20' +  x['fecha'][7:9] + '-' + f_ajuste_fecha(x['periodo_temp'][0:3])  + '-' + x['fecha'][0:2] ,axis=1)


df['periodo'] = pd.to_datetime(df['periodo_temp_2'], format='%Y-%m-%d')

df_temp = df[df['periodo'] == df['periodo'].max()]
df_2 = df_temp[['periodo', 'valor']]
df_dolar = df_2
df_dolar

As I mentioned, previously I did not have this problem. I have tried instances ajuste_fecha = '' outside of the function, but it is not successful either.

What am I doing wrong? What is it due to?

Thank you very much in advance, I will be attentive to your answers.

greetings!!

why don't chage your func f_ajuste_fecha to a dict map first? — 辜乘风
– 辜乘风, Commented Oct 21, 2020 at 13:51
You do not need the line global ajuste_fecha. Oh, I echo the above recommendation to use a dict instead. — user5386938
– user5386938, Commented Oct 21, 2020 at 13:54
Hello, do you mean a dictionary? I would do it but I don't understand why my solution stopped working out of nowhere ... will the python have been updated? Why doesn't my variable return normally? — Gonza
– Gonza, Commented Oct 21, 2020 at 14:07

Chandella07 · Accepted Answer · 2020-10-21 14:40:28Z

The Api response that you are getting is not matching any of your condition in f_ajuste_fecha method. that's why you are getting error name 'ajuste_fecha' is not defined

May be the update has changed the output from Sep to Set, I just checked by hitting the API.

Día/Mes/Año,"Tipo de cambio - TC Interbancario (S/ por US$) - Compra"
"08.Set.20","3.54366666666667"
"09.Set.20","3.533"
"10.Set.20","3.54"
"11.Set.20","3.568"
"14.Set.20","3.567"
"15.Set.20","3.54733333333333"
"16.Set.20","3.53633333333333"
"17.Set.20","3.53116666666667"
"18.Set.20","3.52333333333333"
"21.Set.20","3.5455"
"22.Set.20","3.55183333333333"
"23.Set.20","3.57016666666667"
"24.Set.20","3.58033333333333"
"25.Set.20","3.593"
"28.Set.20","3.58816666666667"
"29.Set.20","3.5935"
"30.Set.20","3.59733333333333"
"01.Oct.20","3.60183333333333"
"02.Oct.20","3.618"

You need to update your code condition for matching Set rather than Sep.

  elif fecha[0:3] == "Set":      #replace Sep with Set here
    ajuste_fecha = "09"

Martijn Pieters · Accepted Answer · 2020-10-21 20:10:03Z

0

So try this- remove the ajuste_fecha as global and assign a random string 'abc' to it like ajuste_fecha ='abc' and run it. You will not notice that error

edited Oct 21, 2020 at 20:10

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered Oct 21, 2020 at 13:54

ABHISHEK D

1536 bronze badges

1 Comment

Gonza Over a year ago

Hi, thanks for your response. I have added what you mention and it returns me this error: UnboundLocalError: ("local variable 'ajuste_fecha' referenced before assignment", 'occurred at index 0') I have added it before the function. What is it due to?

Collectives™ on Stack Overflow

variable problem in python function, is not defined

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related