Anyone tried to access the column User_Description in the Tweets CSV?

Question

I'm getting the error that there are only float in that column

Answer 1

Whenever data is missing/blank in a data frame, it fills in as the special value NaN, which is a float value.

Probably in this case it would make sense to use fillna to fill in "No Description" or even the empty string "" for each of those cells.

See example here: https://www.geeksforgeeks.org/python-pandas-dataframe-fillna-to-replace-null-values-in-dataframe/

Answer 2

You could try using this line of code to read the file:

df = pd.read_csv(r'AprTweets01.csv', lineterminator='\n',

             usecols=['Full_Text', 'User_Description'], dtype=str)

Comments

I think this is also a good approach, to force the columns to be of type string.

Answer 3

I also had that problem

Comments

I tried cast it like this str(file["User_Description"][i].
It works, but I'm so confused why would it treat a bunch of descriptions as float

Answer 4

I also encountered this problem in the first place. So I decided to do something that is not related to the User_Description data