2

I've been trying to open a .csv, read it in pandas, and print it without the column name. The code I have


df = pd.read_csv(filepath_or_buffer='C:/Users/R2/Documents/Desktop/Programing/Bot/list.csv')
rows = df.loc[[i]]
values = rows.to_string(index = False)
print(values)

Outputs something like this

Value  
 12343

How would I make it so values equal only 12343 and not Value 12343

Caio Navarro
  • 48
  • 1
  • 13
  • 1
    `rows` is a DataFrame, print the `Series`, which won't have a column header. `rows = df.loc[i]`. And depending upon left or right justification you can use the solutions here: https://stackoverflow.com/questions/29645153/remove-name-dtype-from-pandas-output – ALollz Jan 12 '21 at 21:32

1 Answers1

3

Try:

values = rows.to_string(index = False, header=False)
print(values)
Scott Boston
  • 147,308
  • 15
  • 139
  • 187