Free Excel Classes for Adults Week 2

Yesterday was week 2 of free Microsoft Excel classes.  In the beginner class of week 1 there were both kids and adults. Strongly felt the need to separate the kids and adults classes.  So yesterday's class was restricted only to adults.

Thank you Bharatiya Mandir for this wonderful opportunity.  The topics covered in this 2 hour session are as below:

• Working with multiple worksheets
• Text and Date Functions
• Functions for Summarising Data
• Pivot Tables

Again enjoyed interacting with everyone.  

Thanks to Krina and Harshavardhan for all your help in running this class.

Here a few glimpses from the session.

Day 4 of #30daysofML Learning

Below is my learning for Day 4 of #30daysofML

The datatype for boolean in python is 'bool'

Boolean operators are used for comparison

3.0 == 3

'3'== 3

Comparison operators can be combined with the arithmetic operators 

Remember to use == instead of = when making comparisons.

Booleans are most useful when combined with conditional statements like if then else statement

Python has a functions as below:

• int() function  which turns things into ints, 
• float() functon which turns things into floats, 
• bool() function which turns things into bools.
• Calling bool() on an integer returns False if it’s equal to 0 and True otherwise. 
• int(True) is 1, and int(False) is 0.

We can use non-boolean objects in if conditions and other places where a boolean would be expected. Python will implicitly treat them as their corresponding boolean value:

Here is the order of precedence of operators in Python

Operator	Description
(expressions...), [expressions...], {key: value...}, {expressions...}	Binding or parenthesized expression, list display, dictionary display, set display
x[index], x[index:index], x(arguments...), x.attribute	Subscription, slicing, call, attribute reference
await x	Await expression
**	Exponentiation 5
+x, -x, ~x	Positive, negative, bitwise NOT
*, @, /, //, %	Multiplication, matrix multiplication, division, floor division, remainder 6
+, -	Addition and subtraction
<<, >>	Shifts
&	Bitwise AND
^	Bitwise XOR
|	Bitwise OR
in, not in, is, is not, <, <=, >, >=, !=, ==	Comparisons, including membership tests and identity tests
not x	Boolean NOT
and	Boolean AND
or	Boolean OR
if – else	Conditional expression
lambda	Lambda expression
:=	Assignment expression

Free Excel Classes week 1

Yesterday I have started free Microsoft Excel classes for the people in the community who were interested.  There was a good turn out of around 30 people.  Thank you Bharatiya Mandir for this wonderful opportunity.

Thoroughly enjoyed interacting with everyone.  Thanks to Krina. Smriti, Medha and Harshavardhan for all your help in running this class.

Here a few glimpses from the session.

Day 3 of #30daysofML from Kaggle

Below is my learning for today as part of Day 3 of #30daysofML

help()

help(round)

help(round(-30.18)

help(print)

Defining functions

Builtin functions are great, but we can only get so far with them before we need to start defining our own functions. 

Example if we want to calculate the least difference between 3 numbers

def least_diff (num1, num2, num3):

diff1 =num1-num2

diff2 =num2-num3

diff3 =num3-num1

return min(diff1, diff2, diff3)

Functions start with a header introduced by the def keyword. The indented block of code following the : is run when the function is called.

return is another keyword uniquely associated with functions. When Python encounters a return statement, it exits the function immediately, and passes the value on the right hand side to the calling context.

If there is no return in the function, then the function will not return anything.

But there are some functions with no return statements inside them.  Examples are print() and help()

Python allows trailing commas in argument lists. How nice is that?

Day 2 of #30daysofML from Kaggle

 Below is the learning for today as part of the #30daysofML challenge

• Variable assignment
• Print function
• #commenting the code in Python
• Variable reassignment
• Writing conditional statements using if

The colon (:) at the end of the if line indicates that a new code block is starting

The * operator can be used to multiply two numbers (3 * 3 evaluates to 9), but we can also multiply a string by a number, to get a version that's been repeated that many times. Python offers a number of cheeky little time-saving tricks like this where operators like * and + have a different meaning depending on what kind of thing they're applied to. 

What is type function used for ?

type(spam_amount)

The // operator gives us a result that's rounded down to the next integer.

print(float(10))

print(int(3.33))

# They can even be called on strings!

print(int('807') + 1)

Day 1 of #30daysofML from Kaggle

I signed up for the 30 days of ML challenge organised by Kaggle.  It started today.  

I am so excited to learn Machine Learning as part of this initiative.

The tasks that were completed on Day1 were as below :

• Created a kaggle profile
• Used Titanic Datasets to load the train and test datasets
• Used a Random Forest Algorithm to make predictions for Survival
• Submitted my first prediction for the competition. 

I am looking forward for Day 2

Power BI Competition for 10 to 14 year old kids -- India Batch

Yesterday was a big day for me as it was the Power BI competition day for 10 to 14 year old kids who have gone through the free virtual Power BI training classes. 

 This time I started providing free virtual training classes in Power BI for 10 to 14 year old kids who are based in Hyderabad, India. This program was undertaken in conjunction with the Sri Sathya Sai Seva Organisations, Hyderabad, India. Weekly classes started from 14th Feb 2021 continuing for 15 weeks and we concluded these classes by conducting a Power BI competition for Kids on Monday the 24th May virtually. 21 kids aged between 10 and 14 years presented their Data Analysis using Microsoft Power BI which they have learnt during these classes. The topics that kids picked ranged from Avocado, mines in India, candy population to book stations and sales and financial analysis. 

The judges were Mr. Reza Rad Director Radacad, Microsoft Regional Director and Microsoft MVP and Mrs. Leila Etaati Co-Founder Radacad and Microsoft MVP.   Thanks a lot for patiently listening to each and every presentation.

Congratulations to the winners Snehith Senkula, Hasini Vanam and Akshara Rao for their winning visualisations. All kids have done a great job in preparing and presenting their visualisations. 

Many thanks to the District President A. Malleswara Rao and the District Balvikas Coordinator M. Latha for giving us this opportunity to train the Balvikas kids. 

Thank you for all the huge help extended by Govardhani Tammina and Harshavardhan Tammina for making this whole journey a very smooth one! 

If you are interested in watching the video, you can watch it here 

 Below are few photos of the final event.

wellness chatbot