This project helps to analyze the public opinion in social media towards Chennai city by the people who live in the city. It presents a comprehensive review of local people who tweet, retweet, like on Twitter about Chennai. For completeness, it includes introductions to social media web scraping, storage, data cleaning, and some sentiment analysis tools. This project also provides a comparative study where we use three different sentiment analysis tools: Naive Bayes, Bert, and Neural Network. Analyzing social media, in particular, Twitter feeds for sentiment analysis, has become a major research activity due to the availability of web-based APIs provided by Twitter services. This project provides a review of leading software tools and how to use web scraping, cleanse using Bert and comparing the tweets with three different tools and showing them in graph and finding out which gives the best accuracy and presenting it to the CHENNAI SMART CITY LTD which comes under the GREATER CHENNAI CORPORATION. The data retrieval techniques that are presented in this paper are valid at the time of doing this project (April 2021), because they are subject to change since social media web scraping APIs are rapidly changing.