- Видео 166
- Просмотров 791 540
David Weiss
США
Добавлен 10 фев 2020
Ever wanted to become an expert in Apps Script or Google Cloud? Wanted to learn more about programming in general by building software, web applications, and full-stack systems? Check out the videos on this channel for all of the above! Each season highlights an API provided by Apps Script or a service provided by Google Cloud and delves into the most common use cases pertaining to these two technologies. I have used Apps Script heavily in my own work and I want to share the most beneficial ways I've used it. Don't forget to like and subscribe to show me some love :)
Binary Search Algorithm Explained for Beginners! - Python Interview Prep
Binary Search is one of the fastest and most efficient ways of searching through a sorted list. In this video, we'll try to understand this core algorithm both conceptually as well as through a coding example at the very end.
This is a new style of video. More animations, more attempts to conceptually understand through visuals, and less on-the-screen coding. Let me know how you guys like it!
❤️ Support the ongoing growth of this channel! www.patreon.com/DavidWeissProgramming
🧑💻 Python Documentation:
docs.python.org/
----------------------------------------------------------------------------------------------
🕒 Timestamps
0:00 Binary Search Intro
0:39 How Does Binary Search Work?
0:57 Real Life ...
This is a new style of video. More animations, more attempts to conceptually understand through visuals, and less on-the-screen coding. Let me know how you guys like it!
❤️ Support the ongoing growth of this channel! www.patreon.com/DavidWeissProgramming
🧑💻 Python Documentation:
docs.python.org/
----------------------------------------------------------------------------------------------
🕒 Timestamps
0:00 Binary Search Intro
0:39 How Does Binary Search Work?
0:57 Real Life ...
Просмотров: 344
Видео
Python Operators Explained: A Comprehensive Guide for Beginners ~ Episode 0.4
Просмотров 300Год назад
Hey Coders! In this Python tutorial video, we will delve into the world of Python operators. Operators are a fundamental part of any programming language, and Python offers a rich set of operators for performing various operations. We will cover all the major types of operators, including arithmetic, comparison, logical, bitwise, and assignment operators. Full Operator Precedence List: www.prog...
Variables & Data Types - The Technical Interview | Introduction ~ Episode 0.3
Просмотров 212Год назад
Hey Coders! Foundational to any programming language are variables and data types, and python is no different! Variables are used to store data, so they can be retrieved, updated, and used later in your script, and since python is dynamically typed, those variables can even change their data type! Be sure to learn all the ins and outs of variables and data types in this video, because we'll nee...
Python Under the Hood - The Technical Interview | Introduction ~ Episode 0.1
Просмотров 2,1 тыс.Год назад
Hey Coders! Ever wonder what the difference between Python 2 & 3 is? Why do other Pythonistas bring up C language all the time? Or just how the python interpreter even works? While the topics in this video will most likely never be tested in a live interview, it's still a good idea to become familiar with what happens to your code after you hit the "run" button in python. Let's quickly explore ...
Become a Python Developer - The Technical Interview | Introduction ~ Episode 0.0
Просмотров 270Год назад
Hey Coders! The road to landing your 6-figure python developer dream job starts here. From a large community of other supportive python devs, a flexible work-life balance, and lucrative compensation, becoming a python developer was one of the best choices of my life! This new course will walk you through step by step in detail everything you need to know to ace your technical interview as well....
How to Install Python & Set Up Your Dev Env - The Technical Interview | Introduction ~ Episode 0.2
Просмотров 352Год назад
Hey Coders! It's time we finally download python, our IDE, and get coding. The installation steps are extremely straightforward, but just to make sure we're all on the same page, we'll walk through how to get everything set up. By the end of this video, you'll have run your very first python script, how fun! Answers to Post-Video Quiz: 1. www.python.org 2. python -V (for python 2) or python3 -V...
Sorting Your Data - Pandas | Python ~ Episode 11
Просмотров 3052 года назад
Hey Coders! Ever wanted to know what are the 3, 5, or 10 largest values in a column of your pandas dataframe? How about reordering the "last name" column so that everyone in your table is in alphabetical order? There's no easy way to do this unless you use the "sort_values" method! Sort_values allows you to sort the rows of your dataframe in either ascending or descending order based on one or ...
Renaming Columns & Indicies - Pandas | Python ~ Episode 10
Просмотров 1582 года назад
Hey Coders! Included within your pandas data cleaning tasks is making sure your column and index names are both readable and accessible. This can come in handy for both understanding your dataframe's schema as well as performing efficient joins and merges. Furthermore, renaming columns to more human-readable names can assist in your data analysis and presentation. Watch this tutorial to learn h...
Visualizing Data with Graphs - Pandas | Python ~ Episode 9
Просмотров 2452 года назад
Hey Coders! When it comes to data science and analytics, Python is king! There are hundreds of amazing libraries for running mathematical and statistical analyses on your Pandas dataframes. Just as important as this is though, seeing a clear, well-put-together graph can be just as compelling for understanding your data. Luckily, pandas has built-in functionality for plotting your data! You can ...
Grouping Data - Pandas | Python ~ Episode 8
Просмотров 3042 года назад
Hey Coders! Ready to take your pandas analysis skills to the next level? Grouping your data by a common value and then performing some kind of aggregation function on it is a common and powerful task. Almost exactly like the GROUP BY keywords in SQL, pandas groupby() method allows you to create a group object, which can be used to find things like average math score for each race/ethnicity or g...
More Data Cleaning with Custom Functions (Data Cleaning Part 2) - Pandas | Python ~ Episode 7
Просмотров 4792 года назад
Hey Coders! Badly formatted data can be as much of a problem as missing data. Thankfully, pandas provides a suite of tools to format your data in the exact way you want. With methods such as apply() and applymap(), you can quite literally define your own functions to pass the data through. For instance, you can remove special characters from a column of all strings, or calculate the residual of...
Appending & Merging Dataframes (concat, merge, join, ...) - Pandas | Python ~ Episode 5
Просмотров 3612 года назад
Hey Coders! As mentioned before, pandas can be thought of as SQL on steroids for python. One of the hallmarks of SQL is the ability to join two tables together based on a related column. In pandas, you can also do this, but with many more features and functionality. The best way to perform an inner/left/right/outer/cross join is by using the pd.merge method. However, pandas also allows you to c...
Handling Missing Data (Data Cleaning) - Pandas | Python ~ Episode 6
Просмотров 1,2 тыс.2 года назад
Hey Coders! As much as we dream of a perfect world, when it comes to raw data found out in the wild, it will most likely be patchy. Missing data is one of the most prevalent causes of data cleaning. Sometimes, non-existent data is OK, but for those other times, pandas provides a suite of methods and techniques to resolve missing values. Some examples are dropping the row altogether, or a more g...
Filtering Data - Pandas | Python ~ Episode 3
Просмотров 4922 года назад
Hey Coders! After learning how to access and isolate the data in your pandas dataframe the 2nd most important operation is learning how to filter for the exact data that you want. For instance, let's say you had data on human heights across various ages. While examining your data, you may want to find the average height for just males, or just females, or maybe you want to find the ratio of mal...
How to Install and Import Pandas (& Jupyter Lab) - Python ~ Episode 0
Просмотров 8 тыс.2 года назад
Hey Coders! Are you interested in analyzing data in python? Are you aspiring to become a Data Engineer / Data Scientist one day? If yes, then learning pandas, an immensely popular python package for data analysis and manipulation, is a must. Pandas allows python scripts to read in tabular data of all sizes in a neat and organized way, clean it, transform it, analyze it, and then export it back ...
Calculating Summary Statistics - Pandas | Python ~ Episode 4
Просмотров 6212 года назад
Calculating Summary Statistics - Pandas | Python ~ Episode 4
Series, DataFrames & Other Basics - Pandas | Python ~ Episode 1
Просмотров 5912 года назад
Series, DataFrames & Other Basics - Pandas | Python ~ Episode 1
Accessing Rows, Columns & Cells - Pandas | Python ~ Episode 2
Просмотров 2,4 тыс.2 года назад
Accessing Rows, Columns & Cells - Pandas | Python ~ Episode 2
Reading & Writing to the Cache (COVID Vaccination Web App) - Apps Script | Cache ~ Episode 17.2
Просмотров 4,2 тыс.3 года назад
Reading & Writing to the Cache (COVID Vaccination Web App) - Apps Script | Cache ~ Episode 17.2
Introduction to the Cache - Apps Script | CacheService ~ Episode 17.0
Просмотров 5 тыс.3 года назад
Introduction to the Cache - Apps Script | CacheService ~ Episode 17.0
Cache Scope - Apps Script | CacheService ~ Episode 17.1
Просмотров 3,5 тыс.3 года назад
Cache Scope - Apps Script | CacheService ~ Episode 17.1
Row & Column - Flutter | Basic Widgets ~ Episode 2.3
Просмотров 4523 года назад
Row & Column - Flutter | Basic Widgets ~ Episode 2.3
Advanced Widgets Introduction - Flutter ~ Episode 3.0
Просмотров 4763 года назад
Advanced Widgets Introduction - Flutter ~ Episode 3.0
Container & Padding - Flutter | Basic Widgets ~ Episode 2.2
Просмотров 4213 года назад
Container & Padding - Flutter | Basic Widgets ~ Episode 2.2
Introduction - Flutter | Basic Widgets ~ Episode 2.0
Просмотров 4603 года назад
Introduction - Flutter | Basic Widgets ~ Episode 2.0
Building the Foundation - Flutter | Basic Widgets ~ Episode 2.1
Просмотров 4683 года назад
Building the Foundation - Flutter | Basic Widgets ~ Episode 2.1
Classes, Constructors, and Objects - Flutter | Dart ~ Episode 1.6
Просмотров 7 тыс.3 года назад
Classes, Constructors, and Objects - Flutter | Dart ~ Episode 1.6
Flutter Introduction - Flutter | Overview ~ Episode 0.0
Просмотров 7143 года назад
Flutter Introduction - Flutter | Overview ~ Episode 0.0
Variables & Data Types - Dart | Flutter ~ Episode 1.1
Просмотров 2,2 тыс.3 года назад
Variables & Data Types - Dart | Flutter ~ Episode 1.1
Functions (With Optional & Required Parameters) - Flutter | Dart ~ Episode 1.4
Просмотров 3,9 тыс.3 года назад
Functions (With Optional & Required Parameters) - Flutter | Dart ~ Episode 1.4
While it looks like you've kinda gone inactive, I want to compliment you on the videos you've done. I've only watched the early versions of Google Apps Script. I'm a retired software engineer who's trying to build an app to help me sign up for a golf tee time without have to get up at 6 AM. I've read technology books and watched videos over the years but based on what I've seen so far, your approach to sharing information if the best I've seen. Your videos do a great job of explaining the details with video and great explanations without talking down to viewers. I hope your skill is serving you well in whatever you're doing these days!
Thanks for this video! You have a great way of explaining things to make it stick. The App Script docs are so dense but your videos are straight to the point.
Hae am new in programming...
Thanks for making this video. Now I finally understand what the tags mean! The Google Apps Script docs can be quite dense! I was wondering, do we always need to use the doGet built-in function when passing variables to templates? I've written a parent function which passes parameters to the template. This doesn't seem to work on my end. The param values log on the server but aren't passed to the frontend template.
Is there a way to check if the sheet has changed from a specific one? I'm working on a fix to close a sidebar when the user navigates away from a specific sheet.
I have a question, if I share this sheet with "reader" access my script doesn't work and if I change access for "editor" it works, as I need. What needs to be done that my script works with "reader" access?
Hii, I am not a techie, but I think I might have some idea as too how did you receive 2 emails.. I tried the same trick and ran the code for a few times and noticed something, if i run the code for a few time, the code will automatically generate a trigger with each run. So, if i run the code for 5 time, the code will generate 5 triggers and send the person 5 email.. I tried and ran the form with trigger for 20 times trying new things and code and I received 20 emails 😅😅... So, now I am looking for a way in which the trigger is only set one time and not when the form is submitted. So, if anyone has any idea as too how do i change the first part (the trigger loop) so that it only runs one time not thousands, please let me know.. Thank you in advance..
When you removed the filter, that event wasn't logged. Does anyone know a trigger which will catch filter changes?
Hi David, is there a way to also insert the correct answer to the multiple choice question into the sheet and have it be imported into the Google Form?
Thank you for teaching this! Very helpful!
Do you have any video on: I already created a form using form ui. I need to get the submitted data. I am struggling with getting the value for selected choice in grid. F.g. row 1 and col 2 is selected then i need value of row 1 and col 2 heading. I struggling to fetch that data
Thank you for taking the time to make the playlist series on Apps Script. It’s a great resource and very much appreciated :)
Theoretically, could I set up a daily time based trigger in the Triggers UI to run between 12AM-1AM for the setUpTrigger function and use the at() method to specify a specific time by modifying new Date() when I run it at midnight? Get new Date, then modify so it happens on a specific time of that date. This would allow me to do basically the same thing as atHour().nearMinute() without the 15 minute +/-
something like this: function createTrigger() { var now = new Date(); // Convert the current time to Pacific Time var convertPacific = now.toLocaleString('en-US', { timeZone: 'America/Los_Angeles' }); // Create a new Date object with the Pacific Time var pacificNow = new Date(convertPacific); // Set the time to 4:00 PM var runtime = new Date(pacificNow.setHours(16, 0, 0, 0)); // 16:00:00.000 is 4:00 PM Logger.log(now); Logger.log(runtime); // Create the trigger to run at 4 PM Pacific Time ScriptApp.newTrigger('closeSnoozed') .timeBased() .at(runtime) .create(); }
you are saved my fucking life bro thanks :)
How do you use advanced services?
Sabe muito, saudações do Brasil
Can you help me on how to fix the Google Form grid data based on the name of the list in Google Sheet even if there is a change in the number of lists. Please help, I am willing to donate for this problem
Hey is there a way to speak to you about my current script I'm pulling my hair over I need some guidance and came across your videos I think I'm getting there with it but something throwing me off or not right.
thank you much
Absolute great, thanks for sharing this, you’ve saved my ass David ❤
Great tutorial, thank you so much David...
It good to see you teaching advance flutter but there is only introduction video and i can not find other topics yyou mention on the introduction video. Can you help?
I followed your video. Could you tell me how you found the SECRET API code, indicated in the "getZoomAccessToken()" function? Because I developed a procedure using GOOGLE SCRIPT API for the implementation of the electronic signature card in the GMAIL signature parameter. Here, my test launch is crashed due to the problem on the delegation domain!!... With your video, I tried to test with your example to understand how it works... I know where KEY API is located, placed in the Google cloud console, and then, in API and service. but, I do not see API SECRET whereas, for clients, ID and password have appeared!!!... So, how did you find the SECRET API code, indicated in the "getZoomAccessToken()" function? Thank you in advance for your help. sincerely
Greate video! Amazing chanel! Wish I would have find you a while ago 😂 If it is possible, would love to get your help with the extra step enfourcing http->https redirection. thank you so much 💪🏽💪🏽
hey sir can we have contact i have some question how i can contact you
Hello, how do I redirect the lead to a website after they fill out the form? I don't want to put the link so he has to click. I would like it to be automatically redirected to the website when pressing the submission button. It's possible? How to do this? Would you help me? Tks
Grandissimo! Thanks a lot!
Thanks for sharing. It helps me a lot. I also saw your new channel for ironman Waco. It is amazing for me as a coder ^^; By the way, I have a question for Google apps script, how to see the log which is generated by console.log(). For my apps script, there is no logs in my Exections. My apps has deployed. Hope you could give me some advice or guide me how to figure out. Thanks.
how do you get it to show the helper text when you start typing the code? Is this an option I can turn on?
Thanks. It really helped me today.
Hi, if I have 100K emails totally (inbox plus outbox plus archive plus....), what if I want to get the sender addresses of all these emails? If I just use getMessages() function, it will take too much time to fetch them, probably many many hours, because it fetches the entire messages. But I want only the index, I mean, I want only the addresses of the senders of all messages. Nothing more. Is there any quicker (more optimized) way to do it using Apps Script? or maybe there is some other way to do it?
Hi Dave, just wanted to let you know that I loved the effort you put into your videos, they've been very helpful and fun to watch. Cheers!
Amazing content ty
Thanks so much
Please make a video on how to deploy a nodejs app that uses socketio to app engine flex environment. I can't get socketio to work. Works fine locally but not after deploying to app engine. Keep getting 502 bad gateway error.
hi david, i already deployed my api into the app engine. But when i test it into postman, it showed "service unavailable". Idk where is the problem. Thanks🙌
han
Really helpful! Thank you!
SOAB! You were probably born to teach people! I can't support you by money (yet) but I will! Dude! Thank you so much for this!
Hey David, Can we use this to store credentials ?
AWESOME ! Thank you dude !
Спасибо! Увы, так и не нашел возможность отслеживать изменения, вызванные скриптами, а не пользователем
How to get full display name by gmail in script app? many thank you
This is so helpful. Thank you!
is this way have limit quota?
Thanks for make such great tutorial
Thank you! 🙌
How to download data from a specific mailbox when I have multiple mailboxes associated with one account?
I got an error when I redeploy the app with some changes. It is showing Action not allowed error the line number with DocumentApp.openById call method. Do i need to set any permissions for when I redeploy the app script again?
Love your videos mate!