- Видео 59
- Просмотров 264 680
Analyst's Corner
США
Добавлен 29 апр 2017
Here is your place to find helpful tips and tidbits on topics related to Analytics and Business Intelligence, that you can easily apply at work or at school. I hope you like the content, and if you don't all feedback is welcomed. It just helps improve the channel. Thanks for visiting.
Zed Text Editor Setup
Settings files here: github.com/oscarito-taquito/yt-examples/tree/main/zed-editor
Set up your Zed Text Editor to do the following:
- Save your files when switching to another file
- Format your file on save
- Choose your theme
- Connect to Github's Copilot
- Create a key binding to execute your python scripts
Set up your Zed Text Editor to do the following:
- Save your files when switching to another file
- Format your file on save
- Choose your theme
- Connect to Github's Copilot
- Create a key binding to execute your python scripts
Просмотров: 8 384
Видео
Leetcode SQL: 1581 Customer Visits not Transactions Explained
Просмотров 1255 месяцев назад
Leetcode SQL 1581: Counting Visits Without Transactions This SQL script is used to find out how many visits to a store did not result in a transaction. Let's break it down step-by-step: 1. *SELECT v.customer_id, COUNT(v.visit_id) AS count_no_trans:* - This part selects the `customer_id` from the `Visits` table (`v`). - It also counts the number of visits (`visit_id`) for each customer where no ...
197 Rising Temperature Explained
Просмотров 1975 месяцев назад
Leetcode SQL: Question 197 Rising Temperature This SQL script is used to find days when the temperature was higher than the previous day. Let's break it down step-by-step: SELECT w2.id: This part selects the id from the table Weather. The id likely represents a unique identifier for each weather record. FROM Weather w1 INNER JOIN Weather w2 ON w1.recordDate = w2.recordDate - 1: This joins the W...
Leetcode SQL: Not Boring Movies Explained
Просмотров 566 месяцев назад
*Leetcode SQL: # 620 Filtering and Sorting Movies* This SQL script is used to find and sort movies from a cinema database. Let’s break it down step-by-step: 1. SELECT * FROM Cinema: - This part selects all columns (*) from the `Cinema` table. The `Cinema` table likely contains information about different movies, such as their descriptions, ratings, and unique IDs. 2. WHERE description != 'borin...
Leetcode SQL: Confirmation Rate Walkthrough
Просмотров 986 месяцев назад
Leetcode SQL: Confirmation Rate Question Walkthrough This SQL script calculates the confirmation rate for user signups. Let's break it down step-by-step: WITH t AS (...): This part creates a temporary table named t that holds specific data for later use. SELECT s.user_id, ... FROM Signups s LEFT JOIN Confirmations c ON s.user_id = c.user_id: This line selects the user_id from the Signups table ...
Leetcode SQL: managers with 5 reports - explained #sql #leetcode
Просмотров 666 месяцев назад
From Leetcode: Explanation and opinion on Leetcode's Manager with 5 Direct Reports question. Write a solution to find managers with at least five direct reports. Return the result table in any order. The result format is in the following example. Table: Employee | Column Name | Type | | id | int | | name | varchar | | department | varchar | | managerId | int | id is the primary key (column with...
Creating Cohort Retention Pivot Charts with Python: Data Visualization Tutorial
Просмотров 136Год назад
*Code: Github:* github.com/oscarito-taquito/yt-examples/blob/main/charts/cohort-pivot.py Free uDemy Courses: www.udemy.com/user/oscar-2330/ Buy me a coffee: buymeacoffee.com/oscarito Affiliate Savings: analystscorner.net/affiliates.html This Python code is designed to create a cohort retention pivot chart using table data. It utilizes libraries such as pandas, matplotlib, and seaborn. The code ...
Leet Code Two Sum Solved with Python - Code Linked in Description
Просмотров 94Год назад
Leet Code Two Sum Solved with Python - Code Linked in Description
Word Length and Paragraph Word Length Counter
Просмотров 83Год назад
Word Length and Paragraph Word Length Counter
renaming folders and moving files in S3 using python
Просмотров 1,7 тыс.Год назад
renaming folders and moving files in S3 using python
Delete files based on modified date using Python
Просмотров 663Год назад
Delete files based on modified date using Python
Moving files in Python using the os and shutil modules
Просмотров 1,6 тыс.2 года назад
Moving files in Python using the os and shutil modules
Add Text Color to Python Terminal Programs
Просмотров 4,6 тыс.2 года назад
Add Text Color to Python Terminal Programs
Word Counter using Python Dictionary
Просмотров 13 тыс.2 года назад
Word Counter using Python Dictionary
Create subfolders in S3 bucket with Python
Просмотров 4,5 тыс.2 года назад
Create subfolders in S3 bucket with Python
Connect and List S3 Buckets using Python
Просмотров 3,1 тыс.2 года назад
Connect and List S3 Buckets using Python
Prerequisites for working with AWS and Python
Просмотров 562 года назад
Prerequisites for working with AWS and Python
Create Group User and Access Keys in AWS
Просмотров 4342 года назад
Create Group User and Access Keys in AWS
Getting Full Directory Path in Python
Просмотров 27 тыс.4 года назад
Getting Full Directory Path in Python
does this work for large video files also or do they need to downloaded in segments?
I’ve downloaded a few hundred megs, but don’t think I’ve gone past a gig. I think files are only segmented when they are loaded to S3 tho. Lmk what you find out.
how do i put it into terminal
Save the script to a file, cd into the directory and type “python your-file.py”.
Thanks bud, I am using fedora by the way - and trying to find out alternative text editors on rust and it really helped.
Cant be submitted as 13/15 test cases passed
👀
hi dude, you've removed the settings.json file from your GitHub repo, any chance you could add it back there please ?
Tysm!
thanks for the walkthrough! i have an additional request.. suppose we have data headers like[Title, Actor1,Actor2,Actor3,Age1,Age2,Age3] and I want the pivot to have first column as 'Title' second column as 'Actor' and third one as Age. and Actor1 corresponds to Age1 and Actor2 to Age2.. can you please suggest something on this?
check out this code: github.com/oscarito-taquito/yt-examples/blob/main/pandas/pivot-expanded.py
you make it 10x more confusing by including virtual environments
Good call out. I can see where beginners are going to use the default Python installation. Thanks.
thanks
I'm almost nostalgic for the time of notepad++ or pure vi 😅 so far traveled since then
Which theme are you using?
One Dark. It’s the default.
What font are you using?
One Dark theme. The font is Zed Plex Mono.
the problem with zed is thet u have to add the env files everytime
dude you are the best!!!!!!!!! i almost quit python bcuz i didnt know how to do this thing!!!!!! i was sitting there for atleast5 hours trying to figure it out!!!! can you also like put the code in the commentaries????77??
Thank you for the feedback and yes, I will begin adding links to the code on GitHub in the comments. Thanks for the suggestion.
thrnk yio
I know you needed me:--- in task.json file :- "command": "sh ~/.config/zed/custom_runfile.sh", rather then "sh" use "bash" Thanks me later....
Made the change, but didn’t see a diff. Thank you for sharing though!
zsh > bash
github: github.com/oscarito-taquito/yt-examples/tree/main/zed-editor YT Full Vid: ruclips.net/video/m2UrCwf6gms/видео.html
How to configure its settings to act like rustrover IDE?
i cant find the website, python to do it. please help im new at this
here is the code below. you can use a notebook on colab.google.com to copy and paste the code below and run it if you are having problems doing it on your computer. sentence = """A horse is a horse, of course, of course, And no one can talk to a horse of course, That is, of course, unless the horse is the famous Mr. Ed.""" sentence = sentence.replace(',', '').lower().split() wc = {} for word in sentence: if word in wc.keys(): wc[word] += 1 else: wc[word] = 1 print(wc)
Very simple and helpful.
Code Here: github.com/oscarito-taquito/yt-examples/blob/main/other-libs/icecream-examples.py
thank you, that was usefull
😃
🎉
Valuable code!
I truly appreciate the effort you put into creating such valuable content. Your expertise and clear explanations have helped me grasp the concepts effortlessly.
Oh Gawd I needed this. Thank You!!!
Can you share AWS related configuration, I mean , permission, properties and all
Hi I have seen your RUclips channel :(Analyst's Corner) .Your channel is absolutely important for the viewers & your videos are fine. You have uploaded videos- 46 but you are not getting enough subscribers. Your subscribers are only- 799 What’s the reason you are not getting more subscribers & views? 1) SEO Score not good 0/100. It’s must need minimum 80+ 2) Video Tags & Channel Tags weren't used properly. You need more analysis & optimisation properly. 3) You didn't share your video in Facebook. 4) You don't have End Screen. 5) Need perfect video SEO for your channel. What benefit will you get from proper video SEO? Your Channel Subscribers will increase organically. Your Channel video views will increase organically. Your Channel watch time will increase rapidly. You will get your potential & targeted viewers. Your Channel will be monetized by RUclips. Are you thinking the same as me? Waiting for your reply. Thank you so much.
Many many many thanks... Was trying to do this with for loop and it was taking a lot of time... This really saved my life... Thank you once again ❤
Awesome! Very glad to hear this!
This is super helpful. Thanks
I saw your RUclips channel. Your content is unique and really amazing but channel growth is very poor. I noticed that your video SEO score is 0/100. Your video SEO score should be increase (at least 50 plus). Just need to customize your channel and video, especially need optimize with high quality SEO.
Thank you for the feedback! I did not know this about my video SEO score. 😯 If you have know of any materials I can read to learn more, lmk. If not, the heads up was gold. Thanks!
Wait how did u put the list in the dictionary like how did those even connect?
great question. the .split() function placed the entire text into a list. Then with the for loop, we iterated through every word in that list. If the word did not exist as a key, then we add that word as a key and set the value to 1. If the word did exist (as a key), then we add 1 to the existing value.
thanks
Github: github.com/oscarito-taquito/yt-examples/blob/main/open-ai/connecting-to-openai-chat.py
what is the pip install for your modules?
I'm not using any modules/libraries. I just created one with a set of colors. This is what's imported in the example: github.com/oscarito-taquito/yt-examples/blob/main/modules/text_colors.py Also, the code file moved to: github.com/oscarito-taquito/yt-examples/blob/main/general/terminal_text.py
@@AnalystsCorner thank you
@crmn_hwr anytime!
Say i wanted to create a subfolder dynamically for a user where all the users files will be uploaded to that specific subfolder. Is that possible with this?
And will the user be able to delete files from the subfolder without deleting the entire subfolder?
Now show us how to do it from within a loop via a list of files (dir) shutil
Already like it. Clear video concise code snippet ready good to go
Thank you 🙏
Bro my python file is in another folder I want to get location like if I search for chrome.exe it should give the location like wise if I search word.exe it should give full location help me bro
If you are on Linux or Mac, you can do something like import subprocess subprocess.run([“find /home -name chrome.exe”], shell=True) Change the “/home” to whichever directory you want to start at. If you’re on Windows, lmk. I don’t have Windows but I think I can code something up for you that will work. It will just be more lines of code.
Yeah I'm on windows
Cool, check this out. Code in the description of video. Hope this works! ruclips.net/video/BhtFQPmjw4I/видео.html
What if I am looking for a specific word?
Great question. Instead of using the for loop, you can use and if statement and check if your word is in the “sentence” list of words For example: myword = ‘donut’ If myword in sentence: do something
If I delete just the example folder, will the other files that in the example folder be deleted?
Great question. The answer is no and your folder may not even delete. Folders like files are considered objects too, but they will have a size of 0. So that’s how you’ll be able to single them out when you need to or they share the same name as a file.
@@AnalystsCorner thanks.
im new to python, came from frontend, so your video was very helpful, thanks!
❤
Gracias vídeos así directo al punto y con casos que se hacen en excel fácil hacerlo también sin tanto código directo al asunto . Gracias
Gracias! Me da gusto tu comentario!
Nice
but how did u connect to S3
Good question, You will want to make sure you store your AWS Keys. See: ruclips.net/video/4K05E0gHC3E/видео.html for Mac & Linux.
thanks for this
What if you using remote ssh into a windows server..
If you are remoting into a Windows machine, you can 1. Relaunch VS Code via Run 2. Restart Server Before doing that, be sure to ensure your environment variables are set correctly. docs.oracle.com/en/database/oracle////machine-learning/oml4r/1.5.1/oread/creating-and-modifying-environment-variables-on-windows.html
Great Video. That helped a lot.
youtu.be/iolQX4XJ=42