Analyze It
Analyze It
  • Видео 40
  • Просмотров 134 872
Create visualizations with ChatGPT and get the Python codes
Unlock the power of AI with ChatGPT and take your data visualization skills to the next level! In this 2 minutes video, I’ll show you how to leverage ChatGPT for creating stunning correlation heatmaps and then get the Python codes. Whether you're a data analyst, a student, or just someone looking to enhance your data presentation skills, this step-by-step guide will empower you to transform complex data into beautiful and insightful visuals with ease.
Просмотров: 68

Видео

Instantly analyze image, charts & generate report with ChatGPT4o
Просмотров 172Месяц назад
Discover the incredible potential of ChatGPT-4o ! In this video, I'll guide you through how to leverage OpenAI's multimodal chatbot to analyze charts directly from images. Learn how to prompt the model to create a comprehensive Word document that highlights key insights, findings, and takeaways. Finally, watch as the model generates a downloadable link for your ready-made report. Elevate your d...
Transform Your Fridge into Delicious Meals with ChatGPT 4o
Просмотров 49Месяц назад
Discover how you can revolutionize your kitchen routine using ChatGPT 4o! In this video, I'll show you how to upload a picture of your refrigerator's contents and let ChatGPT 4o analyze it for you. Watch as I receive insightful suggestions on what dishes I can prepare based on what's in my fridge. It's an easy, fun, and smart way to make the most out of your groceries and try new recipes. Join ...
Translate French PDFs to English Word Docs Using ChatGPT
Просмотров 692 месяца назад
I'll be demonstrating the incredible power of ChatGPT for seamless translations. Watch as I take a French PDF document and transform it into a beautifully formatted English Word document with just a few simple prompts. I'll walk you through the entire process, from designing the perfect prompt to ensuring accurate and clear translations. Whether you're a student, professional, or just curious a...
Transform Your Notes: Handwritten to Digital Text with ChatGPT OCR
Просмотров 8625 месяцев назад
This video is a step-by-step guide on how to transform any text captured in a photo into typed text effortlessly. Whether it's notes from a meeting, pages from a book, or just a random piece of paper you found interesting, I'll show you how to transcribe it quickly and accurately. We're diving into the world of OCR - Optical Character Recognition technology, and I'll be using ChatGPT, a powerfu...
Connecting and fetching data from Kobo toolbox in Python
Просмотров 3195 месяцев назад
In this tutorial, I demonstrate the process of linking Kobo Toolbox with Python to retrieve data. Detailed instructions are given on how to accomplish this using Google Colab. You can access the entire code for this tutorial using that link github.com/naeljb/python/blob/branch-1/kobo_in_python_version_github.ipynb
Easy Audio to Text using Python & OpenAI
Просмотров 9916 месяцев назад
In this tutorial, I demonstrate the process of converting an audio file into text format by using Python and the OpenAI speech-to-text engine. The focus will be on utilizing the OpenAI API to accurately transcribe and translate a single audio file in Python. You will find the entire code for this tutorial in my github account. Use that link: github.com/naeljb/speech-to-text/blob/main/Transcribe...
Demo of audio transcriber application
Просмотров 336 месяцев назад
This video is a demonstration of the alpha version of an application that I developed that allows to transcribe audio record into text. I utilized Whisper-1, a speech transcription model developed by OpenAI (the creators of ChatGPT) to build this application. It cost me only 0.06 cents per minute of audio transcribed and it has high level of accuracy for 57 different languages including English...
How to create a customized map with google my map
Просмотров 9211 месяцев назад
In this video, I’m showing how you can import a dataset that is composed with a list of locations and their GPS coordinate to create a customized map. I’m using google drive for my map to build that map.
Use of ChatGPT for missing values handling
Просмотров 16311 месяцев назад
In this tutorial, I will demonstrate how ChatGPT can assist you in managing missing values while cleaning structured datasets. The primary focus will be on employing techniques such as imputation, deletion, and KNN machine learning to effectively handle the missing data. By the end of the video, you will have a clear understanding of how to leverage ChatGPT's capabilities for seamless data prep...
How to run Machine Learning with ChatGPT plugin
Просмотров 17111 месяцев назад
This video demonstrates how to use ChatGPT plugin to run machine learning. I specifically show how to run K-Means cluster using Notable plugin. I will show how to upload a dataset from Notable to ChatGPT, then I will type prompts to run K-Means algorithm with python codes.
Analyse de données et creation d'information a l'aide de ChatGPT
Просмотров 29611 месяцев назад
Dans cette vidéo, je démontre l'utilisation de l'interpréteur de code ChaptGPT dans le but d'analyser une base de données, de générer des graphiques visuels et d'extraire des informations simplement en tapant une question ou un prompte. En outre, je montre comment demander à ChatGPT de rédiger un brouillon d’article sur en utilisant la base de données, et je montre la possibilité d'améliorer l'...
Dataset insights through ChatGPT
Просмотров 96Год назад
In this video, I demonstrate the utilization of the ChaptGPT code interpreter for the purpose of analyzing a dataset, generating visual charts, and extracting insights simply by typing a question or prompt. Furthermore, I showcase the ability to request ChatGPT to draft an article based on the provided dataset, and highlight the potential for enhancing the article by providing additional contex...
Partitioning a dataset with an optimum number of clusters
Просмотров 83Год назад
In this video, I'm showing how to determine the optimum number of clusters with K-Means Machine Learning. Specifically, I discuss the inertia measurement and the elbow method. Finally, I use a dataset and compute the optimum number of cluster and then run K-mean clustering in Python. Through this video (project), I'm using several libraries such as Pandas, Numpy, Matplotlib, Seaborn and SKlearn...
How to generate barcodes from a customer list in Excel
Просмотров 64Год назад
How to generate barcodes from a customer list in Excel
Concatenate columns in Excel
Просмотров 44Год назад
Concatenate columns in Excel
How to do a pairplot in Power BI using Python
Просмотров 430Год назад
How to do a pairplot in Power BI using Python
Comment importer un tableau d'une page Web vers Excel
Просмотров 1,3 тыс.Год назад
Comment importer un tableau d'une page Web vers Excel
How to import a table from a web page into Excel or Power BI
Просмотров 788Год назад
How to import a table from a web page into Excel or Power BI
How to do a Paired T-test with Excel ?
Просмотров 105Год назад
How to do a Paired T-test with Excel ?
Descriptive Statistics Table in Excel
Просмотров 2,2 тыс.2 года назад
Descriptive Statistics Table in Excel
Creating a new table using a conditional column from another table in Excel
Просмотров 2,9 тыс.2 года назад
Creating a new table using a conditional column from another table in Excel
Automating conditional column values in Kobo Toolbox using Power BI
Просмотров 3102 года назад
Automating conditional column values in Kobo Toolbox using Power BI
Automation of data update and transformation in Power BI from Kobo Toolbox
Просмотров 3,4 тыс.2 года назад
Automation of data update and transformation in Power BI from Kobo Toolbox
Pivoting column table in Excel via Power Query
Просмотров 712 года назад
Pivoting column table in Excel via Power Query
Inner Joint with Excel via Power Query
Просмотров 1202 года назад
Inner Joint with Excel via Power Query
Clustering and outliers detection with DBSCAN in Power BI
Просмотров 7042 года назад
Clustering and outliers detection with DBSCAN in Power BI
Python Machine Learning in Power Bi : Decision Tree algorithm
Просмотров 7942 года назад
Python Machine Learning in Power Bi : Decision Tree algorithm
Python Machine Learning in Power BI: K-Means algorithm
Просмотров 1,6 тыс.2 года назад
Python Machine Learning in Power BI: K-Means algorithm
Python in Power BI, part 4 : Correlation heatmap
Просмотров 1,5 тыс.2 года назад
Python in Power BI, part 4 : Correlation heatmap

