วีดีโอ

Happy Christmas

What did you research?

Excel on Mac is not great. Had this issue myself trying to extract xml file. One click on windows pain in the ass on Mac.

Thank you for the feedback…I would apply that to specific columns not the entire dataset.. whatever meets the need I suppose but a thousand ways to do everything with ML… what are you building at the moment ?

@@analyticswithadam I am currently learning at the moment. I have a car insurance dataset that has a lot of categorical variables, and I'm wondering how the dummie or OneHot encoding will make the dataset look like afterwards.... hahaha

@@GodspeedOkwuonu There are so many variables with insurance and bank loan datasets. Best of luck with it

Not yet .. Udemy is a good place to learn would recommend Leila Gharani’s sheets course . They normally run $10 sales. Start with that then SQL then Dashboard tool

@analyticswithadam Thanks

Glad if helped Chief

ChatGPT is a great resource to debug, not 100% but much better than searching online

What are you having problems with?

@@analyticswithadam "I'm a senior high school student and I'm just starting out with App Scripts. I'm working on a research project and could really use some help creating an App Script. Would you be able to guide me through the process?"

@@analyticswithadam Here is the layout: Columns: Column 1 ("Student ID"): Identifies each student with a unique number. Column 2 ("Student Name"): Provides the name of the student. Columns 3-18 ("Subject 1 - Subject 9"): Track attendance for each subject. Each subject has two columns - "Time In" and "Time Out" - to record when the student entered and left the class. Column 19 ("Attendance Status"): This column is likely used to determine if the student is present, late, skip, or absent. Rows: Each row represents a student. The first column (labeled "Student ID") identifies each student with a unique number which is the RFID card. The second column ("Student Name") tells us the name of the student corresponding to that row. The remaining columns (Subject 1 through Subject 9) track the student's attendance in each subject.

@@RadenReynaldo Have go writing the code with ChatGPT and if you are having any specific issues I can help.

Hey Piotr , This AI field is moving really fast with products. Now you can get structured output with Google AI studio then export the code from there. Probably better than this method.

No limit

@analyticswithadam i try run code to import gmailes to google sheet, i setup triggar to run every 5m after 12hours i got error message because of limit times run. By the way im from syria. Is that make limit about times to run code on Google script

@@khabbazz89 Apologies, I was wrong. Two limits, 1000 api executions per day and sending 100 emails... While your 5 min trigger is only 288 execution per day unless you are calling each mail as 1. Have you anything else running that might be pumping these API calls up on your account?

@@analyticswithadam i've another question can i host telegram bot on app script so still answer users (/start) and aprommot bot commands?

@@khabbazz89 I don't think so it mainly interacts with Google Tools. Im sure you could pull data from a Telegram API but not host anything

No worries, I have some apps script video s which shows how to do this in a better way

Thanks

You want to talk to the data.. that’s going to be super expensive unless you aggregate it first

Awesome. Has it gotten much better recently?

PowerQuery is awesome for the little things that suck your time

Try ChatGPT it’s amazing at debugging apps script

This dataset is the Iowa Liquor Sales Datasets, its open to the public so you can download slices data.iowa.gov/stories/s/Iowa-Liquor-Sales-Explorer/mke2-7r5k/

Cheers mate

I posted a later video which gets the replies as well

@@analyticswithadam Can you give the URL please? :)

@ How to Extract all TH-cam Comments and Comment Replies from a Playlist th-cam.com/video/A1III_DQU4I/w-d-xo.html

@@analyticswithadam Thank you so much! <3

Hi Chris, You need to allow it. Its your own development so its safe. Go to 4.10 in the below video to see what to press th-cam.com/video/8UmdqwY9AdA/w-d-xo.html

Thanks for the feedback. Are there any other Looker Studio topics you would find a video useful for?

Would you please share this dashboard and Google sheets?

​@@analyticswithadamthough I've managed to perform various dashboards in the looker studio, but forecasting was untouched. So for any further requisition I would prefer to take help from your informative videos

Glad it helped

Download the audio of the podcast then upload it back in the notebook LM and you can copy and paste the audio out

Depends on where you are in your career. At the start you could take a functional role as an internship, intern as a business analyst, work for a consulting company in a certain area or just learn about a functional area through study. The main thing is choosing an area and really working to inform yourself about it not just how to build technical assets. I was an accountant then became a data professional so I work on Finance Analytics projects.

I’ll work on that 👍

This was made a good while ago. I’d batch them in the same prompt now. I use app script, Python notebook or AI studio now for the most part… use an array, dictionary or JSON hit all the rows in one prompt… Gemini has prompt limits per minute - What is your use case?

@@analyticswithadam Got it, thanks for the reply! I need to go through a column of descriptions and match them to a category from a specific list. The table’s got like 200k rows

I would suggest doing them in one prompt giving a good few examples in the instructions and outputting in a format (Json, CSV) or using the Google API fine tuning option. ai.google.dev/gemini-api/docs/model-tuning Here are some good videos: th-cam.com/video/VwpDvvNjN2I/w-d-xo.html th-cam.com/video/8-lz_h9uuOU/w-d-xo.html Ive had a made a video on this, this week but it wont be out for a while. Here is the link: th-cam.com/video/T_dAkcMgHaI/w-d-xo.html

@@analyticswithadam Sweet! Thank you so much!

It’s good for quick summaries or revisions. You can prompt it to just give you the key points.. Agree it’s not a replacement for deep learning but it’s great to get a curation gist while driving to work

Try the method in this video Not the Gemini part just the retrieving comments part… This should come out correct in the Google sheet with all the symbols intact How to Extract TH-cam comments in sheets and analyse with AI with 1 click th-cam.com/video/1KwFFb_tofY/w-d-xo.html

You bet

In theory it allows you to select a range of points to zoom in on. I have never used and didnt find it useful when I tried it there looks to be a bit bugy.

It’s a grey area. I would scrape the site or anything

Not directly you need to covert the sav file to excel first or connect through R

My Pleasure

Each sheet can be reference by sheet number. Const Sheet = ss.getSheets()[0]; reffers to the first sheets in the Spreadsheet you should be able to reference the sheet from its position.

It’s free up to 5 TBs a month processed

On BigQuery itself there are hundred of public dataset. It’s free I show how to set up in video one of the series. I also get a my data from kaggle.com

Thanks for the feedback boss

No worries chief

It’s just the Gemini api

@@analyticswithadam thanks. I tried and its working perfect.

Amazon does not provide api access. Based on what I read it is possible to scrape but it would take a lot of code and effort.

@@analyticswithadam Yeah, I have an unsupported Chrome extension that can get a maximum of 50 reviews but not more. I presume I could copy them across into your sheet (which I haven't created yet) and run the sentiment analysis?

Glad it helped!

try taking and a snip and asking chatgpt - it usually works for me :)

did you already have the table loaded into a spreadsheet? maybe by un-pivoting the table in Power Query, it would bump up against other data already in the spreadsheet (like would happen with a normal pivot table that changes shape)

You can either resize it, reduce the axis font size or reduce the number of bars and select group others in style. This will group the lowest ones in to a group called others