Upload Excel or CSV file in google drive and connect from Colab Python platform using mount drive

Google colab platform we can use to read data from Excel or csv or from SQLite database file. We can place our files in google drive and use google mount to connect to these drives.
We will read data from one excel file and create a Pandas DataFrame.
Google colab uses Jupiter Notebook which we can create and same in our google drive. With this combination our entire database handling or file managing can be operated from google cloud platform.
To connect to google drive here is the code.
from google.colab import drive
drive.mount('/content/drive')
By using read_excel() we can connect to excel file and read the content of the file to create a dataframe.
Similarly we can read CSV file data and display the same.
#jupiterNotebook #Colab #ColabToDrive #PythonToDrive #Pandas #dataframe #ColabToDrive #googledrive #plus2net #python

[@gwwyy_]

Thanku❤

[@iffatmehrindisha5517]

Thanks a ton, man
it's working

[@plus2net1]

Glad to know that, thanks

[@sumeshs1202]

thank you soo much sir.

[@plus2net1]

So nice of you

[@Willichimaru]

Really helpful thank you very much for the help

[@plus2net1]

Thanks, glad to know that

[@poojabramhvanshi904]

Thank you sir

[@SilviaVeronicaNoriega]

Hello, when I use the command drive.mount to log in the drive account, there's no code, but instead of, it shows a message saying "Mounted at /content/gdrive"

[@plus2net1]

Once you run the code , you will get a link to visit and collect the authorization code. Visit the link and you must login to our google account to get the code.

[@SimplifiedEngineeirng]

Yes that’s rights
If the pop up window doesn’t appear that means it’s mounted in the background

[@Hulk-987]

when i save my .csv file in drive and when i open it on my google colab it is coming as .gsheet extension can u please help me out

[@plus2net1]

I uploaded one csv file to drive it came as csv only. For csv file to work with google colab , you have to mount it first.
Here is one some time back I worked.
th-cam.com/video/4u59d9np7Rk/w-d-xo.html
You can get all details here.
www.plus2net.com/python/colab.php

[@Feliannn]

Can i make it update every time there is a change in the database?

[@plus2net1]

Yes, even you can use SQLite ( file based database ) at google drive and from colab platform connect and manage it.
Using google drive API google sheets can be managed also. More details available here.
www.plus2net.com/python/pygsheets.php
Database can be kept in Cloud and operate the same from local platform also.

[@iffatmehrindisha5517]

i created the exact path for excel file but after run the file, it's showing 'the path is not defined'.can you help me?

[@plus2net1]

I hope it worked for you.

[@avi417]

How to count how many female and male in excel file in google colab

[@plus2net1]

There are many ways, one is read the excel file and create a Pandas dataframe and then all data we can generate.
Or directly from python you can rad google sheet.
www.plus2net.com/python/pygsheets.php
There are many functions like countunique() to get the numbers
Let us know which one you are using so I can tell you exact function to use