PANDAS: How to rename a column but not lose its previous text in pandas?

Question

Okay so I was reading up a text file and using .read_csv() and ended up with this dataframe:

But the problem is that, the im feeling rather rotten... text is ended up being as a column rather than a dataframe feature, and when I try to rename the column I just end up losing the feature all together, and skipping onto the 2nd value in the dataframe:

EDIT: This is how I read in the text file.

Any answers, comments are heartfully accepted.

use `pd.read_csv("emotions.txt", sep=";", header=None)` since you dont have a header — luigigi, Sep 20 '21 at 10:11
Can you please share the first two lines of your file in the question? — Gabriel Pellegrino, Sep 20 '21 at 10:11
Does this answer your question? [Give column name when read csv file pandas](https://stackoverflow.com/questions/31645466/give-column-name-when-read-csv-file-pandas) — Goh Kok Han, Sep 20 '21 at 10:14

score 1 · Accepted Answer · answered Sep 20 '21 at 10:14

1

The final solution would be (respectfully concluded by @luigigi)
pd.read_csv("emotions.txt", sep=";", header=None)

Thanks!

answered Sep 20 '21 at 10:14

Aryan

1,093
9
22

score 0 · Answer 2 · answered Sep 20 '21 at 10:17

0

You can pre-defined the columns name with the code.

df = pd.read_csv('emotions.txt', sep =';', names=['TEXT','EMOTION'], header=None)

answered Sep 20 '21 at 10:17

Goh Kok Han

125
1
9

PANDAS: How to rename a column but not lose its previous text in pandas?

2 Answers2