How to capitalize middle row of a column in PySpark or Pandas

user_14598802 0
Viewed 68

I have a CSV file three columns values

    1st Column   2nd Column   3rd Column
    ram          karthi       bruce
    RAM          KATHI        BRUCE
    ram          karthi       bruce

I want to capitalize the 2nd row like ram,karthi and bruce in Pyspark or Pandas... I am not able to do. Please help. Solution in PySpark will be more helpful..

pyspark pandas dataframe python
1 Answers

In Pandas, you can do it using df.loc and Series.str.upper:

In [1619]: df
Out[1619]: 
  1st_Column 2nd_Column 3rd_Column
0        ram     karthi      bruce
1        ram     karthi      bruce
2        ram     karthi      bruce

In [1620]: df.loc[1] = df.loc[1].str.upper()

In [1621]: df
Out[1621]: 
  1st_Column 2nd_Column 3rd_Column
0        ram     karthi      bruce
1        RAM     KARTHI      BRUCE
2        ram     karthi      bruce
user_58208140
Related