Fanilo Andrianasolo
Fanilo Andrianasolo
  • 68
  • 758 642
I Ditched Excel Pivot Tables using these Python Tricks
Pandas has pivot tables, multilevel index pivot tables, multilevel row & column index pivot tables, cross-section selection, indexing through callables, multidimensional slicing...this video contains a quick peek for all of those
00:00 Intro
00:45 Install
01:50 Pivot
04:37 Multilevel index row
08:00 Mitosheet
08:48 Multilevel index column
---
📧 Check my email list for a compiled version of all my activities on all the Internet ➡ andfanilo-newsletter.streamlit.app/
💰 Buy me a coffee to stay awake while editing ➡ www.buymeacoffee.com/andfanilo
🗣️ Find my socials ➡ andfanilo.com
🔗 Links
- ExcelDemy tutorial: www.exceldemy.com/excel-data-for-pivot-table-practice/
- Automate Pandas workflow with Mitosheet: www.trymito.io/
🔧 My tools (Affiliate links to support me!)
- 📕 Streamlit Official Book - amzn.to/3QuRPwl
- 📷 Main Camera - amzn.to/3QvTosB
- 📷 Main Lens - amzn.to/3svYCwq
- 🎙️ Microphone - amzn.to/47l5ewA
- 🎵 Music & Sound Effects - www.epidemicsound.com/referral/a2p22s
---
🪶 Happy new Year!
⚠️ Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. Thank you for supporting my channel so I can continue providing you with free content!
#streamlit #python #datascience #dataapps
Переглядів: 1 221

Відео

