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

User · Answer

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

User · Answer

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  gt  gt  gt  Ones   Hope that helps

User · Answer

From here what I understand DataFrames are      DataFrame is a 2-dimensional labeled data structure with columns of potentially different types  You can think of it like a spreadsheet or SQL table  or a dict of Series objects    And Series are      Series is a one-dimensional labeled array capable of holding any data type  integers  strings  floating point numbers  Python objects  etc      Series have a name attribute which can be accessed like so    In  27   s   pd Series np random randn 5   name  something     In  28   s  Out 28     0    0 541  1   -1 175  2    0 129  3    0 043  4   -0 429  Name  something  dtype  float64   In  29   s name  Out 29    something    EDIT  Based on OP s comments  I think OP was looking for something like     gt  gt  gt  df   pd DataFrame        gt  gt  gt  df name    df    making a custom attribute that DataFrame doesn t intrinsically have   gt  gt  gt  print df name    df

User · Answer

Here is a sample function   df name   file    Sixth line in the code below  def df list        filename list   current stage files PATH      df list          for file in filename list          df   pd read csv PATH file          df name   file         df list append df      return df list

User · Answer

In many situations  a custom attribute attached to a pd DataFrame object is not necessary  In addition  note that pandas-object attributes may not serialize  So pickling will lose this data   Instead  consider creating a dictionary with appropriately named keys and access the dataframe via dfs  some label     df   pd DataFrame    dfs     some label   df

[python] Get the name of a pandas DataFrame

Examples related to python

Examples related to pandas

Examples related to dataframe

Examples related to attributes