Python/Pandas - How to remove extra space between two words from a data frame column

Question

The "strip" function removes the spaces on the left and right, but does not remove the spaces between the words:

raw_data = {'NAME': ['   José  Luiz   da   Silva   ']}
df = pd.DataFrame(raw_data, columns = ['NAME'])
df['NAME'] = df['NAME'].str.strip()

Answer 1

import pandas as pd
rdata = {'NAME': ['   José           Luiz   da       Silva   ']}
df = pd.DataFrame(rdata, columns = ['NAME'])

for i, row in df.iterrows():
  df.set_value(i,'NAME',' '.join(row.NAME.split()))

print (df)  

Output:

                 NAME
0  José Luiz da Silva

Run on repl.it.