How to get a value from a Pandas DataFrame and not the index and object type

Question

Say I have the following DataFrame   Letter    Number A          1 B          2 C          3 D          4   Which can be obtained through the following code  import pandas as pd  letters pd Series   A    B    C    D    numbers pd Series  1  2  3  4   keys   Letters    Numbers   df pd concat  letters  numbers   axis 1  keys keys    Now I want to get the value C from the column Letters   The command line  df df Letters   C   Letters   will return   2    C Name  Letters  dtype  object   How can I get only the value C and not the whole two line output

User · Answer

Nobody mentioned it  but you can also simply use loc with the index and column labels  df loc 2   Letters      C   Or  if you prefer to use  quot Numbers quot  column as reference  you can also set is as an index  df set index  Numbers   loc 3   Letters

User · Answer

Use the values attribute to return the values as a np array and then use  0  to get the first value   In  4   df loc df Letters   C   Letters   values 0   Out 4    C    EDIT  I personally prefer to access the columns using subscript operators   df loc df  Letters       C    Letters   values 0    This avoids issues where the column names can have spaces or dashes - which mean that accessing using

User · Answer

df df Letters   C   Letters item     This returns the first element in the Index Series returned from that selection  In this case  the value is always the first element    EDIT   Or you can run a loc   and access the first element that way  This was shorter and is the way I have implemented it in the past     Pandas Index doc Pandas Series doc

User · Answer

import pandas as pd  dataset   pd read csv  data csv   values   list x for x in dataset  column name      gt  gt  gt  values 0   item 0    edit   actually  you can just index the dataset like any old array   import pandas as pd  dataset   pd read csv  data csv   first value   dataset  column name   0    gt  gt  gt  print first value   item 0

[python] How to get a value from a Pandas DataFrame and not the index and object type

Examples related to python

Examples related to pandas

Examples related to dataframe