How to use and print the pandas dataframe name

Question

I have a pandas dataframe

a = [0, 1, 2, 3]
b = [2, 3, 4, 5]

df = pd.DataFrame({'col1':a, 'col2':b})

I dont want to use df.name, but i want to print dataframe name df and also can use somewhere like saving csv

print(df + '.csv')

I am expecting

'df.csv'

Does this answer your question? Get the name of a pandas DataFrame — Chris
– Chris, Commented Nov 22, 2019 at 5:33
stackoverflow.com/questions/544919/… & stackoverflow.com/questions/592746/… — Alexander
– Alexander, Commented Nov 22, 2019 at 5:41

Guillaume Jacquenot · Accepted Answer · 2019-11-22 06:00:44Z

1

I don't think it is possible. Why don't you try using a dictionary instead.

Example

a = [0, 1, 2, 3]
b = [2, 3, 4, 5]

var_map = {'df':pd.DataFrame({'col1':a, 'col2':b})}

# Save all dataframes in dictionary with name
for key in var_map:
    var_map[key].to_csv(key + ".csv")

edited Nov 22, 2019 at 6:00

Guillaume Jacquenot

11.8k6 gold badges45 silver badges50 bronze badges

answered Nov 22, 2019 at 5:37

Reuben

4873 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Guillaume Jacquenot · Accepted Answer · 2019-11-22 06:14:36Z

You can subclass pandas.DataFrame as explained here. It is a little tricky but possible...
You can add an attribute directly to the instance of DataFrame. Not recommended but possible.
You can also create a class containing a DataFrame and overload the __repr__ and to_csv methods as mentioned below

Here is an example of the 2nd solution

import pandas as pd
df = pd.DataFrame({'col1':a, 'col2':b})
df.myname ='my_super_name'

Here is an example of the 3rd solution

import pandas as pd

class MyDataFrame():
    def __init__(self, _myname, *args, **kwargs):
        self.myname = _myname
        self.df = pd.DataFrame(*args, **kwargs)

    def __repr__(self):
        return self.myname

    def to_csv(self):
        self.df.to_csv(self.myname + '.csv')

a = [0, 1, 2, 3]
b = [2, 3, 4, 5]

df = MyDataFrame('my_data_frame', {'col1':a, 'col2':b})
print(df)
df.to_csv()

Collectives™ on Stack Overflow

How to use and print the pandas dataframe name

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related