Dataset insights through ChatGPT
24:45
Concatenate columns in Excel
1:25
Пікірлер
@WendpuireCONSEIGA
@WendpuireCONSEIGA 25 күн бұрын
Great tutorial. This is very helpful for me. Thank you
@srinivasseena6574
@srinivasseena6574 Ай бұрын
Superb
@devoneybrandon5784
@devoneybrandon5784 Ай бұрын
Thank you! This is truly helpful!
@prashantkumar-hu7hd
@prashantkumar-hu7hd 2 ай бұрын
how to use audio link instead of file
@AnalyzeIt_Nael
@AnalyzeIt_Nael 2 ай бұрын
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 3 ай бұрын
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 3 ай бұрын
Many thanks ! good explanation
@user-vr4mo5lw3q
@user-vr4mo5lw3q 4 ай бұрын
Could you please create a video demonstrating how to integrate Kobotoolbox into an ASP MVC C# application using its API?
@AnalyzeIt_Nael
@AnalyzeIt_Nael 3 ай бұрын
Unfortunately, ASP.NET MVC application in C# is not my domain of knowledge
@ghitalahlou660
@ghitalahlou660 4 ай бұрын
does it work with math formulas?
@AnalyzeIt_Nael
@AnalyzeIt_Nael 3 ай бұрын
Good question, I have not tested this but perhaps you could experiment this
@cradleofrelaxation6473
@cradleofrelaxation6473 6 ай бұрын
This is helpful
@aldocastillo1194
@aldocastillo1194 6 ай бұрын
wonderful video
@Marion-cosby
@Marion-cosby 6 ай бұрын
Thank you
@user-jb8nc1um5f
@user-jb8nc1um5f 6 ай бұрын
I liked it and I subscribed :) great work :)
@Jean-nh9sb
@Jean-nh9sb 6 ай бұрын
Great video!
@msughmosesatser5306
@msughmosesatser5306 7 ай бұрын
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 6 ай бұрын
Glad it was helpful!
@AnalyzeIt_Nael
@AnalyzeIt_Nael 6 ай бұрын
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 7 ай бұрын
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 7 ай бұрын
Nice!
@vromilb
@vromilb 7 ай бұрын
What did you use to create this app? Do you have the exe file
@AnalyzeIt_Nael
@AnalyzeIt_Nael 7 ай бұрын
I used Tkinter. Yes, I have a executable file. For now it is the alpha version
@vromilb
@vromilb 7 ай бұрын
Very nice.
@qasimjan5258
@qasimjan5258 7 ай бұрын
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 7 ай бұрын
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 7 ай бұрын
@@AnalyzeIt_Nael I need it for learning Power BI but most of the best content I found is in Portuguese language.
@qasimjan5258
@qasimjan5258 7 ай бұрын
Congratulations🎉
@sebastiendellera8226
@sebastiendellera8226 8 ай бұрын
Merci, vous êtes très pédagogue.
@elwislinesabyjasmin6393
@elwislinesabyjasmin6393 10 ай бұрын
Merci beaucoup
@ashwinkumar5223
@ashwinkumar5223 11 ай бұрын
can you add more explanation points about two plots ?
@ashwinkumar5223
@ashwinkumar5223 11 ай бұрын
share github link for dataset
@ashwinkumar5223
@ashwinkumar5223 11 ай бұрын
Please share this dataset file
@jeanzenga8599
@jeanzenga8599 Жыл бұрын
Bonjour Nael, c’est super aidant, je vous fais un mail. Merci, Jean
@CasperLind1
@CasperLind1 Жыл бұрын
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
@AnalyzeIt_Nael
@AnalyzeIt_Nael Жыл бұрын
Merci pour les mots d'encouragements.
@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. kzfaq.info/get/bejne/fJh9Z6ll2Luop2w.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!
@AnalyzeIt_Nael
@AnalyzeIt_Nael Жыл бұрын
I will
@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!
@AnalyzeIt_Nael
@AnalyzeIt_Nael Жыл бұрын
You are welcome
@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 2 жыл бұрын
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 2 жыл бұрын
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. kzfaq.info/get/bejne/mbhymdmi0svOeIE.html&ab_channel=AnalyzeIt
@rangahuruba5836
@rangahuruba5836 Жыл бұрын
just update accessibility on project share to everyone and it works
@habtamu.a432
@habtamu.a432 2 жыл бұрын
it is anice presentation
@AnalyzeIt_Nael
@AnalyzeIt_Nael 2 жыл бұрын
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). kzfaq.info/get/bejne/mbhymdmi0svOeIE.html&ab_channel=AnalyzeIt