Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column

Question

For a college project, I'm working on sentiment analysis. I have an excel document with "1000 rows" and a "column" called "comments." For the analysis, I must have spelling errors in the sentences in these rows fixed. I'm not sure how to use Python code to process this so that I receive a column with the right sentences.

All of the solutions I came across focused on word-level spelling correction rather than sentence-level correction across hundreds of rows.

Answer 1

Use Spellchecker for doing your stuff:

import pandas as pd
from spellchecker import SpellChecker

spell  = SpellChecker()

df = pd.DataFrame(['hooww good mrning playing fotball studyiing hard'], columns = ['text'])

def spell_check(x):
    correct_word = []
    mispelled_word = x.split()
    for word in mispelled_word:
        correct_word.append(spell.correction(word))
    return ' '.join(correct_word)


df['spell_corrected_sentence'] = df['text'].apply(lambda x: spell_check(x))