how do i remove ' ' [ ] in array (python)

Question

i have this code:

dfx = pd.read_csv('hasil_processing_auto.csv', encoding='unicode_escape')
dy = dfx.loc[:,'polarity']
X = dy.values

print(X)

and this is the output i get:

['[0]' '[0]' '[0]' '[0]' '[0]' '[0]' '[0]' '[0]' '[0]' '[0]' '[0]' '[0]'
 '[1]' '[0]' '[0]' '[0]' '[0]' '[0]' '[0]' '[1]']

i want it to be just like [0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1]

the csv is like this:

    tweets                                              label   polarity
0   i love myself kuliah tugas tumpuk sapu ngepel ...   Netral  [0]
1   suogh online online kuliah                          Netral  [0]
2   bisnis sekolah kuliah ngantor online shop prod...   Netral  [0]
3   tunggu surat putus rektor surat putus dekan la...   Netral  [0]
4   kuliah online bosan                                 Netral  [0]
.....

Your list is evaluated to object type when reading. To read it properly as valid python list try ast.literal_eval — Sergey Bushmanov
– Sergey Bushmanov, Commented Nov 29, 2020 at 16:28
The read_csv loads those [0] column values as strings. This sort of thing often occurs when you save a dataframe as csv, and the original frame had lists (or array) elements. csv is best used when the dataframe has simple column elements - numbers and strings. — hpaulj
– hpaulj, Commented Nov 29, 2020 at 18:01

FloLie · Accepted Answer · 2020-11-29 16:03:20Z

4

The easiest way is to strip the column as such:

'[0]'[1:-1] --> '0'

If you are new to Python, you can treat a string as an iterable so you can subset it by [start:end]

dfx['polarity'] = dfx['polarity'].apply(lambda x: x[1:-1])

edited Nov 29, 2020 at 16:03

answered Nov 29, 2020 at 15:57

FloLie

1,8511 gold badge10 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

alessandro Over a year ago

got this output ['' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '']

FloLie Over a year ago

sorry got to be -1

adir abargil Over a year ago

I think he means -1

Collectives™ on Stack Overflow

how do i remove ' ' [ ] in array (python)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related