Видео

Thank you so much Cole, you're the best for this interview. I've learnt so much more than I have in the past few years in a few minutes.

This is really interesting!

This is very helpful, took me a few replays to get it tho.

Great explanation and really interesting topic. Will try to build and use a SQL Excel sheet for Langchain. Keep uploading videos!

Doesn't Copilot use Chat GPT?

You should try it with GPT4 too, I've found it's often much better at handling more complex things compared to 3.5

Also CAST is scheduled for deprecation and therefore CONVERT is the recommended route. (Win for Chat GPT)

Much better names this time!

He didn't deal with b*llsh*t.

ThankQ.

DST causes us to spend more money on electricity for air conditioning because of the heat because the sun is up longer, here in Texas until 830 or later at night. On standard time the sun is up after all, until 730 at night so you get plenty of daylight if you're working outside. But it sure does make it feel hotter longer. I would rather see daylight saving time abolished.

I say keep it the way it is. It explains why it's dark at 5 p.m....... Plus, the government wouldn't spend the 434 million on us anyway. Probably just send it to Ukraine.

We don't need it. I think that they keep lengthening it and using it just to try and get votes from the inner city for professionals who want to do their "fun things in the evening". 🙄 these "professionals" are so smart that they haven't even worked out that the days lengthen as we get closer to the summer solstice anyway and the days are long during the summer. So why does it make a difference to them if the sun "sets and "an hour later? And at the end of the day, how many of these professional inner-city jobs do we actually need for a society to function? On the other hand, we need farmers for our society to function. It's simple really. Without farmers, we don't get fed. So really, we should be placating at farmers considering that they are the hand that feeds us, and there's the old saying that you don't bite the hand that feeds you. Here in New Zealand where I live, every single farmer I have spoken to… And I have spoken to a lot of them… Hate daylight saving. So if it was up to me, we would just ditch it and stick to winter time which it always was, in order to pay Kate the farmers because farmers fetus. And as for calling it daylight savings? Well, I prefer to call it daylight slaving. As you can tell, I hate it. I know the Russians abolished it. Clearly there's some thinking people and some brain cells in Russia. Same with Japan.

The whole idea of "saving daylight" is ludicrous. Shifting the time around saves nothing. It is annoying and silly, and apparently costly. Stick with one time and be done.

We could switch to a 13 month calendar and simplify the world even more. It would put calendar companies out of business though because every month would be the same 28 days falling on the same days of the week. No need to look up dates because they're all the same. Complexity is job security I guess.

I grew up in Clay County Illinois in the 1970s and 80s. Our television stations came from Terra Haute and Evansville Indiana. The time was over the place. Sometimes we were on the same time as Terra Haute and other times not. Evansville is in our time zone CTS.

Everyone knows that DST will fade your curtains!!😂

As some who move to Arizona a year ago, I honestly wish we had DST. Not switching causes some weird problems I had never thought of. But I’m still in support of getting rid of it country wide.

Try living further North. The sunrise and sunset times flux much more than it does for you in the South. In Dallas hours of sunlight between June 20th and December 21st varies by 4:19. In Kansas City it is 5:30 and Minneapolis it is 6:51. Obviously, there are even bigger differences going further South or North. The impact of not changing between daylight and standard time are much more significant the further North you go. Personally, I'd rather have it lighter in the morning in winter and later in the day in summer, but that's just me.

the further north you are the more the time effects you. right now sun rises at 7:08am and sets at 4:42pm. and on Dec 21 2023. sunrise is 7:56 and sunset is 4:22PM. I worked in the navy so you were at work at 7am and left work 3-4pm.. so winter was no sun for us and again for summer time.. jun 21 2023 5:13am sunrise and 9:12 pm sunset. so for me DST makes no real sense in the winter kids still went to school in the near dark and 9-5 workers ended up driving home at or right after sunset . It never made sense to me and it still dose not make sense. but now i am retired and the only think it changes for me is when i take my meds because i take meds at 4 times a day and we separate the meds so i have to actually change when i take them to keep the separation proper

The U.K. tried staying on BST all year in 1968. Due to unpopularity it was abandoned but later analysis showed fewer children died that year.

I've not used SQL for about 25+ years, this was a great refresher and brought back some memories. I was using SQL on a mainframe, but I'll give this a look on my Windows machine.

Ben, can you link the 2:47 page please?

What do you do with spreadsheets that have been prettified by humans with all kinds of merged cells or three rows worth of headers and so forth? Just curious. I usually make them give me a copy of the file they started with.

The story sounds so insanely fake, but I am actually positively surprised that they actually added Pandas to Excel. Not bad, and hopefully your course helps some folks starting out or who are a bit rusty. ;)

Some fun. Awkward coffee meet up.😅

Ben, the information is good but the over-production of the video is over the top. It distracts from your content more than it adds to it. Effects are too literal (HE SAID 'RABBIT HOLES, LET'S SHOW A RABBIT!) and often very loud (the typewriter effect is obnoxiously loud). Save some $$ and dial it back. Thanks for your content.

INTERESTING

Thanks for posting this... lost my job after 17 yrs with a FORTUNE 50 company and have to pivot mid career. Couldn't have come at a better time.

You wouldn't need to use and combine all the three functions man. Just use countif. It does the exact thing. Thanks for the xlookup. It's very helpful to me.

Wasn’t aware of the XLookup! Saves me from duplicating collums and counting the nr of collum in an array all the time. So great tip again Ben, tx!!!!

I already use those and yes, they are powerful. Sometimes i even use those in spreadsheets I've built to help me write certain SQL scripts. But the case is very edge.

I like INDEX MATCH as it is made up of two functions. The MATCH function is used to figure out where the lookup value is located in a range of cells. The INDEX function then returns the value or cell reference from within a table or range. The MATCH and INDEX functions are combined to do the job that VLOOKUP cannot do.

thank you

what to do if site is protected by cloudflare?

I am going to try using this for fantasy football. Could be useful for our league's newsletter. Another video about saving previous versions of the data would be very helpful.

when the website ownder update the table, will the excel table update also?

Super handy! Short of copying and pasting before you update, is there a simple way to keep an archive of the previous values you collected online?

6:24 😂 Lol - Thanks for the Easter Egg bonus thumbnail shots! 🐣

Excellent tip Ben! Had no clue it was that simple. Thanks!

Thank you What are the additional benefits of using AI like chat got4

All tech interviews should include something like that!

Thanks Ben!

Such engaging speakers. Thank you for a great video