![Analytics School](/img/default-banner.jpg)
- 91
- 170 023
Analytics School
India
Registrace 17. 03. 2017
Welcome To Analytics School.
The world, as we know it, is constantly evolving with ever changing technology that is unprecedented in history. There is no denying that data science and analytics have impacted on every aspect of our lives and businesses. Moreover, we are collecting data more then ever before. To analyze the data and extract meaningful insights that is where Analytics School platform will help you to learn how to efficiently analyze the data using concepts of data science & analytics.
Today, it’s even more important then to stay relevant. We believe that each one of us is unique, so are our learning needs. Moreover, learning is a hard work and we are here to support you at every step. When learning a new skill arises when you feel you are stuck and you can’t figure it out how to continue. Drop an email at analyticschool@gmail.com, we can contemplate life, movies, and of course you.
The world, as we know it, is constantly evolving with ever changing technology that is unprecedented in history. There is no denying that data science and analytics have impacted on every aspect of our lives and businesses. Moreover, we are collecting data more then ever before. To analyze the data and extract meaningful insights that is where Analytics School platform will help you to learn how to efficiently analyze the data using concepts of data science & analytics.
Today, it’s even more important then to stay relevant. We believe that each one of us is unique, so are our learning needs. Moreover, learning is a hard work and we are here to support you at every step. When learning a new skill arises when you feel you are stuck and you can’t figure it out how to continue. Drop an email at analyticschool@gmail.com, we can contemplate life, movies, and of course you.
Date Functions in Pandas
In this session of @analyticsschool, we will explore some of the most useful date functions in Pandas such as converting date string, extracting components from dates, calculating differences between two dates, generating date ranges and managing time zones.
Pandas offers a robust set of functions for date manipulations, essential for any time series analysis or date-based computations.
Pandas offers a robust set of functions for date manipulations, essential for any time series analysis or date-based computations.
zhlédnutí: 18
Video
Having Clause in SQL
zhlédnutí 21Před 14 dny
In SQL, the HAVING clause is used to filter the results of a GROUP BY operation, enabling more granular control over which records are returned based on aggregate functions. While it shares similarities with the WHERE clause, it serves a distinct purpose within the context of grouped data. Purpose of the HAVING Clause: Filtering Grouped Data: The HAVING clause filters records after the GROUP BY...
Group By Function In SQL
zhlédnutí 54Před 4 měsíci
In this session of @analyticsschool we will discuss GROUP BY function in SQL. The GROUP BY clause is used to group the same values and return a summary result. If a column that is used in the GROUP BY statement has NULL values, then this statement will consider them equal and group all NULL values in a single group. We use this clause in with the SELECT statement and specify it after the WHERE ...
How To Use Arithmetic Functions In Pandas
zhlédnutí 42Před 5 měsíci
In this session of @analyticsschool, we will focus on arithmetic functions in pandas. Whether you are a beginner or an experienced data wrangler, mastering arithmetical operations in pandas is crucial for your data manipulation arsenal. #analyticsschool #pythonforbeginners #pythonprogramming #datascience #dataanalytics #dataanalysis #dataanalyticstraining #dataanalyticscourse
Aggregate Functions In SQL
zhlédnutí 57Před 5 měsíci
In this session of @analyticsschool, we will deep dive into the world of aggregate functions in SQL. Aggregate functions in SQL are powerful tools that allow us to perform calculations on groups of rows to return a single value. Chapters: 00:00 - Introduction 01:28 - About The Dataset 01:51 - Count Function In SQL 03:30 - Count(Distinct) In SQL 04:30 - Sum Function In SQL 05:31 - Min & Max Func...
How To Use String Methods In Pandas
zhlédnutí 73Před 6 měsíci
In this session of @analyticsschool, we will deep dive into Pandas powerful string methods and show you how to manipulate and analyze text data. We will discuss len, lower, upper, contains, replace, split, strip, count, startswith, endswith and extract methods and their functionality. #analyticsschool #python #pythonprogramming #pythonforbeginners #pandas #stringmethods
Date Functions in SQL With Examples
zhlédnutí 168Před 7 měsíci
In this session of @analyticsschool, we will be delving into the fascinating world of SQL date functions. In this session, we will discuss below mentioned functions in SQL. They are: 1. GETDATE 2. DATEPART 3. DATEADD 4. DATEDIFF 5. CONVERT 6. FORMAT 7. DATEFROMPARTS 8. DATENAME #analyticsschool #sqlserver #sqldatabase #sqlforbeginners #datefunction
How To Perform Chi-Square Test In SAS
zhlédnutí 322Před 9 měsíci
In this session of @analyticsschool, we will discuss how to perform chi-square test in sas. The Chi-Square Test of Independence determines whether there is an association between categorical variables (i.e., whether the variables are independent or related). It is a nonparametric test. The Chi-Square Test of Independence can only compare categorical variables. It cannot make comparisons between...
How To Use ApplyMap Function In Pandas
zhlédnutí 140Před 10 měsíci
In this session of @analyticsschool, we will explore applymap function in pandas. This function is a powerful tool that allows you to transform every element in your dataframe. Chapters: 00:00 - Introduction 01:51 - ApplyMap Function In Pandas 02:31 - Code #analyticsschool #dataanalysis #dataanalytics #applmap #python #pythonprogramming #pythontutorial #pythonforbeginners #pandas
Numerical Functions In SQL
zhlédnutí 54Před 11 měsíci
In this session of @analyticsschool, we will deep dive into numerical functions in SQL. We will explore essential functions like Round, ABS, Ceiling, Floor, Log, Log10, Power, SQRT & Sign numerical functions in SQL. Chapters: 00:00 - Introduction 01:00 - Round Function 02:40 - ABS Function 04:10 - Ceiling & Floor Function 05:15 - Log & Log10 Function 06:52 - Power Function 07:41 - SQRT Function...
How To Perform Paired Sample T Test In SAS
zhlédnutí 229Před 11 měsíci
In this session of @analyticsschool, we will discuss how to conduct a paired samples t test using sas, a powerful statistical tool for comparing the means of two related samples. Chapters: 00:00 - Introduction 01:50 - Hypothesis For Paired Samples T Test 02:10 - Code & Analyzing The Output #sas #analyticsschool #basesas #statistics #ttest #sasprogramming #sasprogrammingtutorial
How To Use Apply Function In Pandas
zhlédnutí 151Před 11 měsíci
In this session of @analyticsschool, we will discuss about apply method in pandas. The apply() method is one of the most common methods of data preprocessing. It simplifies applying a function on each element in a pandas Series and each row or column in a pandas DataFrame. In this tutorial, we'll learn how to use the apply() method in pandas. Chapters: 00:00 - Introduction 01:46 - Using Lambda ...
How To Perform Two Sample T Test In SAS
zhlédnutí 279Před 11 měsíci
In this session of @analyticsschool, we will discuss how to conduct two sample t test in SAS. It means the t test for independent sample tests whether two independent groups are significantly different. We will cover both the parametric and non-parametric versions of the test, so whether your data meets the assumption or not, we have got you covered. Chapters: 00:00 - Introduction 01:10 - About...
How To Perform One Sample T Test In SAS
zhlédnutí 361Před rokem
In this session of @analyticsschool, we'll be diving into the world of hypothesis testing using SAS. Specifically, we'll focus on performing a one-tailed t test in SAS. The t test is one of the most common hypothesis tests in statistics. The t test determines either whether the sample mean, and the mean of the population differ or if two sample means differ statistically. The t test distinguish...
How To Fetch Top N Records In SQL
zhlédnutí 113Před rokem
In this session of @analyticsschool, we will explore how to retrieve top n records from a table in SQL. Chapters: 00:00 - Introduction 00:55 - Code #analyticsschool #postgresql #sql #sqlserver #oracle #teradata #mysql
Conditional Variable Creation In Pandas Using np.where() and np.select()
zhlédnutí 240Před rokem
Conditional Variable Creation In Pandas Using np.where() and np.select()
Mastering Sampling Strategies With Proc SurveySelect In SAS
zhlédnutí 545Před rokem
Mastering Sampling Strategies With Proc SurveySelect In SAS
How To Use Assign Method In Pandas DataFrame
zhlédnutí 991Před rokem
How To Use Assign Method In Pandas DataFrame
Correlation Analysis in SAS | Proc Corr In SAS
zhlédnutí 995Před rokem
Correlation Analysis in SAS | Proc Corr In SAS
How To Find Confidence Interval In SAS
zhlédnutí 1,1KPřed rokem
How To Find Confidence Interval In SAS
How to Use Pandas Query Method To Filter A DataFrame
zhlédnutí 340Před rokem
How to Use Pandas Query Method To Filter A DataFrame
Great video
Thanks a lot @Kiranvenna
Unfortunately, your channel does not support automatic video subtitles
Most of the videos have video subtitles. Only few of them doesn't have subtitles.
🎉 great tutorial!!
Thanks a lot
Not able to implement a use case where I need to create a column with ternery operator using assign. It works with apply but not assign. Can you show if ternery operation is possible with assign?
Thanks for making this video. I have posted it as a link on my LinkedIn post. This proc has served me well for over a decade.
Thanks a lot for your feedback
Very good explanation ❤
nice video Analytics School
Low video quality
Hi, Thanks for the feedback, I just checked the whole video and the quality of sound and video seems good to me. Would you mind if you can recheck the video again. Sometimes its an internet issue that causes it
Hello sir, is there any other use of LOC method other than readability in this Filtering of DataFrames
Hi Manohar, its mainly readability and that is why developer use LOC method in comparison to any other methodology
you are rocking @analyticsschool
Great Explanation sir 👏
Great Job sir
Thanks Manohar
Really good presentation very helpful :)
Glad it was helpful!
great video thanks, there might be a slight typo in your code, when you do that msp = lambda x: x['sales'] / x['discount'] . And this typo can be simply corrected by this 'peace of code' unit_price = lambda x: x['sales']/(1-x['discount'])/x['quantity'], here as an output you will also have a unit price, skipping all those steps with solving the infinity problem in your code, when you do that msp =
hi,can we calculate C.I. by using PROC FREQ(Not in binomial method ) just like you have done using PROC UNIVARIATE?
Hi Adam, as you have mentioned correctly the only way we can calculate the CI for categorical variable when we have binomial distribution as you have mentioned in your question. Just for reference, I am including the link of Yale where they have write an excellent example on the same www.stat.yale.edu/Courses/1997-98/101/catinf.htm
great explanation
i have never come across like this wonderful explanation of chi-square test.In continution to the knowledge provided in the video,please add all the methods,explain various other statistical parameters.Tq.
Thank you very much for clear explanation
Wow Greta 🎉
Nice explanation @analyticsschool
Hi Sir, Thank you for making fantastic video, could you please guide me on the following code: I’m just going to create a new variable named hsn and assign that as a twin just for the cases in which chrt_num starts with “Y” and “X”, but when I run this code, it will give me the twin for all the records not just for the chrt_num that starts with “Y” and “X” data ds2; set ds1 ; if substr(strip(chrt_num),1,1) in (‘Y’, ‘X’) THEN hsn=”twin”; tables matched/norow nocol ; run;
Very helpful!
Thanks Sanman
Thank you sir
All the best
Nice Video @analyticsschool
Wow, I'm amazed. Explained so well. Thanks for the video
GREAT GREAT VIDEO ! Thanks !
Excellent
Thanks
Can you sum 2 variables in the proc summary? Getting the max value of the 2 variables and add them? I'm trying to do that in macro it's giving error.
I doubt you can do that by using Proc Summary.
Sir, please add more classes of SQL and Python for data analysis.
Sure... I will try to increase the frequency of the the videos on SQL & Python
sir please improve audio
The pace of your tutorial is just like class room training which is what i wanted and everything is explained with ease and i was able to do parallely. I dont know why it has less views. Thank you for uploading the content. The entire content is very useful for beginners in data analysis.
Thanks Yamini for your feedback.
Goos❤
🙋 Promo*SM
Excellent. Your instructional videos are very good. You are doing a lot of service through your videos. Thanks a lot and lot
Great explanation 👍 Could you make a video about end =eof and could you have more zoom on your example, actually it's hard to see your example in your video I just listen to you cuz it's hard to see your sas code while you are writing
Thanks a lot that you find the video useful. If you will watch latest videos the zoom issue has been taken care of. I will try to make a video on End = EOF asap.
Awesome this
Hi Sir, Thanks for the great teaching I have 2 column and I’m looking for those data values in which (mom_num)=baby(num) +prefix B, could you please tell me, how can I code that in SAS? mom_num baby_num 12 . 32 . 14 B14 17 B17 … For exp, I need 14=B14 17=B17
Hi, I am assuming mom_num is string field. You can use this code baby_num=cats('B',mom_num)
@@analyticsschool Thank you so much
Am learning a lot from you sir ... Thank you...
I am glad, you find it helpful :)
Very clear explanation
Thanks
Super explaination sir
Glad you like it
cool video
Sir am learning sas program Any suggestions please..
Hi Vamsi, If possible, please describe your goals for using SAS programming, such as clinical SAS, statistician, SAS programmer, or data analyst. I might be able to guide you more effectively.
@@analyticsschool CLINICAL SAS..
Dear Vamsi, to develop your skills in line with Clinical SAS, the first thing you must do when working with any firm is pull the data, and the majority of organizations utilize SQL; even with cloud-based technology, they have a SQL-based environment. Additionally, aim to earn your Base SAS, Advance SAS, and Clinical SAS certifications. Clinical SAS certification offers a strong brand value in the market, making you more in-demand and earning more money. It is optional, but it will help you communicate your findings more effectively if you learn how to use a data visualization tool like Tableau or Power BI.
@@analyticsschool Thank you sir Your suggestions means a lot to me...
No Problem. You can reach out to me if you need any help.
V. Good 👌
Thanks
excellent explanation
The order of the topics is perfect and the explanations are clear, concise, and very useful. Thank you for another great tutorial!
Awesome 👍
Good