how to replace whole column values on dt.datatable on python?

Question

i have a datatable like this one :

status
▪▪▪▪
0   abc
1   abc
2   ddd
3   aaa

and I want to replace to :

convert the small letter ot capital letter

status
▪▪▪▪
0   ABC
1   ABC
2   DDD
3   AAA

how to use datatable package to do this one?

i know if my table is dataframe in pandas, I can use:

data['status'] = data['status'].apply(lambda x: x.upper())

OK. got it: https://datatable.readthedocs.io/en/latest/index.html — balderman, Sep 22 '20 at 08:29
see https://stackoverflow.com/questions/59543028/how-to-modify-update-column-values-on-a-condition-in-pydatatable — balderman, Sep 22 '20 at 08:32
sorry guys i want to convert the small letter to capital letter — yanhei Wu, Sep 22 '20 at 08:44

score 2 · Answer 1 · answered Sep 23 '20 at 02:33

2

can use this way:

data['status'] = dt.Frame([value.upper() for value in data['status'].to_list()[0]])

answered Sep 23 '20 at 02:33

yanhei Wu

1 Answers1