In this video we will see a simple exercise.
How to do it with T-SQL and how to do it using Python Pandas.

Video that served as inspiration for this one: https://www.youtube.com/watch?v=TRwsRPcVgD8

Pandas documentation:
crosstab - https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.crosstab.html
DataFrame.reset_index - https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.reset_index.html

𝗗𝗼𝗻'𝘁 𝗳𝗼𝗿𝗴𝗲𝘁 𝘁𝗼 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗯𝗲 𝗮𝗻𝗱 𝗮𝗰𝘁𝗶𝘃𝗮𝘁𝗲 𝘁𝗵𝗲 𝗯𝗲𝗹𝗹 𝗯𝘂𝘁𝘁𝗼𝗻!
Help me know if you want more videos like this one by giving a Like or a comment :)

𝗣𝗹𝗲𝗮𝘀𝗲 𝗰𝗼𝗻𝘀𝗶𝗱𝗲𝗿 𝗴𝗶𝘃𝗶𝗻𝗴 𝗮 𝗱𝗼𝗻𝗮𝘁𝗶𝗼𝗻 𝘀𝗼 𝗜 𝗰𝗮𝗻 𝗶𝗺𝗽𝗿𝗼𝘃𝗲 𝘁𝗵𝗲 𝗾𝘂𝗮𝗹𝗶𝘁𝘆 𝗼𝗳 𝘁𝗵𝗶𝘀 𝗰𝗼𝗻𝘁𝗲𝗻𝘁 𝘁𝗵𝗮𝘁 𝗜 𝗺𝗮𝗱𝗲 𝗳𝗼𝗿 𝗮𝗹𝗹 𝗼𝗳 𝘆𝗼𝘂 :)
https://bit.ly/2Hdu9vb

Download source code at: https://drive.google.com/file/d/1-kpQ9RaDkMXoaCl2xZEwmNzXjGLcCdnl/

Other videos:
Run Python Script from SQL Server - Hello World - https://youtu.be/QEMKYY3dgcg
Run Python Script from SQL Server - Parameters - https://youtu.be/RMtT-yVY1TQ

Run Python Script from SQL Server - Plot Example - ht…