Removing datatype information line from python head function

user_7114664 0
Viewed 66

I want to access the top 6 items in a pandas dataframe. I am doing this by using .head(n=6). This works fine and will show me the first 6 values. my problem is that it also shows the type of data that the data is. In this case I have my 6 values and at the bottom of my values I see : Name: Column 7, dtype: int64.

When I do:

Print(df_column_7.head(n=6)

I get 6 values and an additional datatype line.

I am struggling to find a way to remove the this additional data type information provided by .head(). I want to get rid of this data type information as I will be adding the .head(n=6) into a Django model. And the datatype info will mess up the model entry.

pandas dataframe python-3.x python
2 Answers

Since your use head on pandas series, you'll get this line by default.

>>> d = pd.Series(list('abcdefg'), name='col_1').to_frame() 

>>> d.col_1.head(n=3)
0    a
1    b
2    c
Name: col_1, dtype: object

If you need to omit last line, you can do:

>>> print(d.col_1.head(n=3).to_string())
0    a
1    b
2    c
user_88758460

I could not see the problem with a dataframe I have tested. So I could not try, but try and let me know if this helps:

display(df_column_7.head(6))
user_108363090
Related