Data Analysis with Python for Excel Users - Full Course
video description
Date: 2022-03-14
Related videos
Comments and reviews: 10
TheAl217
Thank you for taking the time to create this course and sharing your knowledge with others.
Just some constructive criticism here, based on my experience using Excel for many years.
In my opinion people looking to move to pandas from Excel are serious users of this package. I didn't find content here that will make me think I really need to move away from Excel to gain this capability.
Also Excel's PowerQuery has a lot of powerful transformation capabilities.
Instead of doing the visualizations, people may have benefitted more from examples covering merge, groupby, stack, unstack, melt, resampling and even how list comprehensions can be used to add columns based on conditions.
reply
Thank you for taking the time to create this course and sharing your knowledge with others.
Just some constructive criticism here, based on my experience using Excel for many years.
In my opinion people looking to move to pandas from Excel are serious users of this package. I didn't find content here that will make me think I really need to move away from Excel to gain this capability.
Also Excel's PowerQuery has a lot of powerful transformation capabilities.
Instead of doing the visualizations, people may have benefitted more from examples covering merge, groupby, stack, unstack, melt, resampling and even how list comprehensions can be used to add columns based on conditions.
reply
freecodecamp
That's the best content I've seen on jupyter and pandas so far! well done champ! I've spent my whole weekend going along on this course and I totally love it! Very well structured and full of examples you can run and you can test out on your own. had a minor set back on opening the csv file dgp but added the encoding parameter: df_gdp = pd.read_csv(-gdp.csv- , encoding=-latin-1-)
reply
That's the best content I've seen on jupyter and pandas so far! well done champ! I've spent my whole weekend going along on this course and I totally love it! Very well structured and full of examples you can run and you can test out on your own. had a minor set back on opening the csv file dgp but added the encoding parameter: df_gdp = pd.read_csv(-gdp.csv- , encoding=-latin-1-)
reply
Samuel
Hi, thank you for this wonderful course. I use excel to play the lottery and I was wondering if there's a way to use both excel and python to analyze lottery history and try to predict lottery numbers? I'm completely new to python but have been using excel for a while now.Please help me and thank you for you help.
reply
Hi, thank you for this wonderful course. I use excel to play the lottery and I was wondering if there's a way to use both excel and python to analyze lottery history and try to predict lottery numbers? I'm completely new to python but have been using excel for a while now.Please help me and thank you for you help.
reply
xMastJedi
I am Excel user with long time experience. I go through this course. And to be honest, I can't see ANY comparison to excel. Only one thing is better - this no limit on rows numbers.
I will deep more with Python, maybe one day I will find something I can use. So far I see nothing. Sorry.
reply
I am Excel user with long time experience. I go through this course. And to be honest, I can't see ANY comparison to excel. Only one thing is better - this no limit on rows numbers.
I will deep more with Python, maybe one day I will find something I can use. So far I see nothing. Sorry.
reply
MHN
Excuse me, off topic question, I just want to know how did you add the bracket symbols and the single quote symbols to both sides of the selected string, like in 2:53:04? Btw, thank you so much. The course is helpful and easy to follow for such a new data learner like me.
reply
Excuse me, off topic question, I just want to know how did you add the bracket symbols and the single quote symbols to both sides of the selected string, like in 2:53:04? Btw, thank you so much. The course is helpful and easy to follow for such a new data learner like me.
reply
Tim
Questions: does Jupyter Notebook have a feature to show the cursor horizontal location? PEP 8 says to limit lines to 79 characters, but I cannot tell where this is. Also, it the common style to put spaces in-between operators but not when including function arguments?
reply
Questions: does Jupyter Notebook have a feature to show the cursor horizontal location? PEP 8 says to limit lines to 79 characters, but I cannot tell where this is. Also, it the common style to put spaces in-between operators but not when including function arguments?
reply
xMastJedi
Nice training, Thanks.
I am courious is it just me with gdp.csv file open problem?
UnicodeDecodeError
# error: Too many arguments for -ParserBase-
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf4 in position 20740: invalid continuation byte
reply
Nice training, Thanks.
I am courious is it just me with gdp.csv file open problem?
UnicodeDecodeError
# error: Too many arguments for -ParserBase-
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf4 in position 20740: invalid continuation byte
reply
Kenny
I believe that the inflation is already priced in crypto market since the end of last year. These manipulative rats are always 2 steps ahead of everybody because they are market makers. I hope I-m wrong and they won-t keep dumping it on retail investors as always.
reply
I believe that the inflation is already priced in crypto market since the end of last year. These manipulative rats are always 2 steps ahead of everybody because they are market makers. I hope I-m wrong and they won-t keep dumping it on retail investors as always.
reply
Emo
How can we create custom styles to our python UI outputs ? Let's be honest, python charts are so ugly they would never be commercially accepted in a meeting etc. If someone showed me ugly outputs like this for data visualization I would fire them immediately.
reply
How can we create custom styles to our python UI outputs ? Let's be honest, python charts are so ugly they would never be commercially accepted in a meeting etc. If someone showed me ugly outputs like this for data visualization I would fire them immediately.
reply
Manuel
Honestly I skimmed the video and I still find it hard to realize WHY I should move from Excel to this, I mean, Excel seems a lot more -user frinedly- and simple fro this type of tasks. Can anyone tell me a good reason?
reply
Honestly I skimmed the video and I still find it hard to realize WHY I should move from Excel to this, I mean, Excel seems a lot more -user frinedly- and simple fro this type of tasks. Can anyone tell me a good reason?
reply
Add a review, comment
Other channel videos
