full-view.html

<!DOCTYPE HTML>
<!--
  Massively by HTML5 UP
  html5up.net | @ajlkn
  Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
  <head>
    <title>Project on YouTube Data Harvesting and Warehousing
      using SQL, MongoDB Atlas and Streamlit</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
    <link rel="stylesheet" href="assets/css/main.css" />
    <noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>
  </head>
  <body class="is-preload">

    <!-- Wrapper -->
    <div id="wrapper" class="fade-in">

      <!-- Header -->
      <header id="header">
        <a href="index.html" class="logo">Explore</a>
      </header>
      <!-- Nav -->
					<nav id="nav">
						<ul class="links">
							<li class="active"><a href="elements.html">Back</a></li>
              
						</ul>
						<ul class="icons">
							<li><a href="https://twitter.com/Yuvarajm752768" class="icon brands fa-twitter"><span class="label">Twitter</span></a></li>
							<li><a href="https://www.linkedin.com/in/yuvarajmanoharan98/" class="icon brands fa-linkedin-in"><span class="label">LinkedIn</span></a></li>
							<li><a href="https://github.com/yuvarajrajdata/yuvarajrajdata" class="icon brands fa-github"><span class="label">GitHub</span></a></li>
						</ul>
					</nav>

      <!-- Main -->
      <div id="main">

        <!-- Project 01 -->
        <article class="project">
          <header class="major">
            <h2>Project 01</h2>
            <h3>Unleashing YouTube's Data: Harvesting and Warehousing with SQL, MongoDB, and Streamlit</h3>
          </header>
          <div style="display: flex; justify-content: center;">
            <img src="images/pic002.jpg" alt="" style="max-width: 400px;" />
          </div>
          <section>
            <h4>Project Description:</h4>
            <p>Discover and analyze YouTube channel data effortlessly with our Streamlit application. Harvest, store, and query data from multiple channels using Google API, MongoDB, and SQL database integration.</p>
            <h4>Domain:</h4>
            <p>Social Media</p>
            <h4>Technologies:</h4>
            <ul>
              <li>Python</li>
              <li>SQL</li>
              <li>MongoDB</li>
              <li>Streamlit</li>
              <li>YouTube API</li>
              <li>Jupyter notebook</li>
            </ul>
            <h4>Problem Statement:</h4>
            <p>The problem statement is to create a Streamlit application that allows users to access
                and analyze data from multiple YouTube channels. The application should have the
                following features.<p>
                <p> 1. Ability to input a YouTube channel ID and retrieve all the relevant data
                (Channel name, subscribers, total video count, playlist ID, video ID, likes,
                dislikes, comments of each video) using Google API.<p>
                <p>2. Option to store the data in a MongoDB database as a data lake.<p>
                <p> 3. Ability to collect data for up to 10 different YouTube channels and store them in
                the data lake by clicking a button.<p>
                </p>4. Option to select a channel name and migrate its data from the data lake to a
                SQL database as tables.</p>
                </p>5. Ability to search and retrieve data from the SQL database using different
                search options, including joining tables to get channel details.</p>

            <h4>Results:</h4>
            <p>This project aims to develop a user-friendly Streamlit application that utilizes the
                Google API to extract information on a YouTube channel, stores it in a MongoDB
                database, migrates it to a SQL data warehouse, and enables users to search for
                channel details and join tables to view data in the Streamlit app.</p>

                 <!-- Project buttons -->
                 <div class="project-buttons" style="text-align: center;">
                  <a href="https://www.linkedin.com/posts/yuvarajmanoharan98_youtube-dataanalysis-entertainment-activity-7077982351825272832-SXl5?utm_source=share&utm_medium=member_desktop" class="button primary project-button">Live Demo</a>
                  <a href="https://github.com/yuvarajrajdata/youtubeapiproject" class="button project-button">GitHub Repository</a>
              </div>
            
          </section>
        </article>

        <!-- Links -->
        <section class="links">
          <ul>
            <h4>Reference:</h4>
            <li><a href="https://docs.streamlit.io/library/api-reference">Link 1 : Streamlit</a></li>
            <li><a href="https://developers.google.com/youtube/v3/getting-started">Link 2 : Youtube API</a></li>
            <li><a href="https://github.com/yuvarajrajdata/youtubeapiproject">Link 3 : GitHub</a></li>
          </ul>
        </section>

      </div>

      <!-- Footer -->
      <footer id="footer">
        <section class="split contact">
          <section class="alt">
            <h3>Social</h3>
            <ul class="icons alt">
              <li><a href="https://twitter.com/Yuvarajm752768" class="icon brands alt fa-twitter"><span class="label">Twitter</span></a></li>
              <li><a href="https://www.linkedin.com/in/yuvarajmanoharan98/" class="icon brands alt fa-linkedin-in"><span class="label">LinkedIn</span></a></li>
              <li><a href="https://github.com/yuvarajrajdata/yuvarajrajdata" class="icon brands alt fa-github"><span class="label">GitHub</span></a></li>
            </ul>
          </section>
        </section>
      </footer>

    </div>

    <!-- Scripts -->
    <script src="assets/js/main.js"></script>

  </body>
</html>