Комментарии

  • @devoneybrandon5784
    @devoneybrandon5784 6 часов назад

    Thank you! This is truly helpful!

  • @prashantkumar-hu7hd
    @prashantkumar-hu7hd Месяц назад

    how to use audio link instead of file

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Месяц назад

      Have you try to put the url link ? # create a variable that provides the path of your audio file audio_path = " include your URL link "

  • @pedrofelipe6161
    @pedrofelipe6161 Месяц назад

    could you help me ? When i execute the fourth step this error occurs: JSONDecodeError Traceback (most recent call last) File ~\AppData\Roaming\Python\Python311\site-packages equests\models.py:971, in Response.json(self, **kwargs) 970 try: --> 971 return complexjson.loads(self.text, **kwargs) 972 except JSONDecodeError as e: 973 # Catch JSON-related errors and raise as requests.JSONDecodeError 974 # This aliases json.JSONDecodeError and simplejson.JSONDecodeError File C:\ProgramData\anaconda3\Lib\json\__init__.py:346, in loads(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw) 343 if (cls is None and object_hook is None and 344 parse_int is None and parse_float is None and 345 parse_constant is None and object_pairs_hook is None and not kw): --> 346 return _default_decoder.decode(s) 347 if cls is None: File C:\ProgramData\anaconda3\Lib\json\decoder.py:337, in JSONDecoder.decode(self, s, _w) 333 """Return the Python representation of ``s`` (a ``str`` instance 334 containing a JSON document). 335 336 """ --> 337 obj, end = self.raw_decode(s, idx=_w(s, 0).end()) 338 end = _w(s, end).end() File C:\ProgramData\anaconda3\Lib\json\decoder.py:355, in JSONDecoder.raw_decode(self, s, idx) 354 except StopIteration as err: --> 355 raise JSONDecodeError("Expecting value", s, err.value) from None 356 return obj, end JSONDecodeError: Expecting value: line 2 column 1 (char 1) During handling of the above exception, another exception occurred: JSONDecodeError Traceback (most recent call last) Cell In[9], line 1 ----> 1 data = kobo.get_data(form_id) File ~\AppData\Roaming\Python\Python311\site-packages\koboextractor\__init__.py:143, in KoboExtractor.get_data(self, asset_uid, query, start, limit, submitted_after) 141 if self.debug: print(f'KoboExtractor.get_data: Calling {url}') 142 response = requests.get(url, headers=headers) --> 143 return response.json() File ~\AppData\Roaming\Python\Python311\site-packages equests\models.py:975, in Response.json(self, **kwargs) 971 return complexjson.loads(self.text, **kwargs) 972 except JSONDecodeError as e: 973 # Catch JSON-related errors and raise as requests.JSONDecodeError 974 # This aliases json.JSONDecodeError and simplejson.JSONDecodeError --> 975 raise RequestsJSONDecodeError(e.msg, e.doc, e.pos) JSONDecodeError: Expecting value: line 2 column 1 (char 1) any idea what it might be happening ?

  • @TassouIffa
    @TassouIffa Месяц назад

    Many thanks ! good explanation

  • @user-vr4mo5lw3q
    @user-vr4mo5lw3q 2 месяца назад

    Could you please create a video demonstrating how to integrate Kobotoolbox into an ASP MVC C# application using its API?

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Месяц назад

      Unfortunately, ASP.NET MVC application in C# is not my domain of knowledge

  • @ghitalahlou660
    @ghitalahlou660 3 месяца назад

    does it work with math formulas?

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Месяц назад

      Good question, I have not tested this but perhaps you could experiment this

  • @cradleofrelaxation6473
    @cradleofrelaxation6473 4 месяца назад

    This is helpful

  • @aldocastillo1194
    @aldocastillo1194 4 месяца назад

    wonderful video

  • @Marion-cosby
    @Marion-cosby 5 месяцев назад

    Thank you

  • @user-jb8nc1um5f
    @user-jb8nc1um5f 5 месяцев назад

    I liked it and I subscribed :) great work :)

  • @Jean-nh9sb
    @Jean-nh9sb 5 месяцев назад

    Great video!

  • @msughmosesatser5306
    @msughmosesatser5306 5 месяцев назад

    Thank you so much. I never seen a very simple way of controlling outliers in your dataset as good as this.

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael 5 месяцев назад

      Glad it was helpful!

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael 5 месяцев назад

      Also please note that z-score method assumes the data sets has a frequency distribution that are mound shaped and symmetric.

  • @AnalyzeIt_Nael
    @AnalyzeIt_Nael 5 месяцев назад

    In this video, I was using a hold version of openai module. If you have installed and updated version, the openai.Audio.transcribe method that I used to create the transcript variable will not work. Instead use openai.audio.transcriptions.create . I updated the code in github. Feel free to access it via this link github.com/naeljb/speech-to-text/blob/main/Transcribe%20audio%20in%20python%20with%20Whisper-1.ipynb You can also check openai website for documentation at : platform.openai.com/docs/guides/speech-to-text/quickstart

  • @Jean-nh9sb
    @Jean-nh9sb 6 месяцев назад

    Nice!

  • @vromilb
    @vromilb 6 месяцев назад

    What did you use to create this app? Do you have the exe file

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael 6 месяцев назад

      I used Tkinter. Yes, I have a executable file. For now it is the alpha version

  • @vromilb
    @vromilb 6 месяцев назад

    Very nice.

  • @qasimjan5258
    @qasimjan5258 6 месяцев назад

    I need an app that can translate audio in real time from portagues language to English. Is there any application like this?

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael 6 месяцев назад

      As I explained in the description of this video, I utilized Whisper-1 text to speech engine ( developed by OpenAI) for transcribe and then build this Application using Tkinter. You can then use the same engine and the translations API takes as input the audio file in any of the supported languages and transcribes, if necessary, the audio into English. This differs from /Transcriptions endpoint since the output is not in the original input language and is instead translated to English text. Being said my App for now doesn't do translation but this is something that is totally possible. Perhaps it is a good idea for further improvement by adding a window/feature for translation into English.

    • @qasimjan5258
      @qasimjan5258 6 месяцев назад

      @@AnalyzeIt_Nael I need it for learning Power BI but most of the best content I found is in Portuguese language.

  • @qasimjan5258
    @qasimjan5258 6 месяцев назад

    Congratulations🎉

  • @sebastiendellera8226
    @sebastiendellera8226 7 месяцев назад

    Merci, vous êtes très pédagogue.

  • @elwislinesabyjasmin6393
    @elwislinesabyjasmin6393 8 месяцев назад

    Merci beaucoup

  • @ashwinkumar5223
    @ashwinkumar5223 10 месяцев назад

    can you add more explanation points about two plots ?

  • @ashwinkumar5223
    @ashwinkumar5223 10 месяцев назад

    share github link for dataset

  • @ashwinkumar5223
    @ashwinkumar5223 10 месяцев назад

    Please share this dataset file

  • @jeanzenga8599
    @jeanzenga8599 11 месяцев назад

    Bonjour Nael, c’est super aidant, je vous fais un mail. Merci, Jean

  • @CasperLind1
    @CasperLind1 11 месяцев назад

    you just talk and show zero

  • @bologuelandry3011
    @bologuelandry3011 Год назад

    Merci pour ce partage très contributif

  • @fuckoffk5
    @fuckoffk5 Год назад

    hi, thank you a lot for your video. does this only work for power bi desktop or also for power bi online?

  • @abdelhakimhariss7125
    @abdelhakimhariss7125 Год назад

    très bonne explication, avec un bon rythme.Bravo

  • @vi-o-nanimy9438
    @vi-o-nanimy9438 Год назад

    Très bonne pédagogie ...je veux un prof particulier comme vous

  • @juliensombola9311
    @juliensombola9311 Год назад

    Thank you for the video but here is my problem : Web.Contents failed to get contents from the API, how will I solve this problem

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Год назад

      The error "Web.Contents failed to get contents from the API" in Excel typically means that Excel was unable to retrieve data from the specified API endpoint. This error can occur due to several reasons, such as incorrect API endpoint URL, missing or incorrect authentication credentials, network connectivity issues, or an issue with the API itself. To solve this problem, you can try the following steps: 1) Verify that the API endpoint URL is correct and active. 2) Check if you have provided the correct authentication credentials, such as API key, OAuth token, etc. 3) Ensure that your network connection is stable and there are no firewalls blocking the connection. 4) Try to access the API endpoint using a web browser or other tools to confirm that the endpoint is working correctly. 5) If the issue persists, you may need to contact the API provider or your IT department for further assistance. It is also worth noting that some APIs have rate limits or other usage restrictions that may cause errors, so make sure to check the API documentation for any such restrictions. Hope this helps

  • @Kevin-ex9vr
    @Kevin-ex9vr Год назад

    amazing! simple and effective, the way i like

  • @qasimali-gu3oz
    @qasimali-gu3oz Год назад

    Please also sentiment analysis in power query "dataset call" feature through python package like NLTK.

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Год назад

      Thank for your suggestion, this is an area that I'm currently investigating as well and how this can work best with Power BI.

  • @AnalyzeIt_Nael
    @AnalyzeIt_Nael Год назад

    You can find the PDF version of these codes via this URL drive.google.com/file/d/1Ghna1RtQcVzdCBHxLtKur66xjukMnd5M/view?usp=share_link You can also access the entire codes in Jupyter notebook via my Github account : github.com/naeljb/python/blob/main/KMeans_elbow_project.ipynb

  • @qasimjan5258
    @qasimjan5258 Год назад

    Thanks for this very informative video Sir. Please also do videos on this "Magic" dataset call. I think this take our data analysis to the next level. Hope you explore it further in your videos and I really keen to watch out and learn from your unique videos. Thank. ruclips.net/video/F2M4F4sUDw8/видео.html

  • @AnalyzeIt_Nael
    @AnalyzeIt_Nael Год назад

    The code 39 font that I'm using for this video can be found at www.1001freefonts.com/idautomation.com-code-39-barcode-font-free-version.font

  • @alexandrafigueiredo5844
    @alexandrafigueiredo5844 Год назад

    Hi, when I make my login tell me that my credention that was given to me, but I enter in the kobo toolbox to create the projects, and I have a lot of information that I need to transport to excel. Can you help me, and tell me what I need to do? That you for all support

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Год назад

      not sure I understand your problem. when you connect to the web in Power BI, you have to plug the URL of your project in KOBO. Then it will ask you to enter the logging and password and these are the one from your Kobo account

  • @adityakalra6340
    @adityakalra6340 Год назад

    Hi! Analyze It, Glad you know your development and Analysis on KMeans Clustering, And I hope you might have share the Elbow method as to make the basket of clusters. Cheers!

  • @nuwanherath4402
    @nuwanherath4402 Год назад

    Superb simple Explanation ... Very good easy to understand the content... Keep up the good work!!!!

  • @AnalyzeIt_Nael
    @AnalyzeIt_Nael Год назад

    The python codes for this video can be found here docs.google.com/document/d/1-q3Fh0rfZ6jLEHBH0Mf_Krl9_3iWyLSe/edit?usp=share_link&ouid=113822024531173115708&rtpof=true&sd=true

  • @JobShyaka
    @JobShyaka Год назад

    @Analyze it. Can I edit Data in the Excel and its also updated in Kobo? Thats it i linked them up

  • @elahehsamandi914
    @elahehsamandi914 Год назад

    Thank you, It was very helpful, and you explained it excellently!

  • @irfankhansafi5047
    @irfankhansafi5047 Год назад

    When I click XLS it doesn't download the file, it only shows blank white screen

  • @thanoo7640
    @thanoo7640 Год назад

    One issue, after loading data to excel, some of the data is missing. how can I fix it

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Год назад

      this is weird. Did you get an error message

  • @arsenicgirl1276
    @arsenicgirl1276 Год назад

    Hola! Disculpa, quería preguntar: a la hora de escribir la URL copiada desde word a Excel, me dice que no se encuentra la página web Sabes como se puede resolver esto?

  • @ROCKY-go3xs
    @ROCKY-go3xs Год назад

    merci pour l`explication asser claire

  • @eidrag
    @eidrag Год назад

    yes Kobo and Excel, great synergy

  • @albertyendor6043
    @albertyendor6043 Год назад

    please i have followed the steps but this is the error im getting; This error (HTTP 404 Not Found) means that this program was able to connect to the website, but the page you wanted was not found. It's possible that the webpage is temporarily unavailable. Alternatively, the website might have changed or removed the webpage.

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Год назад

      not sure why you are having this problem. Alternatively I would retry to connect to kobo with out have the dataset sharable mode. take a look at this video. ruclips.net/video/cRBfvqmejHM/видео.html&ab_channel=AnalyzeIt

    • @rangahuruba5836
      @rangahuruba5836 Год назад

      just update accessibility on project share to everyone and it works

  • @habtamu.a432
    @habtamu.a432 Год назад

    it is anice presentation

    • @AnalyzeIt_Nael
      @AnalyzeIt_Nael Год назад

      Thanks. I would also suggest you to take a look at the updated video that I made on that matter. in that one I'm showing how to do the same using your Kobo Account credential (i.e not making the project publicly available). ruclips.net/video/cRBfvqmejHM/видео.html&ab_channel=AnalyzeIt

  • @natachasuccess6523
    @natachasuccess6523 Год назад

    Merci beaucoup très intéressant

  • @zohasinasafidymiarantsoaai3125

    Wonderful! is there a way to automatically download media attachment files? thanks