How to Import CSV Files to Google's Colab Notebooks

[@DataSlayerMedia]

New video tutorial showing how to do style transfers with Google Colab. ruclips.net/video/f1UK8KPt-KU/видео.html

[@democraticgroup3034]

I've worked on this exact problem all day, I went to numerous sources and was at wits end. And you finally provided the answer. Thank you Craig, really appreciate it.

[@Coopervise]

Thank you for the comment. When I made the video I also looked hard for a solution.

[@sanashaikh3238]

This is what , I was searching from last 3 hours , thank you so much for this video . You saved my time 😊

[@koumospecial]

Man, I owe you. Thanks for that.

[@yashesh7264]

it worked flawlessly.

[@belle7087]

My god!!! This saved my day thankyou very much

[@rajeswarinimmanapudi441]

thank you so much For this video, THANKS A LOT

[@ruminasmarume]

You helped me thanks

[@jesuscastellanos8033]

Very nice, Gregg! Thanks a lot!

[@FelipeMaffezzolli]

Thanks man! Solved my problem!

[@srijithscientia8614]

Thanks for the video🤩🤝

[@tanayshrotri9671]

thanks a lot for this!!

[@megavathrathod8014]

Great work!!

[@gniebles]

Thanks a lot, i always want to know how to make it. It is very useful. Regards

[@maharshiyeluri4289]

Thanks, Dude ! Cool stuff

[@qasidsaleem147]

Made my day! Thanks a lot...

[@kamaldeep1885]

Thanks a lot it is very help full

[@TheMathVirtuoso]

UnicodeDecodeError: 'utf-8' codec can't decode byte 0x96 in position 6: invalid start byte
During handling of the above exception, another exception occurred:
UnicodeDecodeError Traceback (most recent call last) getting this error while reading the file

[@saadmanahmed860]

thanks for this very very helpful tutorial

[@josht7238]

thanks for this video helped me so much

[@Coopervise]

Glad it helped!

[@pleabargain]

Thanks for posting.

[@naveen7837]

Thanks a lot sir, so easy

[@samueldasmianus6151]

thank you bro. It's works

[@kelijunior7871]

When I put this code in: df = pd.read_csv(io.StringIO(uploaded['Athletes.csv'].decode('utf-8'))),
I receive this error message: KeyError Traceback (most recent call last)
in ()
----> 1 df = pd.read_csv(io.StringIO(uploaded['Athletes.csv'].decode('utf-8')))
KeyError: 'Athletes.csv'.
I have followed all instructions on your video, now I get this error message. Could you please tell me what I am doing wrong?

[@lydiahidouche9670]

THANKYOU SOOO MUCH 😭😭😭😭😭

[@krishnapavan7633]

Thank you very much for you help

[@hardikkamboj3528]

Thanks a lot buddy...you made my day

[@srinivassree4288]

thanks for the videos..
one concern when I uploaded 200MB file it took almost 25 mins..My internet connectivity is good.is there any work around for this?

[@iamsikandarkhan]

Thanks MAN!

[@rishabhmittal7626]

Works, Thanks!

[@dyukel]

you are my hero! thankyou!

[@fz7181]

Thanks a lot!!
I want to know how you got your date in sample.csv in 01-02-2019 format. I can't change my format it's in 01/02/2019 format

[@Coopervise]

I didn’t do anything to change the date format.

[@robind999]

very good demo. thanks,

[@ikejimenez3836]

Thank you!

[@knowledgesolution4640]

Thank you so much sir my problem solve

[@waytolive7055]

nice! and Can I make csv to tfrecord file?

[@Sivx76]

THANK YOU!!!!!!

[@prabhakarpawar5720]

whats the steps for uploading excel file

[@yasaswinidesu2225]

I am able to print only 4 rows ,how can i print the whole sheet

[@Coopervise]

Sorry are you asking about physical printer from Sheets? I’ve unfortunately not ever printed out my Sheets.

[@putin9614]

how can we import folders of images of dogs and cats used in CNN for classification and recognition... please reply

[@naveenhettiwaththa5426]

You can create a numpy array of image data and upload the numpy file instead of uploading a folder.You can create training and testing numpy arrays using the image folder locally. And upload those numpy files in to the colab

