Get the name of a pandas DataFrame

Question

How do I get the name of a DataFrame and print it as a string?

Example:

boston (var name assigned to a csv file)

import pandas as pd boston = pd.read_csv('boston.csv')  print('The winner is team A based on the %s table.) % boston 

Answer 1

You can name the dataframe with the following, and then call the name wherever you like:

import pandas as pd df = pd.DataFrame( data=np.ones([4,4]) ) df.name = 'Ones'  print df.name >>> Ones 

Hope that helps.

Answer 2

Sometimes df.name doesn't work.

you might get an error message:

'DataFrame' object has no attribute 'name'

try the below function:

def get_df_name(df):     name =[x for x in globals() if globals()[x] is df][0]     return name