Python Regex, correct my csv file with lowercase/uppercase and other signs
Budget: $10 – $30 USD
Hello.
I have .csv file and in one column I have rows with text. I want to format the text in these cases, so it will look as normal correct sentence:
- lowercaseUppercase -> lovercase. Uppercase
(add a dot and space between lowercase and uppercase in merged sentences)
- Lowercase Uppercase -> Lowercase. Uppercase
(add a dot and space to the end of 1st sentence)
- !Uppercase -> ! Uppercase
(add a space after ! and sentence beginning)
- Add a dot at the end of all row, if dot doesn’t exist
- Change lowercase at the beginning of the row (if exist).
I need script, so I can use it more than once (python preferable).
I have .csv file and in one column I have rows with text. I want to format the text in these cases, so it will look as normal correct sentence:
- lowercaseUppercase -> lovercase. Uppercase
(add a dot and space between lowercase and uppercase in merged sentences)
- Lowercase Uppercase -> Lowercase. Uppercase
(add a dot and space to the end of 1st sentence)
- !Uppercase -> ! Uppercase
(add a space after ! and sentence beginning)
- Add a dot at the end of all row, if dot doesn’t exist
- Change lowercase at the beginning of the row (if exist).
I need script, so I can use it more than once (python preferable).