[@quanghuy8794]

did you try pd.read_csv("sample.csv") ?

[@sujittitun]

that's awesome buddy, made my day !!!!!

[@miltonezpinoza4923]

Thanks!!!

[@IsraIbrahim90]

Can you please tell me how to do it for .xlsx files? I followed your example change pd.read_csv to pd.read_excel but that didn't work

[@Coopervise]

I have not tried with an excel file because the formatting may be different. Is there a chance you can convert your file to csv & try?

[@akhilsingh0003]

But why you do that, df=pd.read_csv('sample.csv') after uploading the file simply give you the data frame.

[@Coopervise]

I’m not fully understanding the question? Also at the time I made the video I just tried to present methods that seem to work at the time. I understand coding a lot better now.

[@memescompilation6477]

getting an message error any solutions??
MessageError Traceback (most recent call last)
in ()
----> 1 uploaded = files.upload()
2 frames
/usr/local/lib/python3.6/dist-packages/google/colab/_message.py in read_reply_from_input(message_id, timeout_sec)
104 reply.get('colab_msg_id') == message_id):
105 if 'error' in reply:
--> 106 raise MessageError(reply['error'])
107 return reply.get('data', None)
108
MessageError: TypeError: Cannot read property '_uploadFiles' of undefined

[@ephi124]

Thanks.

[@digimortalll]

Thanks. Great

[@sayan_sarkar_7]

thanks bro...

[@erinhwang217]

When I tried uploading my csv, it doesn't show 100% done. Note, my csv is 2gb. Is this a problem?

[@Coopervise]

Sorry I don’t know the size limits. I would suggest testing with a smaller file.

[@Jinsh0]

Question: Do we need to uploade everytime we close our Google Colab, and then let's say open again the next day to continue work with our .csv?

[@samklopp3172]

Did you try? what did it turn out?

[@Jinsh0]

@@samklopp3172 Not successful, I tried, but my .csv need some further tweaking.. I end-up using kaggle.com instead, which I now prefer to use..

[@abchrisyou]

thank you so much

[@serfe4552]

thank you

[@allmightqs1679]

Can I access local files on my laptop from colab without having to upload the files on the drive?

[@Coopervise]

I believe this method uploads the files to the Cloud for it to work.

[@allmightqs1679]

@@Coopervise yeah, but isn't it a pain if I have to upload my datasets onto the drive, just to get colab to detect it? Do you know an alternative where I don't need to upload my datasets onto the drive?

[@Coopervise]

@@allmightqs1679 The option of using Colab Notebooks is just an option. You could use Jupyter Notebooks if you want to have a longterm connection to your local system. I think more people may worry about security if a Cloud product always was connected to your local drive.
Everyone has different use cases. This solution worked for me at the time I made the video & I couldn't find any videos at the time showing how to do this. This doesn't seem like the right solution for you.
I specifically discovered this method so I could write code, share the notebook & my coworkers or agency team could run the code on their own datasets.
I myself would use Jupyter Notebook if I needed to always connect to my local file.

[@allmightqs1679]

@@Coopervise yeah, but jupyter don't have the GPU/TPU feature right? That would seriously cripple one's processing time. Do you if there's an environment like colab that provides GPU and at the same time allows access to local files?🙈

[@Coopervise]

@@allmightqs1679 I unfortunately am not sure about this particular feature from a Cloud service. For me just uploading a csv via the code in the video was my approach.

[@cube7439]

Thanks

[@ghozyanhilmanpradana1759]

how to eksport to CSV?

[@lydiahidouche9670]

THANKYOU SOOO MUCH 😭😭😭😭😭

[@atikahauliaputri6677]

How can I read multiple files inside a folder in Google Colab and read_csv() into one dataframe?

[@Coopervise]

Sorry I haven't tried to do that before.

[@atikahauliaputri6677]

@@Coopervise no worries I've tried to upload the folder in zip file and unzip it then I use glob to loop reading the csv. It works. Thanks anyway

[@shaylan2518]

thank you

[@priyag4412]

Thanks

[@christopherteddymienarto9115]

Thank you

[@Coopervise]

No problem

[@codyhugie5653]

Thank you