bharath bhimshetty take your time to learn from great teachers, try to fully understand what they are saying. Its not wasting time while learning cause you will inevitably waste your time on some other stupid things.
Alt Cunningham jup, you prob won’t learn much from trying to speedrun the video. Taking your time and actually trying these functions is way more usefull.
Treat this comment as appreciation. It's awesome to follow your videos and I am slowly getting a lot of hands-on in Python coding. I highly appreciate your efforts that people are getting educated with your videos.
only half way through and I'm already excited about what I've gained from this! can't wait to try this when I get to the computer. thank you for such clear explanation!!
In the starting I learned Java script and I also used Notepad++ but now learning python from you bro you are super cool your videos are very interesting hands off 🙏🙏
This is such a good tutorial. Simple and smooth without giving any complex explanation. Explaining by examples rather than the theory behind it. Thank you so much. Subscribed!!!
i found your videos so fascinating ,i had wached several videos before i got yours and there i understood nothing therefore thanks for an amazing tutorial
I was searching for over a week the whole internet, how to print rows, where the country was "Germany" ("Snow"). You explained this in a few seconds. If I could give you 100 Likes, I would do this. Thank you very MUCH
Awesome tutorial, thank you for putting this together, i've been learning Pandas in my spare time but I had quite a few light bulb moments watching your videos.
Step by step roadmap to learn data science in 6 months: ruclips.net/video/H4YcqULY1-Q/видео.html How to learn coding for beginners | Learn coding for free: ruclips.net/video/CptrlyD0LJ8/видео.html
thank you so much but I am coding on Pycharm and I can't write the code that I want to make filter >13 I write it like this print(data_frame['tempreature']>13
import pandas as pd weather_data = { 'day' : ['1/1/2017','1/4/2017'], 'temperature' : [32,35], 'windspeed' : [6,7] } df1 = pd.DataFrame(weather_data) df1 = pd.read_csv('weather_data.csv') df1 why it doesnt provide only these three row result
df.loc['1/3/2017'] is not working for the date. Rest all fields are working properly with df.loc. but date returns an error again and again. Can someone please help
Excellent - so well presented with great ecplanations. I have looked at a lot of Pandas tutorials and these are the best I have come across. Very clear explanations and you can tell the presenter has a very good understanding of the subject. Something many others don't have. Will be checking out some of his other videos. 👍
import pandas as pd import numpy as np import matplotlib.pyplot as plt import seaborn as sns subset={ 'idno' : [1023, 1049, 1219, 1246, 1078, 1221 ], 'name' : ['David','Amelia','Alan','Ram','Ashley','Jim' ], 'team' : ['red','yellow','red','yellow','red',' yellow'], 'strwgt': [189, 145, 192, 194, 127, 220 ], 'endwgt': [165, 124, 192, 177, 118 , 184 ] } print(subset) print() print('CREATE ABOVE SUBSET AS A DATAFRAME' ) print() df=pd.DataFrame(subset) print(df) user =input('Enter value:') for i in user: print(i) what is the error in above code i want retrive data as per user input please tell me
import pandas as pd my_df=pd.DataFrame(Data=[4,5,6,7], index=range(0,4), columns=['A']) print(pd.DataFrame(my_df)) TypeError: __init__() got an unexpected keyword argument 'Data' it shows like this please help me sir. Why dataframe as error ? :(
@@codebasics, thank you for your reply. Sir, how can we use SQL and pandas more effective with minimum line of code. Please make video related to this.
I got it now. I used another method called "read_excel" from pandas. with "read_excel" it is working but with "read_csv" it is not working. please anyone can tell me why?
El video muy bien explicado. Paso a paso a fin de entender el proceso completamente bien. Por ahora no hay dudas. Espero que surgan pronto! Muchas gracias! Me encantó!
These are so great. I've been looking all over for the best introduction as a person converting from Excel, and yours is way better than others I've come across.
can you please help me on this code I want to make filter on the data frame about what it's temperature is > 13 , and I am coding on Pycharm , so I write it like this print(data_frame['tempreature']>13)
Sir your explanation are very informative. People like me do not have coding background who want to understand Dataframe this is the right channel to learn Once again Thankyou verymuch for this kind vedios
Is there a command to show every variable in a column? For example if you had a large database with lots of different variables under 'Weather' would there be a command to show a list of them all and how many in each?
I am enjoying this playlist very much. Also completed numpy, python as well. Your explanation style with real life data and examples is preety much fascinating and interesting and it motivates me to play with data which makes a good player in case of performing EDA. Thanks for your efforts for us sir
Thank you Sir for this awesome tutorial. I could not grasp any idea about pandas from other videos. I luckily found this video and I am gonna complete the series and try different datasets.
Machine learning tutorials with exercises: ruclips.net/video/gmvvaobm7eQ/видео.html Step by step roadmap to learn data science in 6 months: ruclips.net/video/H4YcqULY1-Q/видео.html
Check out our premium machine learning course with 2 Industry projects: codebasics.io/courses/machine-learning-for-data-science-beginners-to-advanced
Literally, your pandas playlist is better than any other paid courses.
Thank you so much ❤
really, u must have a very fast eyes movement. he is ok. great learning is good too. try both to learn more
I am watching your videos in 2x...and I am still comfortable in understanding also saving my time..
bharath bhimshetty take your time to learn from great teachers, try to fully understand what they are saying. Its not wasting time while learning cause you will inevitably waste your time on some other stupid things.
Alt Cunningham jup, you prob won’t learn much from trying to speedrun the video. Taking your time and actually trying these functions is way more usefull.
I'm also watching it in 2x. and later practicing 4x ....
And believe it's worth it.
What a legend, explains it so well. Exactly what I needed. Thanks
Comment==True
ruclips.net/video/dXVTRrxcOWY/видео.html
Who should file Return of Income according to law
Please like, comment, share and subscribe.
Thank you
@@zerostudy7508 in
Actually a great beginners tutorial
I just started learning Python for data analytics and this is a very good explanation on how we can use pandas. Thank you😀
Treat this comment as appreciation.
It's awesome to follow your videos and I am slowly getting a lot of hands-on in Python coding. I highly appreciate your efforts that people are getting educated with your videos.
only half way through and I'm already excited about what I've gained from this! can't wait to try this when I get to the computer. thank you for such clear explanation!!
ME TOO I AM SO EXCITED
Your tutorial is so good that I had to sign in to give you a thumbs up
In the starting I learned Java script and I also used Notepad++ but now learning python from you bro you are super cool your videos are very interesting hands off 🙏🙏
This is such a good tutorial. Simple and smooth without giving any complex explanation. Explaining by examples rather than the theory behind it. Thank you so much. Subscribed!!!
🤗🙏🙏🤔
try others like great learning, Mosh, and few other plonkers.
Its great that you don't cut video for errors
Thank you so much, I've literally searched for an hour now how to draw charts with conditions. I finally found it here.
I have taken classes and I have the basics but still confused your made it sattle in my head. Thank youl
i found your videos so fascinating ,i had wached several videos before i got yours and there i understood nothing therefore thanks for an amazing tutorial
I was searching for over a week the whole internet, how to print rows, where the country was "Germany" ("Snow"). You explained this in a few seconds. If I could give you 100 Likes, I would do this. Thank you very MUCH
Awesome tutorial, thank you for putting this together, i've been learning Pandas in my spare time but I had quite a few light bulb moments watching your videos.
Very effective teaching of pandas here. Thank you for such a great resource
Step by step roadmap to learn data science in 6 months: ruclips.net/video/H4YcqULY1-Q/видео.html
How to learn coding for beginners | Learn coding for free: ruclips.net/video/CptrlyD0LJ8/видео.html
clear cut explanation for beginners like me compared to paid courses. thanks sir
Awsome content...Great explanation...Far better than Paid Courses...Respect from Bangalore.
thank you so much but I am coding on Pycharm and I can't write the code that I want to make filter >13 I write it like this print(data_frame['tempreature']>13
Learnt about using short cuts along with simple pandas code examples for dataframe. Thanks.
Marvellous❤
Legendary explanation 👏 🙌
Today is my exam and I'm learning now at 5am....
Thanks Sir👍🏻
👍☺️ wish you all the best for your exam Ankit
@@codebasics Thank you sir 🙏 🙌
The best video on data frame basics. Thank you
Glad it was helpful!
"No such file or directory" i m frustrated with this line please help me !!!😞😞
me too
try to convert backward slashes to forward slashes
Well explained
Highly recommended for basics
I am happy this was helpful to you.
should we bow......yes, he is legend!!....wooooow
day temperature windspeed event
0 1/1/2017 32 6 Rain
1 1/2/2017 35 7 Sunny
2 1/3/2017 28 2 Snow
3 1/4/2017 24 7 Snow
4 1/5/2017 32 4 Rain
5 1/6/2017 31 2 Sunny
import pandas as pd
weather_data = {
'day' : ['1/1/2017','1/4/2017'],
'temperature' : [32,35],
'windspeed' : [6,7]
}
df1 = pd.DataFrame(weather_data)
df1 = pd.read_csv('weather_data.csv')
df1
why it doesnt provide only these three row result
i m unbale to dowbload file can you please tell me how it ll be download
check video description
Really explained in a great way...love it❤️❤️
Thank you so much 😀
shall i get notes of all these class
My question might be lame but
When setting another column as index,why is index column still exists?
where to define path if using dictionary method?
df[['day','event','temperature']]df[df.temperature==df['temperature'].max()]
Why this command is showing invalid syntax error?
Can anyone help?
Thank you! Outstanding tutorial
Thank you!
df.loc['1/3/2017'] is not working for the date. Rest all fields are working properly with df.loc. but date returns an error again and again. Can someone please help
If the csv file isn't in the jupyter notebook, what do I do?
You need to specify full file path in that case
Thanks for video
Commentaires
This is amazing! Thank you!
Thank you
Excellent - so well presented with great ecplanations. I have looked at a lot of Pandas tutorials and these are the best I have come across. Very clear explanations and you can tell the presenter has a very good understanding of the subject. Something many others don't have. Will be checking out some of his other videos. 👍
First video that got straight to the point
👍👍
You are very excellent
Tq but one doubt it's showing attribute error
thank you for this presentation
Glad it was helpful!
The explanation goes smoothly into the brain, if u listen carefully
ha ha... thanks Shaik
@@codebasics sir ur videos are superb, r u providing training also so i can join
Thanks bro for teaching me dataframe
But I don’t have excel how can I import?
Sir u r a genius 🤩🤩
Ur lectures were really easy to understand even for a utter beginner like me 👍😃
Love ❤️ from Tamilnaadu south of India 🇮🇳
Thanks a ton
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
subset={ 'idno' : [1023, 1049, 1219, 1246, 1078, 1221 ],
'name' : ['David','Amelia','Alan','Ram','Ashley','Jim' ],
'team' : ['red','yellow','red','yellow','red',' yellow'],
'strwgt': [189, 145, 192, 194, 127, 220 ],
'endwgt': [165, 124, 192, 177, 118 , 184 ] }
print(subset)
print()
print('CREATE ABOVE SUBSET AS A DATAFRAME' )
print()
df=pd.DataFrame(subset)
print(df)
user =input('Enter value:')
for i in user:
print(i)
what is the error in above code i want retrive data as per user input please tell me
too slow at normal speed, watch it at 1.25x or 1.5x. and yes this guy is Amazing.
Thank you so much for this video. It has helped me a lot in understanding dataframes.
I am happy this was helpful to you.
import pandas as pd
my_df=pd.DataFrame(Data=[4,5,6,7], index=range(0,4), columns=['A'])
print(pd.DataFrame(my_df))
TypeError: __init__() got an unexpected keyword argument 'Data'
it shows like this please help me sir. Why dataframe as error ? :(
Highly recommended to those who are searching for the perfect tutorial on Pandas! He literally reads a learners mind!
Filter can be done in SQL, why need pandas
Yes exactly it is very similar to SQL but sometimes using it in program in memory can be beneficial. That's why people use pandas
@@codebasics, thank you for your reply. Sir, how can we use SQL and pandas more effective with minimum line of code. Please make video related to this.
NOTbook
I know buddy. I have improved my pronunciation till than. By the way did you like the content of this video ? any comment on that?
@@codebasics amazing content bud
thank you
Sir i am getting this error. I have already tried a lot methods to fix this problem but none of them are working. please help me to fix this.
import pandas as pd
import os
df = pd.read_csv(r"H:\pandas coding\weather_data.csv")
ParserError Traceback (most recent call last)
in
----> 1 df = pd.read_csv(r"H:\pandas coding\weather_data.csv")
~\anaconda3\lib\site-packages\pandas\io\parsers.py in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)
674 )
675
--> 676 return _read(filepath_or_buffer, kwds)
677
678 parser_f.__name__ = name
~\anaconda3\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds)
452
453 try:
--> 454 data = parser.read(nrows)
455 finally:
456 parser.close()
~\anaconda3\lib\site-packages\pandas\io\parsers.py in read(self, nrows)
1131 def read(self, nrows=None):
1132 nrows = _validate_integer("nrows", nrows)
-> 1133 ret = self._engine.read(nrows)
1134
1135 # May alter columns / col_dict
~\anaconda3\lib\site-packages\pandas\io\parsers.py in read(self, nrows)
2035 def read(self, nrows=None):
2036 try:
-> 2037 data = self._reader.read(nrows)
2038 except StopIteration:
2039 if self._first_chunk:
pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader.read()
pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader._read_low_memory()
pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader._read_rows()
pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader._tokenize_rows()
pandas\_libs\parsers.pyx in pandas._libs.parsers.raise_parser_error()
ParserError: Error tokenizing data. C error: Expected 1 fields in line 4, saw 3
I got it now. I used another method called "read_excel" from pandas. with "read_excel" it is working but with "read_csv" it is not working. please anyone can tell me why?
is there anyone else who's hearing the sound only in left ear??
nope
your earphones are gone, bruhhhhh, RIP to your earphone
Thanks man
df.head() gives initial first 5 rows and df.tail() gives last 5 rows
Sir I get an error like module not found??
14:22 select column and filter
Very good tutorial. Sub'd. Thank you.
Sir you are great and you explained better than most of my faculty and online tutors thank you so much sir really helped a lot
Been going through your Python playlist and it's perfect. Absolutely great work on these videos.
El video muy bien explicado. Paso a paso a fin de entender el proceso completamente bien. Por ahora no hay dudas. Espero que surgan pronto!
Muchas gracias! Me encantó!
These are so great. I've been looking all over for the best introduction as a person converting from Excel, and yours is way better than others I've come across.
Thanks a lot for the video. Exactly what I was looking for. Keep making tutorials on data structure like this
can you please help me on this code I want to make filter on the data frame about what it's temperature is > 13 , and I am coding on Pycharm , so I write it like this print(data_frame['tempreature']>13)
@@ahmedhelal920 df["temprature"][df["temprature"]>13]
One of the Best tutorial i have seen about dataframes .. Bundle of thanks
You are the best tutor ever, that helped me alot. Thank you
Glad it helped!
Sir your explanation are very informative. People like me do not have coding background
who want to understand Dataframe this is the right channel to learn
Once again Thankyou verymuch for this kind vedios
Great, I am glad you liked it Senthil.
dude you are awesome. I dont leave comments but I learned soooo much. Saved my a** on my homework
You made me very comfortable to use pandas. Kudos to you
i have never seen such an excellent tutorial. explain in very simpler way with good ascent hats of to you
You are a great teacher. Thank you for helping me to start my data science journey.
THANK YOU SOOOOOOO MUCH. UNREAL. I'VE BEEN STRUGGLING FOR DAYS AND DUDE YOU'VE EXPLAINED IT ALL SO EASY. A MILLION THUMBS UP! THANKS!!! :D
Is there a command to show every variable in a column? For example if you had a large database with lots of different variables under 'Weather' would there be a command to show a list of them all and how many in each?
Wow thanks so much! do you do online tutoring or anything at all?
Ah okay. Thanks for your replies. Your videos are the best!!! :D
you are doing better job explaining than sentdex . Awesome brother !!
the speed at which he speaks is perfect for us Indians :)
it's so much better than coursera python course in data analysis
thank you
Thanks for explaining it with clarify, this is what I have been looking for
I am enjoying this playlist very much. Also completed numpy, python as well. Your explanation style with real life data and examples is preety much fascinating and interesting and it motivates me to play with data which makes a good player in case of performing EDA. Thanks for your efforts for us sir
A natural teacher!
very good starting for my understanding videoooo
Thank you Sir for this awesome tutorial. I could not grasp any idea about pandas from other videos. I luckily found this video and I am gonna complete the series and try different datasets.
Glad it helped!
No words to say! Awesome explanation.
Awesome job. This is great tutorial for Pandas dataframe introduction. Thank you!
I am glad it was helpful
Naught-Book, nicely explained
Great tutorial ! Thank you so much for this explanation. Exactly what I was looking for.
I am going to watch the next one right away :)
Very simple explanation and easy to understand.. Thank you !!
See mine pls.
Machine learning tutorials with exercises:
ruclips.net/video/gmvvaobm7eQ/видео.html
Step by step roadmap to learn data science in 6 months: ruclips.net/video/H4YcqULY1-Q/видео.html
A great explanation and covered almost important things in one video almost is superb, thanks a lot sir
thank you sir, you way of explanation is really amazing and it makes the concept simpler.
Great session of pandas, I learnt lot of about pandas DataFrame, Thank you sir for have a great session
Very well done. Easy to follow and explained simply. Thanks.
glad you liked it kevin
Awsome content Daval ....Keep up
Great Tutorial...I mean really Great Explaination