Tutorial 6- Pandas,Reading CSV files With Various Parameters- Part 2
Вставка
- Опубліковано 3 сер 2024
- Hello All,
Welcome to the Python Crash Course. In this video we will understand about Pandas library, how to read CSV files and play with different parameters
github url : github.com/krishnaik06/Machin...
Support me in Patreon: / 2340909
Connect with me here:
Twitter: / krishnaik06
Facebook: / krishnaik06
instagram: / krishnaik06
If you like music support my brother's channel
/ @ultralifeproject
Buy the Best book of Machine Learning, Deep Learning with python sklearn and tensorflow from below
amazon url:
www.amazon.in/Hands-Machine-L...
You can buy my book on Finance with Machine Learning and Deep Learning from the below url
amazon url: www.amazon.in/Hands-Python-Fi...
Subscribe my unboxing Channel
/ @krishnaikhindi
Below are the various playlist created on ML,Data Science and Deep Learning. Please subscribe and support the channel. Happy Learning!
Deep Learning Playlist: • Tutorial 1- Introducti...
Data Science Projects playlist: • Generative Adversarial...
NLP playlist: • Natural Language Proce...
Statistics Playlist: • Population vs Sample i...
Feature Engineering playlist: • Feature Engineering in...
Computer Vision playlist: • OpenCV Installation | ...
Data Science Interview Question playlist: • Complete Life Cycle of...
You can buy my book on Finance with Machine Learning and Deep Learning from the below url
amazon url: www.amazon.in/Hands-Python-Fi...
🙏🙏🙏🙏🙏🙏🙏🙏
YOU JUST NEED TO DO
3 THINGS to support my channel
LIKE
SHARE
&
SUBSCRIBE
TO MY UA-cam CHANNEL
I wish, I could have liked 1000 times, but I will make sure to hit like on 514 videos till now and upcoming videos. Watched a lot of informative videos, then completed Statistic playlist of yours, now here on ML list. Hope to end this with a lot of practice till the end of this month.
Hey there, how far have you reached in your data science journey? Also is it worth it to watch his videos to learn data science?
i tried watching other python playlists but your way of explanation is so easy to understand thank you for this video ❤❤❤
i really dont need to academic courses with your course. so thankful. i wish more course were on your channel. for software engineering🤩
Dataset of mercedez is here: www.kaggle.com/swetashetye/mercedesbenz-greener-manufacturing
@@payaldhekwar2717 download the zip file in any of your location and then upload that file in the home page of jupyter notebook, I hope it will work
Thank you
thank you krish naik for your support to all the beginners
i regularly watch your channel i can understand your way of presenting ,but i have not viewed these playlist as i am doing hit or trail job,but these gave me an idea(minute points) especially the error part...
your tutorials are easy to understand Krish ...thank you brother
call him sir not brother
Nice share sir.
Thanks a lot !!!
thank you so much sir for such a nice explanation
Let's understand StringIO concept
a multi-line string data that mimics the contents of a CSV file. Each line represents a row in the CSV, with columns separated by commas. The
denotes a newline, so the string represents a table with columns col1, col2, col3 and two rows of data.
The StringIO module from the io library in Python is used to treat a string as a file-like object. This is useful because pd.read_csv expects a file-like object as an argument, so we need to convert our string data into a file-like object.
pretty much simple, pretty much easy😀😀
Excellent Sir!
thank you sir for your hardwork !!! Can you also do a video on healthcare EDA by python !
thanks its reakky help to me sir
Thanks a lot Krish
Hi Can you suggest me that in which order should I go through your playlist to make my final year project (Pneumonia Detection using Machine Learning) from scratch ?
awesome🔥
Sir if we remove the comma's in the last of the 2nd and 3rd col in data .... 4 and 8 the values will not be assigned as index then... but this mistake is good we got one use acse of index_col ..i m enjoying these videos thanks
Link for dataset?
Thank you sir
Hi Krish,
thanks for the awesome videos. Can you tell plz when 2 months paid ML program will start??
Why are you not working on deployment playlist. A full playlist will be truly awesome. And thank you for your channel. Helps me a lot
He is not teaching only properly....i had to check other channels
Sir Your videos are very helpful, Thanks a lot.Sir I have one request, please make a video on how to convert json to csv/dataframe.
already that video is available after this one
Hello
Thank you for your lectures.
Please at 5:53, what's the name of the x1-x8 columns? I didn't get the name correct. Thank you 🙏
Sir can u plz tell about edwisor
Is it good or not
good video overall but some small mistakes and misunderstandings in inbuilt functions.
also if we write column a also in usecol then the values 4 and 8 will not be used as index
It would have been better if you have shared that excel file.. Has he already shared it somewhere? If yes, please help me out guys..!!
Didn't understand the concept " df['a'][1] " , because the row should come first and then the column right? How come it is interchanged here?
thanks
Hey Krish..Thanks for the lecture...Could you please make a small video on how to use GitHub to get/work on some dummy projects
There are already many vids on that.
did not get how hello, "Bob", nice to see you became one value. We did not escape the comma. We only escaped the double quotes
data='a,b,
"hello, \\"Bob\\",nice to see you",5'
pd.read_csv(StringIO(data),escapechar='\\')
In kaggle the whole dataset is divided into train and test unable to import it as shown in the video . Can anyone suggest me what to do?
What to download in kaggle datasets. Please provide link of the dataset you used
hello sir, can you please tell me where i can get .csv files for practice?
ThankYou Sir. Really these videod are very helping. Sir i have a small doubt about working of panda and numpy. How we are able to call the different methods with the help of directory name. Like np. anyfunction. However np is numpy alias and numpy is package not module.
I don't know why you are trying to call a package with a directory name instead of giving a short name like np.
Sir....where will i get the csv file ....i mean the mercedes benz data?
i searched it in Google but i did not get it.
Can you help read csv file on databricks using panda
df=pd.read_csv('mercedesbenz.csv') doesn't work, though with filestore full path
pandas_df = pd.read_csv("/dbfs/FileStore/tables/mercedesbenz.csv") - this is also not working
bhai
Krish Naik Sir I am following your videos regularly can you please send me the dataset i have used the dataset that people kept in comments but in that df.y is not working and there are no values of 'y' in it so please send it sir
Time 15:23
I am facing as issue. i can't use the last column in any of my code.
Like i have written:
pd.read_csv(StringIO(data), usecols=['col1','col2'])
The error reads:
ValueError: Usecols do not match columns, columns expected but not found: ['col2']
Can anyone help me out with this?
i am getting the same error
Use names instead of usecols.
plz provide the link of this data sett
Sir help me out .i am facing a problem .if I am applying any operation on data it work on only first column .e.g like if I want to change data type of col1 then it is successful excuted but if I apply same Operation on other col then it shows some error "don't match columns "
facing same issue
Hi Krish, i think you haven't uploaded few videos of python like class-5 part 2 and class-6 part 1. Getting difficulty to follow the subject. Please upload missing videos as well thanks
Hi, Tutorial 6 Part 2 is the continuation of Tutorial 5 Part 1 if am not mistaken. :)
Hi Krish,
new_df = pd.read_csv("C:\Users/911.csv")
^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
I'm getting this kind of error I tried all the possible ways like keeping r before "c:/" and changing the black slashes to forward and copied the path and pasted their and still I'm not getting the error resolved.
10:28 ..without using ' ; ' also , it shows the same output. what is need of ' ; ' . CAN YOU EXPLAIN
Where do we get 'Mercedesbenz' dataset from?
i am unable to download the mercedez file, please help me. on clicking the download it is taking me to a tab and it shows all 0s and 1s
According to logic at 23:15 on row index, at 21:31 the values in first column -4,8 should be displayed as row index right ? why it did not happen?
Yeah even I faced the same problem
@@balasaiallagadda2791 you need to avoid putting comma at the end of third item in each row.
@@rohanmehra1695 can you explain the logic behind that please?
@@VinayakNagriyo read_cvs assumes data entry after every comma. so it takes u NaN as the third entry after the blank third comma.
sir please provide dataset link
Hi Krish,
how to load CSV file in django Controller ????????.
I was the first to view and like!
Anybody solution, # One or more of the following lines contains an error
# Correct it so that it runs without producing syntax errors
birthday = "2017-07-14"
case_id = 'DATACAMP!123-456'
I am getting an error for the 29[ ] input please can someone help? It says exception found another exception.
❤
Time 15:23
Sir, am facing as issue. i can't use the last column in any of my code.
Like i have written:
pd.read_csv(StringIO(data3), usecols=['Qt','Taste'])
So here, error comes in place of 'Taste' because it was the last column.
Except last column, every column works fine. Why?
The error reads:
ValueError: Usecols do not match columns, columns expected but not found: ['Taste']
Can anyone help me out with this?
Verify if there is a space at the end of the line in CSV file. If there is a space the column name is not 'Taste', but 'Taste '
Even I had faced the same issue with usecols
how to read multiple file under one variable
can anyone please provide me the link for the data set of mercedes benz?
Hi sir is macbook pro 15 inch which has 4gb graphics card good for deep learning? We can also connect external gpu with it? I am planning to buy it since my current laptop is slow for deep learning as it only has integrated gpu and 12 gb ram which is slow for training models...
12 gb ram is slow? 😵
@@someonesomebody716 For deep learning it is slow. It takes about 30 minutes to train a basic nural network . Although most of the ML algorithms run flawlessly.
I make handwritten notes...is it equally beneficial?
i guess practising while learning and commenting the notes part will be easier. you can just ctrl+f you confusions in the future :D
It's showing error in the last section (url to csv) Can anyone tell why so and how to take url and convert to csv
Just one request. can you get rid of words like "very very" , "different different" , "many many" while you speak. Single words are enough to express the meaning. You materials are great though!
cannot import stringIO from .....getting this error while importing
how to download that dataset
Please provide link for dataset
StringIO is not defined i am getting this in my jupyter notebook can some explain me please what am i doing wrong?
from io import StringIO
StringIO(data)- I don't understand by this declaration. Anyone please clarify?
If you have csv file to make it as data frame or to differentiate columns and rows, stringio function will read that csv file and convert it to data frame for user to understand. Simple terms simple representation of csv data or file to dataframe
Hello Mr.Krish,
Good Afternoon!
Where is the part 1, as i am not aware of that, can you please share me the part 1.
Check my playlist
ua-cam.com/video/QUClKFFn1Vk/v-deo.html
@@krishnaik06 ok I will check it.
files are not able to download from Github
help needed StringIO() is not working in my jupyter notebook
yes did you find the solution?
Is this ml playlist complete
Unable to import stringio and bytesio
I think usecols with column name is not working anymore
I'm literally gonna say 'This lecture went really over my head!'
Can someone help?
what is the problem that you face?
@@mathematics_infinity_pi2779 can you tell about this StringIO why is it used
@@ritikasingh8671 make the string to value of a column... which shows in the data frame
Day 2 - 17/02/2024
my dataset is not loading why??? mercedes one
how did you get that data set ? Can you provide me the link of it
How and where to download mercedes.csv file
Df.head() SHOW ONLY TOP 5 ROWS
unable to download mercedes.csv
www.kaggle.com/yogeerp/mercedes/data . This is the link go and login to kaggle then download the zip file. after that extract that file in any location , then upload it in the home page of jupyter. After these steps hopefully it will work
Not showed how to import StringIO
Can anybody tell how to get that full list of operation names starting with same alphabet..
Like when u typed pd.r after typing r u get full list of operation names starting with r.. Like read_feather, read_excel etc..
after clicking r you have click on TAB keywords.
Tut-6//done
13/04/2024
unable to import or create csv file, can anyone explain?
www.kaggle.com/yogeerp/mercedes/data . This is the link go and login to kaggle then download the zip file. after that extract that file in any location , then upload it in the home page of jupyter. After these steps hopefully it will work
@@AjayChauhan-vs7do thank you
I have question I try to read file from my Mac but it’s not working or I have no idea how to upload it ? Please sir or anyone help me how to do it?
Time 28:15 i have lots of error pleased help me.
getting this type of error like syntax error
Hello sir,
I am unable to join your 59 rupees plan. It is showing that card details are wrong.
Gpay option is also not working.
So what should I do??
jupyter notebook is showing string io is not defined
how can I deal with it?
import StringIo
Hello Krish can give me a link for kaggle
Ads are frustrating
y sb learn krne h kya????
data = ''' col1,col2,col3
x,y,1
a,b,2
c,d,3'''