@sarthakgirdhar I checked the test file you’ve shared. The data is entirely unstructured. I think, using any R package wouldn’t help since there is no specific length of house number, street name, State name etc. In fact, some of the observations are incomplete. In such cases, your first attempt should be at collecting more data. If that’s not possible, use Excel.
Data is small, excel will be great and easy to do this.
If you are ready for some challenge, this is a good regular expression problem for R. You can use stringr package combined with regular expressions for pattern matching.
If neither of the above two works, you can do it manually since the numbers of observations aren’t so many.