A Cozy follow-along introduction to Streamlit | Python Dashboard
Переглядів 3,4 тис.2 місяці тому
Let's build a Streamlit dashboard together in 1h30! In this follow-along chill coding session, you will learn how to: - structure your Streamlit app - get an introduction to Streamlit's interactivity system - display interactive filters, charts and metric cards to answer a business question - all on a real dataset At the end, you will have the minimal tools to build your own multipage business ...
Streamlit Features You Always Ask Me About are Coming SOON
Переглядів 4,5 тис.4 місяці тому
A review of all features in preparation for Streamlit's 2024 year end 📧 Check my email list for a compiled version of all my activities on all the Internet ➡ andfanilo-newsletter.streamlit.app/ 💰 Buy me a coffee to stay awake while editing ➡ www.buymeacoffee.com/andfanilo 🗣️ Find my socials ➡ andfanilo.com 🔗 Links - Authentication prototype: github.com/kajarenc/stauthlib - New theming options: ...
I Tried Adding Google Auth To a Streamlit App (It Didn't Go Well)
Переглядів 5 тис.5 місяців тому
As a data analyst, do you wonder what it takes to add Google Authentication to your Python web app in Streamlit? Well, I tried it, it was a painful challenge...and I feel like a backend developer now. You will see how to: - Configure OAuth secrets - Use the Google oauth Python client to authenticate with your Google account - Build the OAuth flow in a separate FastAPI After this video, you will...
Archiving Streamlit Drawable Canvas - what's next?
Переглядів 2,9 тис.6 місяців тому
I'm ending all development on my Streamlit Components: Streamlit Drawable Canvas, Streamlit ECharts and Streamlit Lottie Upvote Streamlit Native Canvas here: github.com/streamlit/streamlit/issues/875 00:00 Origin Story 02:22 Video Content over OSS Maintenance 03:45 Go Upvote for native Canvas! 📧 Check my email list for a compiled version of all my activities on all the Internet ➡ andfanilo-news...
Your Most Requested Streamlit Features FINALLY Out!
Переглядів 17 тис.6 місяців тому
The latest updates for Streamlit are the most advanced, groundbreaking, and most requested by the community we got in a while: - A better multipage app configuration - Chart and DataFrame Selections - Partial Reruns and Dialog window - and many more! Browse through all the latest features from Streamlit version 1.33 to 1.36 in this new video! DataFans, Streamlit is going in a nice direction :) ...
EPIC Google Sheets to Interactive Dashboard in Python ft. Streamlit / CSS
Переглядів 29 тис.8 місяців тому
Looking for an end to end implementation of a live stocks dashboard from Google Sheets to a Python Web App? In this tutorial, you'll discover my comprehensive workflow to build my Streamlit web dashboard: - How I build a live Stocks tracker in a Google Sheets workbook - How I connect to Google Sheets from Python using @AirbyteHQ ( airbyte.com/product/pyairbyte ) - How I build the Streamlit app ...
Teasing Streamlit’s Next Biggest Changes
Переглядів 5 тис.9 місяців тому
The 5 latest releases seem to prepare the bigger Streamlit milestones. In this video you will see how the new features are smaller steps to big changes like multipage v2, dialog window and partial rerun/experimental fragment ☕ Want to support me? www.buymeacoffee.com/andfanilo 🐦Follow my daily updates on Twitter: andfanilo 🗣️ Find me on: andfanilo.com 🔗 Links - Popover Demo: popover...
Got Google Cloud Certified, So I Tested Streamlit on Cloud Run
Переглядів 3 тис.10 місяців тому
Is it worth passing the Google Cloud Platform "Professional Cloud Architect" certificate to learn about GCP, and think about migrating apps from Streamlit Cloud to GCP? ☕ Want to support me? www.buymeacoffee.com/andfanilo 🐦Follow my daily updates on Twitter: andfanilo 🗣️ Find me on: andfanilo.com 🔗 Links - GCP Cheatsheet: googlecloudcheatsheet.withgoogle.com/ - Google Cloud Skills B...
5 Things I Wish I Knew Before Learning Streamlit
Переглядів 40 тис.11 місяців тому
Would you like to understand the main limitations of the Streamlit Python library for building data web apps, before picking it up for a project? In this video, I'll cruise through 5 obstacles that regularly come back within the community and multiple ways/hacks/techniques to work around those limits. You'll find out: - how to hack markdown and iframe to style your app - if it's possible to alt...
GenAI could change Code Tutorials YouTube
Переглядів 1,7 тис.Рік тому
I took a 3 month break to think about the future of my channel...but then I started overthinking about how digital twins could help me upload way more tutorials, how LLMs could make it easy to write Javascript web prototypes in place of Streamlit, and how it will affect my overall UA-cam education strategy for 2024 GenAI is tearing through all parts of the job market, and developer educators ma...
How I Use OpenAI Assistants API To Control My Streamlit App
Переглядів 10 тис.Рік тому
Seen the OpenAI Dev Day Wanderlust Assistants API demo and wondering how to implement a similar web app in full Python? It's all thanks to the new Assistants API feature and its integrated Function Calling. In this video, I prototype a Streamlit version of the app. Through this quick overview, you'll learn to: - leverage Streamlit's Session State for a clean reactive app using an MVC-like patte...
If I was a Streamlit Beginner, I’d read this! - Epic Book Trailer
Переглядів 3 тис.Рік тому
The “Streamlit for Data Science” book by Tyler Richards just released an updated version 2. It provides the perfect project-based hands-down approach book to learn Streamlit. This trailer is proof of it. Giveaway Rules 1. Must be subscribed to my UA-cam channel 2. Comment on this video, like what app you would build first 3. Must be 18 years or older to enter (or have your parent’s permission) ...
EVERY Streamlit News You Might Have Missed in Spring/Summer
Переглядів 2,7 тис.Рік тому
Catch up with all the Streamlit news you might have missed this last semester! In this video, I'm going through: - all the releases for new features like editable dataframe, chatbot elements and st.connection, - community components like Mito or streamlit paywall for app monetization, - and integrations with other libraries like Langchain, AssemblyAI or Clarifai Eveything Streamlit-related for ...
I Built a Youtube Chatbot ft. AssemblyAI / Llamaindex / Weaviate
Переглядів 1,6 тис.Рік тому
I Built a UA-cam Chatbot ft. AssemblyAI / Llamaindex / Weaviate
Streamlit Reveals NEW CSS Styling Trick! (Here’s How to Use)
Переглядів 14 тис.Рік тому
Streamlit Reveals NEW CSS Styling Trick! (Here’s How to Use)
My Workflow for Building any Streamlit Dashboard Project
Переглядів 107 тис.Рік тому
My Workflow for Building any Streamlit Dashboard Project
Snowflake Has A New Strategy For Streamlit
Переглядів 2,1 тис.Рік тому
Snowflake Has A New Strategy For Streamlit
I Prepared a Talk About Being a YouTuber For a Dev Event
Переглядів 415Рік тому
I Prepared a Talk About Being a UA-camr For a Dev Event
Reacting to the Most Popular Streamlit LLM Apps
Переглядів 3,6 тис.Рік тому
Reacting to the Most Popular Streamlit LLM Apps
Kickstart your Custom Streamlit Chatbot (ft. CSS & Langchain)
Переглядів 21 тис.Рік тому
Kickstart your Custom Streamlit Chatbot (ft. CSS & Langchain)
An Unfiltered Deep Dive into Streamlit's Limitations
Переглядів 12 тис.Рік тому
An Unfiltered Deep Dive into Streamlit's Limitations
ChatGPT builds a Python Dash App for Me
Переглядів 2,4 тис.Рік тому
ChatGPT builds a Python Dash App for Me
This Streamlit Chatbot works over your Notion documents
Переглядів 4,2 тис.Рік тому
This Streamlit Chatbot works over your Notion documents
HTTPS, Global Secrets, App Embed | Streamlit v1.20-21
Переглядів 6 тис.Рік тому
HTTPS, Global Secrets, App Embed | Streamlit v1.20-21
The Epic 🤗 Hugging Face Tasks Overview
Переглядів 4,2 тис.Рік тому
The Epic 🤗 Hugging Face Tasks Overview
Streamlit App Showcase | Tips for making your app stand out!
Переглядів 14 тис.Рік тому
Streamlit App Showcase | Tips for making your app stand out!
What's new in Streamlit 1.18-19? | Sharing Some Thoughts..
Переглядів 2,4 тис.Рік тому
What's new in Streamlit 1.18-19? | Sharing Some Thoughts..
GPT is Taking Over the Streamlit Community
Переглядів 2,7 тис.Рік тому
GPT is Taking Over the Streamlit Community
How to Convert a Streamlit App to an .EXE Executable
Переглядів 53 тис.Рік тому
How to Convert a Streamlit App to an .EXE Executable

