For anyone confused, Skiprows is a parameter which is 1-indexed, if you pass in 0 then it will actually remove the column names since the parameter treats the column names as the 0th row. So in a sense, while it technically is 0-indexed, it considers the column names as the 0th index and so we have no use of using that. This makes it 1-indexed in use.
There was a time when we had to visit 100s of channel to learn intricacies of a technology. But now we have Nitish Ji who covers everything A to Z. From very simple task to complex one, under a single channel. Really Thanks to you.
Literally Speaking. the way of teaching by u Sir is appreciable, I have learned ML from ZTM but your course is enormously so much useful and understandable.....Warmed Respect for u Sir
WATCHING YOUR VIDEO IN THE YEAR 2024, SHOULD SAY THE CONTENT STILL LOOKS FRESH, YOU HAVE AN AMAZING WAY TO TEACH DUMMIES. REALLY APPRICIATE YOUR EFFORTS. KEEP GOING
In December 2024, I am going through especially this informative video and it is really awesome video for CSV related challenges. Great work. Keep it up.....
Great Playlist so far. but just one correction: for the chunks part - (35:00) you are printing chunk, but u named it 'chunks' in the for loop, as a result it's printing maybe another dataframe above u created before. Generally, the chunks will be the same size as mentioned in chunksize parameter. so for the example in the video, the shapes would be (5000,14),(5000,14),(5000,14),(4158,14). Try it yourself
sir your explanation is very clear and in right pace, clear understandable content and warmed respect from me waiting for deep learning and nlp complete playlist thankyou very much.
Why people are spending lakhs of rupees in the institute? I have been going through various institute videos but now here i got the real thing within a month I'll be the data scientist.
31:10 If you want to shorten all the team names, you can use the following code: def rename(name): list1 = name.split(" ") temp = '' for i in range(len(list1)): temp += list1[i][0] return temp
def rename (name): words = name.split() return ''.join((word if word[0].upper()=='X' else word[0].upper()) for word in words) for the edge case - 'KXIP' :3
@@mango-strawberry just see his next video in the series, the link to his GitHub is given in the description box. You'll find all the days files over there.
in skiprow part the main rows of data are starting from index 1 not 0 , when u was doing 'skiprow[0,5]' u was deleting the header row and the 4th row sir...
19.01. If you use 0 then it will refer to the row which incorporates the column names. So actual rows start from 1 onwards. And this will resolve the issue.
create a video on data warehouse , no sql data bases and big queary . [ explain data marts , data lakes, pipelines and etc in details ] [data engineering in depth]
i have learned about all function of csv and the names of functions are chunksize, no_values , error_bad_lines , parse_dates, encoding, sep, skiprows, squeeze, names, usecols, nrows
Sir can we also do that we can paste that CSV file in notepad and then, open that text file in Excel and save it as CSV. By this we don't have to write code for opening a CSV file from the url.... Please reply is the right way to do.. or writing code is necessary..
sir can you please share google drive link which contains google colab of examples of all the parameters which we discussed today along with the datasets
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
bhai dil jeet liya tune , kash march mein hi mil jata tera channel
izzat kar le bhai thoda
@@VishalGupta-ji7yo me bhi aj dekh rha
Thoda tamiz se bola kar mere Guru Ji ko
@@surajbhagat4577 bilkul
For anyone confused, Skiprows is a parameter which is 1-indexed, if you pass in 0 then it will actually remove the column names since the parameter treats the column names as the 0th row.
So in a sense, while it technically is 0-indexed, it considers the column names as the 0th index and so we have no use of using that. This makes it 1-indexed in use.
yeah even i did noticed that, i dont know why they consider column name as 0th index
There was a time when we had to visit 100s of channel to learn intricacies of a technology. But now we have Nitish Ji who covers everything A to Z. From very simple task to complex one, under a single channel. Really Thanks to you.
Literally Speaking. the way of teaching by u Sir is appreciable, I have learned ML from ZTM but your course is enormously so much useful and understandable.....Warmed Respect for u Sir
Best channel on youtube.
It's channel's like yours that make social media worthwhile.
Dhanyavaad dost
WATCHING YOUR VIDEO IN THE YEAR 2024, SHOULD SAY THE CONTENT STILL LOOKS FRESH, YOU HAVE AN AMAZING WAY TO TEACH DUMMIES. REALLY APPRICIATE YOUR EFFORTS. KEEP GOING
Same
@@TechFlow_HubLokeshsame
In December 2024, I am going through especially this informative video and it is really awesome video for CSV related challenges. Great work. Keep it up.....
You are doing a great job brother, respect and appreciation from Pakistan👍✊
Bhai ap great ho !!
khush rho.. bht kch seekhne ko milta hai ap sy
hats off to you
Love and lots of respect from a student from Pakistan 😍
Great Playlist so far. but just one correction: for the chunks part - (35:00)
you are printing chunk, but u named it 'chunks' in the for loop, as a result it's printing maybe another dataframe above u created before. Generally, the chunks will be the same size as mentioned in chunksize parameter. so for the example in the video, the shapes would be (5000,14),(5000,14),(5000,14),(4158,14). Try it yourself
You are a gem.. Kudos for such amazing content!!
How can I contact you? I want to be your student!!
Amazing! I was in search of such detailed explanation video and I found this playlist. Thank you for your effort.
metoo
@@Cha_Nu6 hii, Any highlights or exciting things you’ve done?
sir your explanation is very clear and in right pace, clear understandable content and warmed respect from me
waiting for deep learning and nlp complete playlist thankyou very much.
Sir You are just gem of gem for aspirants like us 😍😍😍😍❤❤. I don't know why u don't have got millions of subscribers 😫
Why people are spending lakhs of rupees in the institute? I have been going through various institute videos but now here i got the real thing within a month I'll be the data scientist.
Did you become one?
Did you become data scientist or data analyst
Aik saal hugya Bhai...ab batao
at 17:32 squeeze is no longer supported that way. updated version is like this -
pd.read_csv('aug_train.csv',usecols = ['gender']).squeeze()
31:10 If you want to shorten all the team names, you can use the following code:
def rename(name):
list1 = name.split(" ")
temp = ''
for i in range(len(list1)):
temp += list1[i][0]
return temp
def rename (name):
words = name.split()
return ''.join((word if word[0].upper()=='X' else word[0].upper()) for word in words)
for the edge case - 'KXIP' :3
One of the best channel for learning ML
Thank u so much sir for improve my knowledge. God bless u
Bahut badiya content tha, as a beginner bahut kuch seekhne ko mila. Thank you sir , aise hee ML videos aur b chahiye 💜
bhai 4 hajaar ka course ma dought aaya fir link milla saare dougt solve ho gaye
sir, you put all your effort to produce good content keep it up sir
very well explained .. As you said , this has most things that we will see regarding read_csv
one of the best content for ML platform ,.... Sir you are GOD 🙂
amazing sir ,bahut zayda baareek cheeze explain kari hai aapne thanqu sir
Learning with great understanding with you Sir, I hope this will help me in my next Course of Generative AI.
interesting, informative and amazing lecture
Thanks for the detailed season just a question from where can I get this files?
Where can we find the jupyter code for this video
were you able to find it?
@@Garrick645 which link?
I'm pasting the link but UA-cam is not letting me post the comment
@@mango-strawberry just see his next video in the series, the link to his GitHub is given in the description box. You'll find all the days files over there.
@@Garrick645 thanks I was able to find it.
thank you for showing direction, #ML, #Machine learning,#MACHINE LEARNING, # csv, #HOW TO OPEN CSV IN PANDAS...... ---
following the path
Very Easy Explanation.
Thanks sir ji😀
Kamaal ho Sir g ap ... God Bless u
Jp here,
Thank you Sir.
in skiprow part the main rows of data are starting from index 1 not 0 , when u was doing 'skiprow[0,5]' u was deleting the header row and the 4th row sir...
luckily i got your channel..thanks !!
19.01. If you use 0 then it will refer to the row which incorporates the column names. So actual rows start from 1 onwards. And this will resolve the issue.
35.26 you need to use chunks instead of chunk.
Thanks sir 😊
Thanks a lot for making this playlist. really appreciated.
i was looking for UTF-8 error .thank you boss🙏🙏🙏🙏🙏
Amazing sir. Hats off to you
Sir, you are a real hero
Sir aap best ho
opening a csv file from url ..why this snippet is not working with other url ??
Legend ---
mai ML pdh paa rha hu sir k wjh s aaj
Course Started : ML
Lecture-01: 14/08/2024
Lecture-02: 14/08/2024
Lecture-03: 14/08/2024
Lecture-04: 14/08/2024
Lecture-05: 14/08/2024
Lecture-06: 15/08/2024
Lecture-07: 15/08/2024
Lecture-08: 15/08/2024
Lecture-09: 15/08/2024
Lecture-10: 15/08/2024
Lecture-11: 16/08/2024
Lecture-12: 16/08/2024
Lecture-13: 17/08/2024
Lecture-14: 17/08/2024
Lecture-15: 18/08/2024
create a video on data warehouse , no sql data bases and big queary . [ explain data marts , data lakes, pipelines and etc in details ] [data engineering in depth]
sir can you please share the ipynb file probably with all the dataset link.
Skiprows start counting including the header line
Very useful video. Thank you sir
skiprows only skips starting rows 19:15 ....
Awesome Explanation
Javascript Object Notation
Isn't that should be like this?
for chunk in dfs:
print(chunk.shape)
print out:
(5000, 14)
(5000, 14)
(5000, 14)
(4158, 14)
Very helpful video
where do i get the dataset used in this video
i have learned about all function of csv and the names of functions are chunksize, no_values , error_bad_lines , parse_dates, encoding, sep, skiprows, squeeze, names, usecols, nrows
error_bad_lines has been updated as on_bad_lines. r u able to use error_bad_lines??
@@dostirathi8254 you are right. It has been updated.
Please do not forget to give data.....as it interferes with learning process
Loved your videos, Please make videos on advanced robotics as well
At 35:20 how the hell is this not throwing an error ?
i mean "chunks" in dfs and inside loop there is variable "chunk"
chunks ke jgh pr nrows use nhe krskte ...we can specifiy nrows=500 ...or something
Bhaiya, don't get me wrong, but iss video ke notes provide karna chahiye tha, means jo bhi code karwaye uska
Love your contents ❣️
sir you are the best......
If u guys have error usingerror_bad_lines =False
Use
On_bad_lines ='skip'
In newer version of pandas on is used and not error
finished watching
awesome explanation bro
keep it up
Sir where is the code and notebook
thankyou!
It was very usefull. thanks a lot...
Very Intereseting Video
Maja aagya sir...🥰
Thank you so much sir 🙏🙏
Not supposed to tell internal details of a MNC
where to find the notebook
Sir can we also do that we can paste that CSV file in notepad and then, open that text file in Excel and save it as CSV. By this we don't have to write code for opening a CSV file from the url.... Please reply is the right way to do.. or writing code is necessary..
inn sab ke github codes kaha available honge sir ?
If u got the link pls share with me
How to filter csv file in which words with mixing of aplha and numbers.
Can we see GNN in upcoming videos with lot of examples.
Thax
very good videos
can you please share github link of this notebook?
I have some questions regarding the header. It is associated with the OS and browser. How can we use the same header from different OS and browsers?
can we get the notes of professor?@Campusx
superb
sir can you please share google drive link which contains google colab of examples of all the parameters which we discussed today along with the datasets
Check description
where is link of codes and datasets? plz help
U just doing great..
code snippet kaha dala he sir
Is there any way to access github for this
Sir, please provide notebook. Thank u.
Thank you so much for beautiful content.
But how to handle txt file?
where is the link of notebook ?
have you got it ?
Hello Sir, XGBoost is not included in playlist, could you please make a video on XGBoost ?
i have one question can you provide us your notes :)
Where to get the jupyter notebook
HI, SIR HEADER IS SAME WHEN WE OPENING A CSV FILES FROM AN URL.
thank you so much
can anyone pls provide the dataset which is not encoded in utf-8
Bro , if i just run pd.read_csv(url). Then also it works. isnt it?
Yes
Where i find my headers and how to get the header??
How to take User input for CSV file and process it
18:25
How can I get the file
encoding='ISO-8859-1' works for all file
Sir, How do I load the dataset from the github. please ....