You are receiving an error because alphabet is a variable defined within a function. It is therefore a local variable which cannot be accessed outside of that function.

I am very confused as to why there is a function there in the first place. I would replace everything under the alphabet function with just the variable containing the characters in order.

There are actually quite a few things wrong with this code - the code in the for loop is flawed as well. Here is my solution, with the added benefit of printing the encoded message as one string and not as a load of characters, as well as dealing with non-alphanumeric characters.

elif option1 == 2:
    alphabet = 'abcdefghijklmnopqrstuvwxyz'
    message = input('What message would you like to encrypt?')
    encoded = []
    for character in message:
        if character.isalpha():
            encoded.append(alphabet[25-alphabet.find(character)])
        else:
            encoded.append(character)
    print(''.join(encoded))

This similar question helped me discover the problem.

The Python documentation for the inspect module mentions both "frame records" and "frame objects", and explains the difference.

• inspect.currentframe() returns a frame object, but
• inspect.getouterframes() returns a list of frame records.

The mistake in the code above is not extracting the frame object from the frame record of the calling function, and passing inspect.getouterframes() the frame record instead of the frame object. (Note that inspect.getouterframes() doesn't check that its argument is a frame object.)

Here's the fixed definition of caller_args() (with the change to the assignment to caller_frame):

def caller_args():
    frame = inspect.currentframe()
    outer_frames = inspect.getouterframes(frame)
    caller_frame = outer_frames[1][0]
    return inspect.getargvalues(caller_frame)

Which runs as desired:

$ python getargvalues_test_fixed.py
ArgInfo(args=['arg1'], varargs=None, keywords=None, locals={'arg1': 'foo'})

If this line

new_x = np.linspace(x.min(), x.max(), new_length)

is generating the error message

AttributeError: 'function' object has no attribute 'min'

then x is a function, and functions (in general) don't have min attributes, so you can't call some_function.min(). What is x? In your code, you've only defined it as

x=var

I'm not sure what var is. var isn't a default builtin in Python, but if it's a function, then either you've defined it yourself for some reason or you've picked it up from somewhere (say you're using Sage, or you did a star import like from sympy import * or something.)

[Update: since you say you're "using PyLab", probably var is numpy.var which has been imported into scope at startup in IPython. I think you really mean "using IPython in --pylab mode.]

You also define x1 and y1, but then your later code refers to x and y, so it sort of feels like this code is halfway between two functional states.

Now numpy arrays do have a .min() and .max() method, so this:

>>> x = np.array([0.1, 0.3, 0.4, 0.7])
>>> y = np.array([0.2, 0.5, 0.6, 0.9])
>>> new_length = 25
>>> new_x = np.linspace(x.min(), x.max(), new_length)
>>> new_y = sp.interpolate.interp1d(x, y, kind='cubic')(new_x)

would work. Your test data won't because the interpolation needs at least 4 points, and you'd get

ValueError: x and y arrays must have at least 4 entries

As the error traceback suggests, there's no table in the database with the given name:

The provided table name '{name}' is not found exactly as such in the database

It seems that this is due to a case sensitivity issue. In the table model:

class Apple_health_export(Base):
    __tablename__ = 'apple_health_export'

In the initial code snippet:

df.to_sql('Apple_health_export', engine, if_exists='append', index=False)

'apple_health_export' is not equal to 'Apple_health_export'.