Google Colab Python - Dataset Exploration

 

Watch video above...

#colab #python #dataexploration Data exploration is important task in Data Analysis. We have shown in this video on #Howto analyze the content of dataset using #GoogleColab, colab platform works on #PythonProgram After watching this video, you will know, 1. Naming dataset in Python 2. How to find the dimension / shape of dataset 3. Data types in Python 4. Changing object to #datetime data type in Python 5. Describe function in Python 6. How to find #NullValue / #EmptyCell /#NA in dataset Google Colab can be accessed with Google login in link - https://colab.research.google.com 00:00 Introduction 00:45 Naming dataset in Python 01:40 Dimension / Shape of Dataset 03:45 Data types in Python 06:51 Changing Object #DataType to DateTime Data type 09:05 Describe Dataset in Python / Summary of Dataset 10:40 Finding Number of NA / No Value / Null Value / Empty cell in dataset 12:43 Conclusion Access our Python playlist with the link - https://www.youtube.com/watch?v=pedhtDm-qhc&list=PLIo8gVJ3Lwqhq_C0-OrWxxJsCpAgNYMNi If you have any queries, please post it in comment section...

Excel Filter Function and Radio Button in Excel

 

Watch the video above...

#ExcelFilter #RadioButton #FilterFunction Excel Radio button is very useful in #ExcelDashboards. Excel filter formula with Switch function in Excel helps us to add radio button in excel #Pakuppaivu channel has posted video on #Excel filter function which is available in #Office365 version and also shows how Radio buttons can be connected to filter function to create dynamically filtered array. Filter function can be used to filter the data as per our required condition. #SwitchFunction helps to connect the control of Radio button with filter output 00:00 Introduction 00:40 Filter Function 02:18 Accessing Radio Button 03:10 Creating Radio Button 06:21 Connecting filter output and Radio Button using Switch Function 07:50 Conclusion If you have any queries, post it in comment section...

Import dataset to Colab from Google Drive / Local Drive - Python

 

Watch the video above...

#importdataset #colab #python We can import dataset to Google colab from #localdrive as well as from #googledrive. In this video we have explained on #Howto mount Google drive on Colab then importing dataset to Colab also shown how to import dataset from local drive in #laptop or #desktop Introduction to Google Colab / Python - https://youtu.be/pedhtDm-qhc If you have any queries, please post it in comment section...

Carriage Return and Concatenate - Excel Tips and Tricks

Watch the video above...

#CarriageReturn #Concatenate #Excel Carriage Returns allows you to #WrapText within a cell or within a merged set of cells. Carriage return can be executed using "Alt+Enter" in Excel Combining Multiple cells data can be done using #concat or concatenate function in Excel as well using #Ampersand (&) In this video we have also about carriage return and concatenate as well shown about how to execute carriage return within concatenate 00:00 Introduction 00:55 Carriage Return 02:14 Combine multiple cells data using Concat / Concatenate 03:40 Carriage Return within Concat / Concatenate function 04:20 Combine Multiple cells data using Ampersand (&) with Carriage Return 06:00 Conclusion If you have any queries, please post it in comment section or at our blog - https://pakuppaivu.blogspot.com

 

Python - Google Colab - Introduction

Watch the video above...

#Python #GoogleColab #Pakuppaivu Our channel videos are compiled under three different playlists as below,

1. Excel Tips and Trick - https://www.youtube.com/playlist?list=PLIo8gVJ3LwqhkLGdoyZWW1UTKUT2jGXHV

2. Project Management - https://www.youtube.com/playlist?list=PLIo8gVJ3Lwqh1BbYl0BQzh3N6FR51wAPC

3. Supply Chain & Procurement - https://www.youtube.com/playlist?list=PLIo8gVJ3LwqhLIXib2FtrMBHll4AClLgi

We will start posting videos on Python. Python is one of the fastest growing #programming language globally. We will use Google #Colaboratory to run Python program. #Google colab can be accessed through ling - https://colab.research.google.com We require gmail ID for logging in to Google colab which is linked to #GoogleDrive

 If you have any queries, please post it in comment section...

