Python Pandas Tutorial ( Basics ) - Start Replacing Excel for Python 2021 Series

YouTube Excerpt: In this one we'll take a look at how we can start using pandas to do simple tasks Spreadsheet to work alongside me -- https://www.kaggle.com/tunguz/gold-prices?select=monthly_csv.csv Kite helps fund the channel, thanks for checking them out and supporting me -- https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=derricksherrill&utm_content=description-only ⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. Merch Store -- https://derricksherrill.store/ Support the Channel on Patreon -- https://www.patreon.com/join/derricksherrill Join The Socials -- Reddit - https://www.reddit.com/r/CodeWithDerrick/ FB - https://www.facebook.com/CodeWithDerrick/ Insta - https://www.instagram.com/codewithderrick/ Twitter - https://twitter.com/codewithderrick LinkedIn - https://www.linkedin.com/in/derricksherrill/ GitHub - https://github.com/Derrick-Sherrill ***************************************************************** 0:00 Introduction 0:50 Viewing The Data Source 1:14 Setting up Pandas 1:30 Importing Data 2:25 Viewing Data 3:34 Selecting Columns 4:40 Simple Operations 8:20 Graphing Data 9:56 Viewing Graph Full code from the video: import pandas as pd import plotly.express as px df_gold_prices = pd.read_csv('monthly_gold_prices.csv') # Viewing data print(df_gold_prices.tail(20)) dates = df_gold_prices['Date'] prices = df_gold_prices['Price'] # simple operations df_gold_prices['buy_price'] = prices * .9 print(df_gold_prices['Price'].max()) df_gold_prices['Date'] = df_gold_prices['Date'].str.replace('-', '') print(df_gold_prices) fig = px.line(df_gold_prices, x = dates, y = prices, title = 'Gold Prices over Time') fig.show() Packages (& Versions) used in this video: Pandas 1.3.2 Plotly ***************************************************************** Code from this tutorial and all my others can be found on my GitHub: https://github.com/Derrick-Sherrill/DerrickSherrill.com Check out my website: https://www.derricksherrill.com/ If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!! --- Channel FAQ -- What text editor do you use? Atom - https://atom.io/ What Equipment do you use to film videos? https://www.amazon.com/shop/derricksherrill What editing software do you use? Adobe CC - https://www.adobe.com/creativecloud.html Premiere Pro for video editing Photoshop for images After Effects for animations Do I have any courses available? Yes & always working on more! https://www.udemy.com/user/derrick-sherrill-2/ Where do I get my music? I get all my music from the copyright free Youtube audio library https://www.youtube.com/audiolibrary/music?nv=1 Let me know if there's anything else you want answered! ------------------------- Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

In this one we'll take a look at how we can start using pandas to do simple tasks Spreadsheet to work alongside me --...

Read Full Article 🔍

Curious about Python Pandas Tutorial ( Basics ) - Start Replacing Excel For Python 2021 Series's Color? Explore detailed estimates, income sources, and financial insights that reveal the full picture of their profile.

Source ID: F-gDgQ6kuuk

Category: color style guide