Drop the original column and rename the new column See df.drop & df.withcolimnrenamed Eran On Wed, 30 Dec 2015 at 19:08 raja kbv <raja...@yahoo.com> wrote:
> Solutions from Eran & Yanbo are working well. Thank you. > > @Eran, > > Your solution worked with a small change. > DF.withColumn("upper-code",upper(df("countrycode"))). > > This creates a new column "upper-code". Is there a way to update the > column or create a new df with update column? > > Thanks, > Raja > > On Thursday, 24 December 2015 6:17 PM, Eran Witkon <eranwit...@gmail.com> > wrote: > > > Use DF.withColumn("upper-code",df("countrycode).toUpper)) > or just run a map function that does the same > > On Thu, Dec 24, 2015 at 2:05 PM Bharathi Raja <raja...@yahoo.com.invalid> > wrote: > > Hi, > Values in a dataframe column named countrycode are in different cases. Eg: > (US, us). groupBy & count gives two rows but the requirement is to ignore > case for this operation. > 1) Is there a way to ignore case in groupBy? Or > 2) Is there a way to update the dataframe column countrycode to uppercase? > > Thanks in advance. > > Regards, > Raja > > > >