<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Chaithanya Vamshi on Medium]]></title>
        <description><![CDATA[Stories by Chaithanya Vamshi on Medium]]></description>
        <link>https://medium.com/@chaithanyavsai?source=rss-54ed1024d5a8------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*05ssGoHRt7FmVOic50jxgw.png</url>
            <title>Stories by Chaithanya Vamshi on Medium</title>
            <link>https://medium.com/@chaithanyavsai?source=rss-54ed1024d5a8------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 12:39:48 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@chaithanyavsai/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Building a Contact Form with Email Integration using Python & Streamlit]]></title>
            <link>https://medium.com/analytics-vidhya/building-a-contact-form-with-email-integration-using-python-streamlit-fbdd0e5b8522?source=rss-54ed1024d5a8------2</link>
            <guid isPermaLink="false">https://medium.com/p/fbdd0e5b8522</guid>
            <category><![CDATA[streamlit]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[customer-experience]]></category>
            <category><![CDATA[business-solutions]]></category>
            <dc:creator><![CDATA[Chaithanya Vamshi]]></dc:creator>
            <pubDate>Fri, 03 Mar 2023 14:19:15 GMT</pubDate>
            <atom:updated>2023-03-03T14:19:15.032Z</atom:updated>
            <content:encoded><![CDATA[<h4>Streamlining your Customer Experience to the Next Level!</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KDZpTG6ZDd7uDnIMp5z_Nw.png" /><figcaption>Contact Form with Python &amp; Streamlit</figcaption></figure><p>Are you tired of manually managing customer inquiries and feedback through your website’s contact form? Look no further!</p><p>In this article, I will show you how to build a contact form with email integration using Python and Streamlit. With this tool, you can streamline the process of receiving, and managing customer inquiries directly to your inbox, while also improving your customer service and generating leads and sales opportunities.</p><p>With features such as form validation, recaptcha integration, and custom email templates you can ensure that you’re only receiving submissions from genuine users. And with the added bonus of Lottie animations, your contact form will be both visually appealing and engaging for users.</p><p>So what are you waiting for? Let’s get started on building your next must-have business tool!</p><h3>Introduction</h3><p>In today’s digital age, businesses and companies rely heavily on customer feedback, inquiries, and complaints to make informed decisions and improve their products/services.</p><p>Contact forms allow customers to reach out to companies without the need for an email or phone call. Having a contact form on your website can also make it easier for customers to find and communicate with you.</p><p>However, collecting and processing responses from contact forms can be a daunting task for businesses, especially if they receive a large volume of inquiries. This is where email integration comes in. With email integration, businesses can automatically store and process responses in their email inbox, saving them time and effort.</p><h3>Business Deliverables</h3><ol><li>Receive feedback and inquiries from customers and clients</li><li>Respond to customer inquiries in a timely and efficient manner</li><li>Streamline the process of receiving and managing customer inquiries</li><li>Improve customer service and satisfaction</li><li>Generate leads and sales opportunities</li></ol><h3>Features</h3><ol><li><strong>Form Validation:</strong> To ensure required fields are filled out.</li><li><strong>Recaptcha Integration:</strong> To prevent bots, spam or malicious programs from submitting the form.</li><li><strong>Email Integration: T</strong>o store contact form responses and ensure that the business can follow up with potential customers.</li><li><strong>Custom Email Templates:</strong> To make it easy for the business to understand the responses they receive with a good design and structure.</li><li><strong>Lottie Animations Integration:</strong> To make the contact form visually appealing and engaging for users.</li></ol><h3>Requirements</h3><p>To build this contact form with email integration, we will be using the following libraries and services:</p><ol><li><strong>Python 3:</strong> Python is a widely used high-level programming language that is easy to learn and use</li><li><strong>Streamlit:</strong> Streamlit is an open-source Python library that allows you to create interactive web applications with ease</li><li><strong>Streamlit_lottie:</strong> Streamlit_lottie is a Streamlit component that allows you to add Lottie animations to your Streamlit app</li><li><strong>Requests:</strong> Requests is a Python library that allows you to send HTTP requests using Python</li><li><strong>Form Submit REST API:</strong> API and Email service for HTML forms to send form submission information directly to your email without the need for any backend code or SMTP setup. For more info visit: <a href="https://formsubmit.co/">https://formsubmit.co/</a></li><li><strong>Notion:</strong> Template to display a “Thank You” message to the user after submitting a contact form. You can access the template which I created here: <a href="https://chaithanyavsai.notion.site/Thank-you-for-taking-the-time-to-fill-out-our-contact-form-3d2603ee2e2c4530b8db91dd916c415e">Notion</a></li><li><strong>CSS:</strong> To improve the styling and design of the contact form. You can access the CSS code here: <a href="https://www.w3schools.com/howto/howto_css_contact_form.asp">CSS</a></li></ol><h3>Project Workflow</h3><ol><li>Import the necessary libraries, including <strong>JSON</strong>, <strong>requests</strong>, <strong>streamlit</strong>, and <strong>streamlit_lottie</strong>.</li><li>Set the title of the Streamlit app and create two columns to display the <strong>Contact form</strong> and <strong>Lottie animations</strong>.</li><li>In the first column, write a brief introduction and explanation of the contact form. Then, create the <strong>HTML</strong> for the contact form using a string variable and the form tag to include the necessary fields: <strong>name</strong>, <strong>email</strong>, and <strong>message</strong>.</li><li>The form action attribute is set to the <strong>Form Submit REST API</strong> endpoint URL where the data will be posted to the provided email.</li><li>Additionally, we set a hidden attribute ‘<strong>_template</strong>’ to ‘table’ and ‘<strong>_next</strong>’ attribute to Notion page URL where the user will be redirected after submitting the contact form. This Notion page will display a thank you message.</li><li>Use the markdown function in Streamlit to display the HTML contact form, with the ‘<strong>unsafe_allow_html=True’</strong> parameter to allow HTML in the markdown.</li><li>In the second column, define a function to load <strong>Lottie animations</strong> from a URL using the requests library. This function is used to load the Lottie animation and display it in the second column of the Streamlit app.</li><li>Use the ‘<strong>st_lottie</strong>’ function in Streamlit to display the Lottie animation in the second column, using the ‘<strong>load_lottieurl’</strong> function to load the animation data and set various parameters for the animation, such as its speed, quality, height and width.</li></ol><h3>Demo Video</h3><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FEp24FCpO2Ak%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DEp24FCpO2Ak&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FEp24FCpO2Ak%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/3f45f0ee8670cd342f532b947b988669/href">https://medium.com/media/3f45f0ee8670cd342f532b947b988669/href</a></iframe><h3>Conclusion</h3><p>This article showed how a contact form is an essential tool for businesses and companies as it helps them to collect valuable feedback and inquiries from their customers. With email integration, businesses can store and process responses in their email inbox, saving them time and effort.</p><p>Overall, this project is a great example of how Python and Streamlit can be used to build useful and visually appealing applications for businesses and individuals to streamline their customer experiences.</p><p>Thank you for taking the time to read this article and would you like to see the code behind this tool? Feel free to leave a clap, comment on the article and let’s connect on <a href="https://www.linkedin.com/in/chaithanyavsai/">LinkedIn</a> to learn and grow together!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fbdd0e5b8522" width="1" height="1" alt=""><hr><p><a href="https://medium.com/analytics-vidhya/building-a-contact-form-with-email-integration-using-python-streamlit-fbdd0e5b8522">Building a Contact Form with Email Integration using Python &amp; Streamlit</a> was originally published in <a href="https://medium.com/analytics-vidhya">Analytics Vidhya</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unlocking Historical Stock Market Trends with Python Data Analysis and Visualization]]></title>
            <link>https://medium.com/analytics-vidhya/unlocking-historical-stock-market-trends-with-python-data-analysis-and-visualization-d515347a7a4f?source=rss-54ed1024d5a8------2</link>
            <guid isPermaLink="false">https://medium.com/p/d515347a7a4f</guid>
            <category><![CDATA[stock-market]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Chaithanya Vamshi]]></dc:creator>
            <pubDate>Sat, 25 Feb 2023 16:41:34 GMT</pubDate>
            <atom:updated>2023-02-25T16:41:34.512Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/612/1*zUke5pjzkz4t6goMZuiTFw.png" /><figcaption>Stock Market Data Analysis</figcaption></figure><p>Have you ever wondered what is the secret behind successful stock market investments? The answer is the stock market is a world of numbers and data. But how do you make sense of it all?</p><p>In this article, we will explore how Python can help us gain insights into stock market trends, analyze, and visualize stock market data to make more informed investment decisions.</p><h3>Introduction to Stock Market Data Analysis with Python</h3><p>Stock market data analysis is analyzing historical and current stock market data to identify trends, patterns, and relationships between different variables.</p><p>Python is an open-source programming language that has the ability to interact with various databases and APIs, making it the perfect tool for data analysis and visualisation.</p><p>In this project, we will be using Python and its libraries to retrieve, analyze, and visualize historical stock market data. We will be using the Yahoo Finance API library to retrieve stock data for a specific time period and stocks. We will then analyze and visualize the data using Pandas, Microsoft Excel, and Plotly.</p><h3>Historical Stock Market Trends</h3><p>In order to gain insights from historical stock market trends, it is essential to understand the underlying trends, correlations, and movements.</p><ol><li><strong>Price Movements:</strong> By analyzing the historical stock prices, we can identify the trend&#39;s direction and the movements&#39; magnitude.</li><li><strong>Volume Changes:</strong> By analyzing the volume of traded stocks, we can identify the level of interest in the stock.</li><li><strong>Correlations: </strong>By analyzing the correlations between different stocks, we can identify which stocks are more likely to move in the same direction.</li><li><strong>Volatility:</strong> By analyzing the volatility of a stock, we can identify the risk associated with the stock.</li></ol><h3>Getting Started with Stock Market Terminology</h3><p>In the stock market, there are several key data points that are used to track the performance of a particular stock. These include:</p><ol><li><strong>Open:</strong> The opening price is the price at which a stock or index starts trading at the beginning of the trading day.</li><li><strong>Close:</strong> The closing price is the last/final price at which a stock or index trades at the end of the trading day.</li><li><strong>High:</strong> The high price is the highest price at which a stock or index trades during the trading day.</li><li><strong>Low:</strong> The low price is the lowest price at which a stock or index trades during the trading day.</li><li><strong>Adjusted Close: </strong>The adjusted close price is the closing price of a stock or index adjusted for any corporate actions that have taken place, such as stock splits or dividend payments.</li><li><strong>Volume: </strong>The volume is the total number of shares of a stock or contracts of an index that has been traded during the trading day.</li></ol><h3>Project Requirements</h3><p>To run this project, you will need to have the following requirements:</p><ol><li>Python 3</li><li>Pandas</li><li>xlrd</li><li>DateTime</li><li>Plotly</li><li>yfinance</li></ol><p>To install the required libraries, run the following command:</p><pre>pip install pandas xlrd DateTime plotly yfinance</pre><h3>Implementation</h3><p>Let’s dive in and see what Python can do for us in the world of stock market data analysis and visualization!</p><h3>Step 1: Import Required Libraries</h3><p>The first step is to import all the required libraries. In this project, we will be using y<strong>finance API library to</strong> retrieve stock data, <strong>datetime</strong> to handle dates, <strong>Pandas</strong> to analyze the data, and <strong>Plotly</strong> to visualize the data.</p><pre># import all libraries from requirements.txt<br>import yfinance as yf<br>from datetime import datetime<br>import pandas as pd<br>import plotly.graph_objs as go<br>import plotly</pre><h3>Step 2: Specify Stock Dates and Stock Ticker</h3><p>The next step is to specify the stock ticker and the time period for which we want to retrieve the stock data. We then specify the start and end dates in the format of <strong>YYYY-MM-DD</strong>.</p><p>To retrieve multiple tickers, separate stock tickers with spaces enclosed in single quotes. Below are a few top stock companies from which you can explore and retrieve the data.</p><p><strong>AAPL: Apple Inc, GOOG: Google Inc, MSFT: Microsoft Corp, TSLA: Tesla Inc and AMZN: Amazon.com Inc</strong></p><pre># Get Stock Data by specifying in the format of (YYYY-MM-DD)<br>start = &quot;2021-12-31&quot;<br>end = &quot;2023-01-01&quot;<br><br># Specify the stock tickers<br>tickers = &#39;AAPL&#39;<br><br># To retrieve multiple tickers, separate them with spaces<br>tickers = &#39;AAPL GOOG MSFT TSLA AMZN&#39;</pre><h3>Step 3: Retrieve Stock Data</h3><p>The next step is to retrieve the stock data using the Yahoo Finance API library. we use the <strong>yf.download() </strong>function from the yfinance library to retrieve the stock data and store it in the <strong>pandas dataframe</strong>. Later, we then format and reset the index of the dataframe to the desired date format.</p><pre># Retrieve the data from Yahoo API and store in a pandas dataframe<br>df = yf.download(tickers, start=start, end=end)<br><br># Formating the date index<br>df.index = df.index.strftime(&#39;%Y-%m-%d&#39;)<br><br># Reset the index to reset the date into a column in dataframe<br>df = df.reset_index()</pre><h3>Step 4: Export Stock Data to Excel</h3><p>Once we have retrieved the stock data, we can export it to an Excel file using Pandas.</p><pre># Export the data into excel file<br>df.to_excel(&#39;AAPL_Stock_data.xlsx&#39;)</pre><h3>Step 5: Visualize Stock Market Data using Plotly</h3><p>The next step is to create a candlestick plot to visualize the stock data. We will be using Plotly to create the candlestick plot.</p><pre># Create Candlestick Plot with Plotly<br>fig = go.Figure(data=[go.Candlestick(x=df[&#39;Date&#39;], open=df[&#39;Open&#39;],<br>                high=df[&#39;High&#39;], low=df[&#39;Low&#39;], close=df[&#39;Adj Close&#39;])])</pre><h3>Step 6: Customize the Candlestick Plot</h3><p>We can customize the plot by changing the background colour, removing gridlines, and updating the header title, x-axis, and y-axis titles.</p><pre># Black Background and no gridlines<br>fig.update_layout(plot_bgcolor=&#39;rgb(0,0,0)&#39;, xaxis={&#39;showgrid&#39;: False},yaxis={&#39;showgrid&#39;: False})<br><br># Export Candlestick Chart to HTML<br>fig.update_layout(title=&#39;Apple Inc Stock Price Analysis&#39;, yaxis_title=&#39;Stock Price(USD)&#39;)</pre><h3>Step 7: Export Candlestick Chart to HTML</h3><p>Finally, we can export the candlestick chart to an HTML file using Plotly.</p><pre># Export Candlestick Chart to HTML<br>plotly.offline.plot(fig, filename=&#39;Stock_Analysis.html&#39;)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jCgee2EQqTwb7LIeXugSqg.png" /></figure><h3>Demo Video</h3><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FaY-LUND6IWM%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DaY-LUND6IWM&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FaY-LUND6IWM%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/4b7c0075968f49779af27e7674122204/href">https://medium.com/media/4b7c0075968f49779af27e7674122204/href</a></iframe><h3>Best Practices for Stock Market Analysis with Python</h3><p>Python is a powerful tool for stock market analysis. Here are some of the best practices to follow when using Python for stock market analysis:</p><ol><li><strong>Use the right data:</strong> It is important to use the right data for stock market analysis. Make sure to use data that is accurate and up to date.</li><li><strong>Understand the data:</strong> Understand the relationships between different variables and identify any outliers.</li><li><strong>Develop Algorithms: </strong>Develop algorithms that can identify patterns in the data and make predictions.</li><li><strong>Test Models:</strong> Make sure to backtest your models and identify any errors.</li><li><strong>Monitor Results:</strong> Monitor your results to identify any changes in the stock market.</li></ol><h3>Conclusion</h3><p>This article showed how to retrieve stock market data using the Yahoo Finance API library and visualize it using Plotly in Python. The code can also be easily customized to retrieve data for multiple stocks and to change the date range. With this project, we can explore more complex data analysis and visualization techniques to gain deeper insights into stock market trends and make better investment decisions.</p><p>Thank you for taking the time to read this article and would like to see the code behind the analysis, you’re in luck! Here is the <a href="https://github.com/ChaithanyaVamshi/Stock-Market-Data-Analysis"><strong>GitHub link</strong></a> where you can find the code and experiment with it yourself.</p><p>Feel free to leave comments on the article and let’s connect on <a href="https://www.linkedin.com/in/chaithanyavsai/"><strong>LinkedIn</strong></a> to learn and grow together in the exciting world of data analysis and visualization!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d515347a7a4f" width="1" height="1" alt=""><hr><p><a href="https://medium.com/analytics-vidhya/unlocking-historical-stock-market-trends-with-python-data-analysis-and-visualization-d515347a7a4f">Unlocking Historical Stock Market Trends with Python Data Analysis and Visualization</a> was originally published in <a href="https://medium.com/analytics-vidhya">Analytics Vidhya</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Exploratory Data Analysis(EDA) For Predicting Hotel Booking Cancellations Using Machine Learning]]></title>
            <link>https://medium.com/analytics-vidhya/exploratory-data-analysis-eda-for-predicting-hotel-booking-cancellations-using-machine-learning-3990be4af2ff?source=rss-54ed1024d5a8------2</link>
            <guid isPermaLink="false">https://medium.com/p/3990be4af2ff</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[eda]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[hospitality]]></category>
            <category><![CDATA[machine-learning]]></category>
            <dc:creator><![CDATA[Chaithanya Vamshi]]></dc:creator>
            <pubDate>Wed, 15 Jul 2020 22:10:48 GMT</pubDate>
            <atom:updated>2020-07-19T16:30:03.745Z</atom:updated>
            <content:encoded><![CDATA[<p>Booking cancellations have a substantial impact on demand management decisions in the hospitality industry.</p><p>Every year, more than <strong>140 million bookings</strong> were made on the internet and many hotel bookings were booked through top-visited travel websites like Booking.com, Expedia.com, Hotels.com, etc.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/798/1*-Ejvinw5XTxSQ5E3e9WtoQ.png" /></figure><h3>Hotel Booking Cancellations, A Growing Problem…</h3><p>When Analyzing the past 5 years data, D-Edge Hospitality Solutions has found that the global average of cancellation rate on bookings has reached <strong>almost 40%</strong> and this trend produces a very negative impact on hotel revenue and distribution management strategies.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/854/1*VkolCLp7BenrQt049aYP1Q.png" /></figure><p>To overcome the problems caused by booking cancellations, hotels implement <strong>rigid cancellation policies, inventory management,</strong> and <strong>overbooking strategies,</strong> which can also have a negative influence on revenue and reputation.</p><p>Once the reservation has been canceled, there is almost nothing to be done and it creates discomfort for many Hotels and Hotel Technology companies. <strong>Therefore, predicting reservations which might get canceled and preventing these cancellations will create a surplus revenue for both Hotels and Hotel Technology companies.</strong></p><h3><strong>Motivation</strong></h3><p><strong>Have you ever wondered what if there was a way you could predict which guests were likely to cancel and adjust the overbook rate accordingly? That would be great right?</strong></p><p>Luckily, by using <strong>Machine learning</strong> with <strong>Python</strong>, we can predict the guests who are likely to cancel the reservation and this could help produce better <strong>forecasts</strong> and <strong>reduce uncertainty</strong> in business decisions.</p><p>In this article, I will apply <strong>Exploratory Data Analysis (EDA)</strong> to get insights from the <a href="https://www.kaggle.com/jessemostipak/hotel-booking-demand">data set</a> to know which features have contributed more in predicting cancellations by performing <strong>Data visualization with Matplotlib &amp; Seaborn.</strong> It is always a good practice to understand the data first and try to gather as many insights from it.</p><p><strong>Exploratory Data Analysis (EDA) with Data Visualization</strong></p><p>To better understand the <a href="https://www.kaggle.com/jessemostipak/hotel-booking-demand">dataset</a>, we have to come up with a list of questions.</p><ol><li><strong>What are the Top 10 Countries of Origin of Hotel visitors (Guests)</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/736/1*imy9ftTVJIeC7rcvMRIWeQ.png" /></figure><ul><li>Around <strong>40%</strong> of all bookings were booked from <strong>Portugal</strong> followed by Great Britain(10%) &amp; France(8%).</li></ul><p><strong>2. Which Month is the Most Occupied with Bookings at the Hotel?</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/736/1*awtYDZMtZ28mHqEh5egv2g.png" /></figure><ul><li>According to the graph, <strong>August</strong> is the most <strong>occupied</strong> (busiest) month with <strong>11.62%</strong> bookings and <strong>January</strong> is the most <strong>unoccupied</strong> month with <strong>4.96% </strong>bookings.</li></ul><p><strong>3. How many Bookings were Cancelled at the Hotel?</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/353/1*5OvjOlf0tPNA4jjGGqqs9Q.png" /></figure><ul><li>According to the pie chart, <strong>63%</strong> of bookings were not canceled and <strong>37%</strong> of the bookings were canceled at the Hotel.</li></ul><p><strong>4. Which Month Has Highest Number of Cancellations By Hotel Type?</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*EbR7ffsG3u3C9q1HotnnPg.png" /></figure><ul><li>For the <strong>City</strong> hotel, the number of cancelations per month is around<strong> 40 % </strong>throughout the year and for the <strong>Resort</strong> hotel, the cancellations are highest in June, July &amp; August and lowest during November, December &amp; January.</li></ul><p><strong>5. How many Bookings were Cancelled by Hotel Type?</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/457/1*dY5CU3Z76vRCZKGjrBXqyw.png" /></figure><ul><li>For the Resort Hotel, a total of <strong>25.14%</strong> Bookings were canceled and for the City Hotel, a total of <strong>74.85%</strong> Bookings were canceled.</li></ul><p><strong>6. Relationship between Average Daily Rate(ADR) and Arrival Month by Booking Cancellation Status</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/724/1*faJdSppqhKOOINbPIpCcMw.png" /></figure><ul><li>The highest Average Daily Rate (ADR) has occurred in<strong> August</strong> and due to the highest ADR in August, maybe it could be one of the reasons for more cancelations in August.</li></ul><p><strong>7. Total Number of Bookings by Market Segment</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/736/1*xDkbh-YQ8DbpocPKWdNikw.png" /></figure><ul><li>Around <strong>47%</strong> of bookings are made via <strong>Online Travel Agents</strong>, almost <strong>20%</strong> of bookings are made via <strong>Offline Travel Agents </strong>and less than<strong> 20%</strong> are <strong>Direct</strong> bookings without any other agents.</li></ul><p><strong>8. Arrival Date Year vs Lead Time By Booking Cancellation Status</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/724/1*8gyrHI_ORuHoPEPRAVDFjw.png" /></figure><ul><li>For all the 3 years, bookings with a <strong>lead time</strong> less than 100 days have fewer chances of getting canceled, and lead time more than 100 days have more chances of getting canceled.</li></ul><p><strong>9. Relationship between Special Requests and Cancellations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/458/1*QVo4fr_ss594ZJPcb3uA7w.png" /></figure><ul><li>Around <strong>28%</strong> of bookings were canceled with <strong>no</strong> special requests from the guests followed by <strong>6%</strong> bookings were canceled with <strong>one</strong> special request from the guests.</li></ul><p><strong>10. How does the ADR Vary Over the Year by Hotel Type</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/724/1*9W-QAtJz5dEyJfBWbWseFQ.png" /></figure><ul><li>For Resort Hotel, ADR is more expensive during July, August &amp; September and for City Hotel, ADR is slightly more during March, April &amp; May.</li></ul><p><strong>11. What is the Effect of Deposit Type on Cancellations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/457/1*AqbeHa52WiVH2zzrJSxmkg.png" /></figure><ul><li>Around <strong>28%</strong> of bookings were canceled by guests with <strong>no deposit</strong>, followed by <strong>22%</strong> bookings were canceled with <strong>Refundable.</strong></li><li>So it&#39;s obvious that guests who do not pay any deposit while booking are likely to cancel more reservations.</li></ul><h4>Business Summary</h4><p>From our EDA, we have observed that the top 5 most important features in the data set which helps in predicting Cancellations from the guests are :</p><ol><li>Lead Time</li><li>ADR</li><li>Deposit Type</li><li>Arrival Day of the Month</li><li>Total Number of Special Requests</li></ol><h4>Strategies to Counter High Cancellations at the Hotel</h4><ul><li>Set Non-refundable Rates, Collect deposits, and implement more rigid cancellation policies.</li><li>Using Advanced Purchase Rates with varying Lead Time windows</li><li>Encourage Direct bookings by offering special discounts</li><li>Hotels should consider the total number of special requests from guests to reduce the possibility of cancellations by improving customer service.</li><li>Monitor where the cancellations are coming from such as Market Segment, distribution channels, etc.</li></ul><p>As always, I welcome feedback and constructive criticism. Python Code for Data Visualization is available on <a href="https://github.com/ChaithanyaVamshi/HotelCancellationPredictor/blob/master/EDA.ipynb">GitHub</a> and I can also be reached on <a href="https://www.linkedin.com/in/chaithanyavamshi/">LinkedIn</a>.</p><h4>References</h4><ol><li><a href="https://www.pegs.com/blog/how-hotels-can-counter-high-ota-cancellation-rates/">https://www.pegs.com/blog/how-hotels-can-counter-high-ota-cancellation-rates/</a></li><li><a href="https://www.d-edge.com/how-online-hotel-distribution-is-changing-in-europe/">https://www.d-edge.com/how-online-hotel-distribution-is-changing-in-europe/</a></li><li><a href="https://www.kaggle.com/jessemostipak/hotel-booking-demand">https://www.kaggle.com/jessemostipak/hotel-booking-demand</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3990be4af2ff" width="1" height="1" alt=""><hr><p><a href="https://medium.com/analytics-vidhya/exploratory-data-analysis-eda-for-predicting-hotel-booking-cancellations-using-machine-learning-3990be4af2ff">Exploratory Data Analysis(EDA) For Predicting Hotel Booking Cancellations Using Machine Learning</a> was originally published in <a href="https://medium.com/analytics-vidhya">Analytics Vidhya</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>