INITCAP( ) in pandas

Posted by Kevin

Selecting string values from a column and returning values in title case in SQL, translated to pandas.

Selecting string values in title case

In SQL:

SELECT 
  INITCAP(column_1) 
FROM 
  table;

In pandas:

table 
    .assign(column_1 = table['column_1'] 
    .apply(lambda column_1: column_1.title())) 
    ['column_1']

References