КОМЕНТАРІ

  • @exaucekaya3915
    @exaucekaya3915 День тому

    Puis-je avoir les données ?

  • @001Jocaqu
    @001Jocaqu 3 дні тому

    Hello Fanilo, always great videos! I was wondering have you ever used sqlite to make a database with several tables and use Streamlit to interact with the database?

    • @andfanilo
      @andfanilo 3 дні тому

      Hey, thanks for the support, greatly appreciated! I have used sqlite here and there to store prepared dataframes, but not as extensively as a local datawahouse with a bigger data model. I heard a lot of people do it, I might need to try at least once. Have you got issues with it?

    • @001Jocaqu
      @001Jocaqu 3 дні тому

      @andfanilo mainly it's due to me being a beginner and I am trying to set up like a system that helps the person track tasks and show their overall progress.

    • @andfanilo
      @andfanilo 3 дні тому

      @@001Jocaqu That's a good data app use case, you should definitely keep trying 🙂have you looked into SQLAlchemy's ORM to map SQLite tables to Python objects, or are you staying in full SQL with st.connection? If you find SQLAlchemy ORM a little too intimidating, SQLModel is also a lighter alternative ^^ Good luck!

    • @001Jocaqu
      @001Jocaqu 3 дні тому

      @andfanilo I have definitely not thought about it! I am mainly trying to get some practice in before I switch to a more cloud based database solutions like google cloud

    • @001Jocaqu
      @001Jocaqu 3 дні тому

      @@andfanilo also wanted to add a big thanks for inspirations, I never thought I would touch Python and mixing data analysis at all 😀, only used Tableau to represent my data

  • @islekcaganmert
    @islekcaganmert 5 днів тому

    I couldn't use any of them, so made my own instead. islekcaganmert/bevyframe on github

    • @andfanilo
      @andfanilo 3 дні тому

      Thks for sharing. The documentation URL didn't work though :(

  • @rodrigobogado653
    @rodrigobogado653 6 днів тому

    At that moment Excel felt true terror! Big fanilo

    • @andfanilo
      @andfanilo 5 днів тому

      Well maybe I’ll try the Python in Excel feature next eheh 😄

  • @merimagdi
    @merimagdi 6 днів тому

    we struggle a lot with pivot tables in streamlit. Our hope is to use st-aggrid. Have you tried it?

    • @andfanilo
      @andfanilo 5 днів тому

      Hello! I’ve tried it a year ago, I remember there are things it did very well but some of my use cases required a lot of reading aggrid documentation to configure the table in st-aggrid and I didn’t have time to dig into those configuration options… Also I was sad the aggrid community version didn’t include Sparklines 😞 What things are you trying to do?

  • @i-am-your-conscience
    @i-am-your-conscience 7 днів тому

    5:55 Also, try "Lightweight Charts" by Tradingview. The libary is super small, blazing fast and has a strong financial chart focus.

    • @andfanilo
      @andfanilo 6 днів тому

      Oh wow! I d some TradingView ticks but I never saw this charting library, thanks for sharing I’ll try it out 🙂

    • @i-am-your-conscience
      @i-am-your-conscience 6 днів тому

      @@andfanilo There are even 2 libraries to use it in Streamlit, altough I never tried them out personally. (I am talking about the combination) But I plan to, so a video including both would be interesting for me :)

  • @hoegge
    @hoegge 7 днів тому

    Thanks for another great video. Would you consider making a video on how to make your own custom components including sending data back to python. The docs from streamlit incl. videos are a bit dated and unclear. I'm sure your style would help a lot of people.

    • @hoegge
      @hoegge 7 днів тому

      Ah - one already - still up-to-date? ua-cam.com/video/TqOGBOHHxrU/v-deo.htmlsi=qqjJoGRdxOM_7uJe

    • @andfanilo
      @andfanilo 6 днів тому

      Hello! Thanks for the support! I considered doing a new tutorial, since my last video on UA-cam about it + a written tutorial streamlit-components-tutorial.netlify.app/ are from 2 years ago The api did not move much so these should be ok enough for now. I’m also kind of waiting if components are going to get an upgrade before committing to a new tutorial. Wait & see

  • @fintasticdatastudio8056
    @fintasticdatastudio8056 7 днів тому

    We need a pyhton streamlit forecast video!

    • @andfanilo
      @andfanilo 7 днів тому

      @@fintasticdatastudio8056 any favorite forecast library? I was a fb-prophet user before

    • @fintasticdatastudio8056
      @fintasticdatastudio8056 7 днів тому

      @andfanilo prophet is good. Xgboost will be sweet for big categorical data... but thats more data sciency👌

    • @andfanilo
      @andfanilo 6 днів тому

      Ahah been a while since my last xgboost rodeo ^^ all left is to find an interesting dataset, I’m bored of forecasting stock prices 😁

  • @CodingIsFun
    @CodingIsFun 7 днів тому

    *Nah, nothing beats Excel PivotTables* 😅... but it's still a great video, Fanilo 😉 Looks like you had a lot of fun slicing through all the data 🔪

    • @andfanilo
      @andfanilo 7 днів тому

      Ahah 😂 I still have some comments about drag & dropping fields in Streamlit like in excel so yeah…nothing will beat excel Yeah slicing was fun and it put me back in the mood of doing UA-cam videos 💪 Happy new year by the way 😄 wish you all the best successful surprises for 2025

    • @fintasticdatastudio8056
      @fintasticdatastudio8056 7 днів тому

      Yeah but can excel do xgBoost😁

    • @CodingIsFun
      @CodingIsFun 7 днів тому

      @@fintasticdatastudio8056 Yep, with Python in Excel

    • @CodingIsFun
      @CodingIsFun 7 днів тому

      @@andfanilo Thanks, Fanilo! Same to you. Wish you all the best for 2025! 💪🏼

  • @jorge1869
    @jorge1869 7 днів тому

    Learn Django, will change your life, even in data science. Greetings

    • @andfanilo
      @andfanilo 7 днів тому

      I mean, I did some Django but I don’t have any use cases that require its extensive ecosystem 😅 (well I could’ve tried Django-pivot here but eh, another time)

  • @bimaardhiavardhan
    @bimaardhiavardhan 11 днів тому

    lu op bgt bangg, mager banget nge css plis

  • @jaredalbin5658
    @jaredalbin5658 14 днів тому

    Dude. Love your humor and talent

  • @viniciusventura22
    @viniciusventura22 14 днів тому

    5:28 nice cards! How can I make one of these?

  • @satvikgupta2570
    @satvikgupta2570 14 днів тому

    What can I do, if my multipage website integrated with main.py doesn't run?

  • @MatichekYoutube
    @MatichekYoutube 18 днів тому

    blank window - I have api calls to gpt - is that the cause?

  • @CptKavlas
    @CptKavlas 21 день тому

    Love your presentation style and trying to explain in detail but also high level at the same time

    • @andfanilo
      @andfanilo 21 день тому

      Oh thank you for the support, reboosts me to edit my next video!

  • @slyle_finance_guy
    @slyle_finance_guy 24 дні тому

    we get mad at streamlit at work. omg does it make us mad. we need a react dev but we just don't have one right now and it's overkill for a lot of ML discovery

    • @andfanilo
      @andfanilo 24 дні тому

      Even as a Streamlit superfan, I feel your pain Have you tried Reflex? I still think it’s a bit overkill to quickly bootstrap ML showcases but it may be a good compromise between Streamlit and React

  • @adilbenmohamed5842
    @adilbenmohamed5842 28 днів тому

    hi fanilo is not working good by webdriver_manager and selenium ? why please help me?

  • @temyraverdana6421
    @temyraverdana6421 28 днів тому

    WOW!

  • @waleedahmed8740
    @waleedahmed8740 Місяць тому

    is there any drag and drop option in streamlit like drag and drop cards we doing in mircrosoft planner or trello?

  • @GodX36999
    @GodX36999 Місяць тому

    Anyway thank goodness

  • @GodX36999
    @GodX36999 Місяць тому

    I think streamlit is outdated, now taipy is at the edge of art and much more better