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.
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...
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.
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?
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?
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
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 ?
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
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
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.
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 "
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.
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='\\')
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...
@@ZaidShaikh_619 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.
data ='('a,b,c ','4,apple,orange, ','5,cow,buffalo,') pd.read_csv(StringIO(data),usecols=['b','c'],index_col=False) I get the below error: TypeError: initial_value must be str or None, not tuple , Please help fixing this.
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
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'
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
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!
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
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
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..
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 really dont need to academic courses with your course. so thankful. i wish more course were on your channel. for software engineering🤩
i tried watching other python playlists but your way of explanation is so easy to understand thank you for this video ❤❤❤
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...
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.
hey plz guide me from where can i practice the problems
your tutorials are easy to understand Krish ...thank you brother
call him sir not brother
pretty much simple, pretty much easy😀😀
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 🙏
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.
Nice share sir.
Thanks a lot !!!
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.
Link for dataset?
10:28 ..without using ' ; ' also , it shows the same output. what is need of ' ; ' . CAN YOU EXPLAIN
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?
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
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
thank you so much sir for such a nice explanation
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
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 ?
Hi Krish,
thanks for the awesome videos. Can you tell plz when 2 months paid ML program will start??
Excellent Sir!
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.
What to download in kaggle datasets. Please provide link of the dataset you used
also if we write column a also in usecol then the values 4 and 8 will not be used as index
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
awesome🔥
thank you sir for your hardwork !!! Can you also do a video on healthcare EDA by python !
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
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..!!
bhai
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?
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.
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
Thanks a lot Krish
good video overall but some small mistakes and misunderstandings in inbuilt functions.
Sir can u plz tell about edwisor
Is it good or not
hello sir, can you please tell me where i can get .csv files for practice?
plz provide the link of this data sett
Hi Krish,
how to load CSV file in django Controller ????????.
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
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
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.
I am getting an error for the 29[ ] input please can someone help? It says exception found another exception.
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
thanks its reakky help to me sir
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='\\')
Day 2 - 17/02/2024
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
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? 😵
@@ZaidShaikh_619 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.
the url to CSV is getting error like: HTTPError: HTTP Error 403: Forbidden. What to do now ?
data ='('a,b,c
','4,apple,orange,
','5,cow,buffalo,')
pd.read_csv(StringIO(data),usecols=['b','c'],index_col=False)
I get the below error:
TypeError: initial_value must be str or None, not tuple , Please help fixing this.
Time 28:15 i have lots of error pleased help me.
Thank you sir
cannot import stringIO from .....getting this error while importing
sir please provide dataset link
can anyone please provide me the link for the data set of mercedes benz?
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. :)
files are not able to download from Github
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 think usecols with column name is not working anymore
Unable to import stringio and bytesio
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
try chat gpt
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
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!
Please provide link for dataset
help needed StringIO() is not working in my jupyter notebook
yes did you find the solution?
my dataset is not loading why??? mercedes one
how did you get that data set ? Can you provide me the link of it
hey can anyone plz guide me from where can i practice the problems
how to download that dataset
Is this ml playlist complete
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.
how to read multiple file under one variable
How and where to download mercedes.csv file
Not showed how to import StringIO
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
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
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
thanks
I was the first to view and like!
❤
Df.head() SHOW ONLY TOP 5 ROWS
Tut-6//done
13/04/2024
jupyter notebook is showing string io is not defined
how can I deal with it?
import StringIo
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??
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.
getting this type of error like syntax error
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?
Ads are frustrating
Hello Krish can give me a link for kaggle
y sb learn krne h kya????
data = ''' col1,col2,col3
x,y,1
a,b,2
c,d,3'''