A string doesn't have the attribute .loc

Question

I have different dataframes that follow the example: 'AAPLdf, AMZNdf, GOOGLdf, ...' etc I just want to be able to enter the ticker as an input so that I don't have write the same code a million times.

import matplotlib.pyplot as plt
from mpl_finance import candlestick_ohlc
import pandas as pd
import matplotlib.dates as mpl_dates

ticker = input("ticker:") + "df"

data = ticker
ohlc = data.loc[:, ['t', 'o', 'h', 'l', 'c']]

AttributeError: 'str' object has no attribute 'loc'

I couldn't understand what do you want to do here, ```loc``` is not a method for a string. let me know what you want to do here — Hozayfa El Rifai, May 08 '20 at 00:43

Trenton McKinney · Accepted Answer · 2020-05-08T02:52:59.490

1

eval() is a built-in python function
f'{variable}' is an f-string
- f-Strings: A New and Improved Way to Format Strings in Python
- PEP 498 - Literal String Interpolation

ticker = input('ticker: ')

# this will return data as the dataframe from ticker, but it must be an exact match
data = eval(f'{ticker}df')  # -> equivalent to eval('GOOGLdf`), for example

# now you can use .loc 
data.loc[:, :]

edited May 08 '20 at 02:52

answered May 08 '20 at 01:02

Trenton McKinney

56,955
33
144
158

A string doesn't have the attribute .loc

1 Answers1