Speedometer Chart / Gauge Chart creation in Excel

Watch the video above...

#speedometerchart #gaugechart #pakuppaivu Project Completion status, On-Time Delivery, Percentage rejections, Units produced per hour, etc can be shown using gauge chart / speedometer chart. Creation of gauge chart / speedometer chart may sound difficult and many of you thinks that it requires specialized #datavisualization software but we are showing you through this video that we can easily create speedometer chart / gauge chart in #Excel #ComboChart in Excel helps us to create this chart with simple few steps, we have also shown the usage of #datavalidation in Excel in this video 00:00 Introduction about Speedometer chart / Gauge chart 01:44 Setting up to create Speedometer chart 02:58 Custom Combo Chart 03:40 Combo Chart to Speedometer 06:50 Formatting Speedometer 08:05 Data Validation 10:05 Text Formatting 11:55 Changing Speedometer Scale 13:03 Conclusion If you have any queries please mention it in comment section...

Create QR Code using Excel / Word / Powerpoint

Watch the video above...

#QRCode #QR4Office #Pakuppaivu QR Codes has taken over Bar Code due to its adaptability in storing information and ability to scan QR code using smart phones. Presence of QR is everywhere from payments to packaging. Creation of QR code may be seen as complex task but many of us may not aware that QR code can be generated using EXCEL. In this video we have shown how to create QR code using Excel as well as #MSword, we can also create QR code in #PowerPoint 00:00 Intro 00:40 QR Code creation using Excel 02:50 QR Code creation using MS Word 04:02 Conclusion If you have any queries please post it at comment section...

Video Creator Contest - Pakuppaivu

Prizes:

Cash Prize of Indian Rupees 5000/- for No.1 Video Creator

Complementary Prize for 10 Video Creators of Indian Rupees 500/- Each.

Last date for submission: 30th November-2021

Rules and Regulations:

This contest will be abide by the below rules and regulations,

• Winners will be selected from first 1000 eligible entries for this contest
• Entries shall be made by video creator by filling this google form
• Facebook and Mobile Number details asked in the form is optional however filling those details will allow us to send appropriate communication in right time
• Video should be minimum 10 minutes of length
• Video content must be in English language
• Video's concept shall be related to technical contents like data analysis, excel tips & tricks, useful software, etc. which shall be helpful to young professionals in their career
•  Age of the participant has to be minimum 18 years
• Video shall be uploaded to Google drive and shared with pakuppaivu@gmail.com with rights to download
• Last Date to submit your video is 30th November - 2021
• Any queries related to the contest shall be communicated in writing through email to pakuppaivu@gmail.com
• Winners / Any update about this contest will be announced in any of the below social media platform of us, participants are requested to follow for updates

• Pakuppaivu YouTube Channel
• Pakuppaivu Facebook Page
• Pakuppaivu Blog

Terms and Conditions:

• Pakuppaivu YouTube Channel reserves the right to select Winner / Prize / Complementary Prize for this contest
• Prize money mentioned will be paid to the winner in Indian Rupees / in foreign currency (preferably USD) equivalent to the prize money announced in Indian Rupees
• Pakuppaivu YouTube Channel reserves the rights to cancel the contest without any communication / notification to the participants
• Copied, Duplicate, Fraudulent, Adult contents will not be entertained and this will lead to strict action as per applicable law and regulations
• By taking part in this contest, you are confirming / allowing Pakuppaivu YouTube Channel to upload and / or telecast your video content submitted for this contest publicly in their YouTube Channel / Facebook Page / any other social media associated with them. You / any other person / entity / business involved in that video creation shall not claim any copyright / loyalty for the video content created by you / other person / entity / business
• Prize money to winners will be paid through wireless method like Bank transfer / NEFT / Wallet Money transfer based on the possible method of payment available. Any charges applicable shall be borne by the recipient.
• Prize money announced is in Indian Rupees, any charges associated with your bank account / wallet shall be to your account