using ipython to find correlation
TRANSCRIPT
![Page 1: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/1.jpg)
CORRELATION BETWEEN HOTEL PRICE V. VOTING
WITH PYTHON AND PANDASBY APIPOJ PIASAK
![Page 2: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/2.jpg)
USING PYTHON AND PANDASCORRELATION BETWEEN HOTEL PRICE V.
VOTING
• Sample of using Data Science in a real-world data
• How to apply use scatter plot to find a relationship between Room price and voting.
• To check weather the price range cause the high voting?
![Page 3: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/3.jpg)
HOTEL Data in Thailand(Source of data can't be disclosed)
![Page 4: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/4.jpg)
Import *.csv data using PandasRun the code in IPYTHON Notebook
![Page 5: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/5.jpg)
Using pandas Describe() function to check outliers with percentiles
Run the code in IPYTHON Notebook
![Page 6: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/6.jpg)
Remove unused column and calculate quantile()Run the code in IPYTHON Notebook
![Page 7: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/7.jpg)
Using Apply function to filter value based on percentiles value
Run the code in IPYTHON Notebook
![Page 8: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/8.jpg)
Check data frame again, data looks much better now.Run the code in IPYTHON Notebook
![Page 9: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/9.jpg)
Check data frame again, data looks much better now.Run the code in IPYTHON Notebook
![Page 10: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/10.jpg)
BONUS (1)Run the code in IPYTHON Notebook
![Page 11: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/11.jpg)
BONUS (2)Run the code in IPYTHON Notebook
![Page 12: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/12.jpg)
FROM OUR DATA PLOTCONCLUSION
• The relationship between price and voting, if you want to get higher vote, you may think about your price range should be between 500THB - 3000THB, hmmm interesting.
![Page 13: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/13.jpg)
FROM OUR DATA PLOTCONCLUSION
• Most of Thailand hotel has price range between 500THB-1500THB
![Page 14: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/14.jpg)
FROM OUR DATA PLOTCONCLUSION
• Seems like, the customer who have booked any hotel vote at least 7 score.
• This means if any vote is beyond 7 it is bad! you have to improve now!
![Page 15: Using IPython to Find Correlation](https://reader036.vdocuments.us/reader036/viewer/2022062523/58f08e3c1a28abdc2d8b458b/html5/thumbnails/15.jpg)
— Carly Fiorina, former executive of Hewlett-Packard Co.
THE GOAL IS TO TURN DATA INTO INFORMATION, AND INFORMATION INTO
INSIGHT.
”
“