How to Read Excel Files with Python (Pandas Tutorial)

[@Claudio-gv2lz]

amazing video, this was like an introduction to data analysis in a very short video, cheers

[@SorianoTech]

Good video Dave. Let's keep it up :)

[@AarJay8587]

How Dave is seeing individual variable values.. ex he selects 'data' and we can see the values at right side pane.

[@Planning_Statistics]

Could you upload statistical analysis exclusively through python

[@bin4ry_d3struct0r]

Yes, in my experience, XLSX files do not play perfectly nice with Pandas, whereas CSV files never posed a problem.

[@tiborszekeres5798]

hello sorry for my dumb question but I would like to know how did you managed that in your right panel in your VSCode the actual python code is running?

[@daveebbelaar]

Check out this video: kzbin.info/www/bejne/aaSsq3Z8qrGaf7M

[@tiborszekeres5798]

@@daveebbelaar thanks!

[@matthewdaunis]

How are you inserting the comment blocks? # ----- # # -----

[@daveebbelaar]

Hey Matthew, I am using VS Code snippets for that. Check it out here → kzbin.info/www/bejne/kJKraKF7r8yLbdE

[@daveebbelaar]

And here's the code: "Create code block header": { "prefix": "#", "body": [ "# --------------------------------------------------------------", "# $1", "# --------------------------------------------------------------", ], "scope": "python" },

[@matthewdaunis]

@@daveebbelaar Thanks, you're the man!

[@gg-zj2xq]

this tutorial is just bad, u just seem to assume that everybody is intermediate to advance and u actually skip through a lot of the intermediate steps (like if u type pip install pandas into veocore u get an error), this means that anybody with basic knowledge is unable to follow through