How do I remove name and dtype from pandas output

user_10568270 0
Viewed 25066

I have output that looks like this: 

nutrition_info_256174499 = df1.loc[:"Salt" , "%Reference Intake*"]

print (nutrition_info_256174499)

Typical Values
Energy                5%
Fat                   1%
of which saturates    1%
Carbohydrates         7%
of which sugars       2%
Fibre                  -
Protein               7%
Salt                  6%
Name: %Reference Intake*, dtype: object

What must be done to remove both Name and dtype at end of output?

pandas python
5 Answers

For printing with preserving index you can use Series.to_string():

df = pd.DataFrame(
    {'a': [1, 2, 3], 'b': [2.23, 0.23, 2.3]},
    index=['x1', 'x2', 'x3'])
s = df.loc[:'x2', 'b']    
print(s.to_string())

Output:

x1    2.23
x2    0.23
user_90594200

Use the .values attribute.

Example:

In [158]: s = pd.Series(['race','gender'], index=[1,2])

In [159]: print(s)
1      race
2    gender
dtype: object

In [160]: s.values
Out[160]: array(['race', 'gender'], dtype=object)

You can convert to a list or access each value:

In [161]: list(s)
Out[161]: ['race', 'gender']
user_50250090 
print(nutrition_info_256174499.to_string())

that should remove Name: %Reference Intake*, dtype: object in your prints

user_21937260

Simply converting the dataframe values to a list with .tolist() removes the dtype element. After you can just loop through the list to get the single values:

df_as_a_list = df.values.tolist()
user_56114670

Maybe this isn't exactly what you want, but for what it's worth, if you put the column name in a list, you get a DataFrame out instead of a Series, with the name at the top instead of bottom and no dtype.

df1.loc[:"Salt", ["%Reference Intake*"]]

                   %Reference Intake*
Typical Values                       
Energy                             5%
Fat                                1%
of which saturates                 1%
Carbohydrates                      7%
of which sugars                    2%
Fibre                               -
Protein                            7%
Salt                               6%
user_45183410
Related