1667. Fix Names in a Table.md

1667. Fix Names in a Table

Question Link

Pandas Solution

import pandas as pd

def fix_names(users: pd.DataFrame) -> pd.DataFrame:
    users['name']=users['name'].str.capitalize()
    return users.sort_values(by='user_id',ascending=True)

SQL Solution

# Write your MySQL query statement below
select user_id, concat(upper(substr(name,1,1)),lower(substr(name,2))) name from Users
order by user_id asc