SQL with PYTHON | Manage SQL databases using PYTHON ONLY

Sdílet
Vložit
  • čas přidán 20. 08. 2024

Komentáře • 41

  • @oscar-8986
    @oscar-8986 Před rokem +4

    I just found out your content, i do like it.
    Its straight to the point and honest.
    Couple days ago i started the google analyst course on coursera, currently trying to study 2 hours each day besides my job what I have now (25 years old).
    I would love to see a video with like websites or links where you can keep up with the actual stuff that is going on in the analyse world.
    I will follow your yourny and im curious what will come :).
    Greatings from The Netherlands ;)

    • @mo-chen
      @mo-chen  Před rokem +1

      Hey Oscar, welcome to the channel! I can't guarantee that I'll make a video like that in the near future, but I for sure will try. I've been to Amsterdam and I must say I really like the friendliness of the Dutch people! Thank you so much for watching 😄

  • @BillyT83
    @BillyT83 Před rokem +3

    Clear and detailed explanations! Thanks for sharing Mo! Hope to see more in the future!

    • @mo-chen
      @mo-chen  Před rokem

      Thanks so much for watching BillyT83!

  • @ramprasadsomaraju3889
    @ramprasadsomaraju3889 Před rokem +1

    the happiest part is when u showed the other way to implement 😃😃😃happy for the content pls make on data cleaning more detailed

    • @mo-chen
      @mo-chen  Před rokem

      I'm glad you liked the content Ram 😁

  • @hiovanycubillosgomez5901

    Thank you man, I could understand and start to learn about this, the video is complete example and step-by-step to get knowledge and build small projects, awesome that you took the time to do it and then explain and lastly share it with us. I am from Bogota Colombia south America, I appreciate it, have a good one there.

    • @mo-chen
      @mo-chen  Před rokem

      Thanks so much for the kind words, I'm very glad you found the content useful 😁 All the best to you too!

  • @grapefruitomega3517
    @grapefruitomega3517 Před rokem +2

    This is beyond helpful, you are one of a kind 🙇‍♂️🙇‍♂️

    • @mo-chen
      @mo-chen  Před rokem

      Thank you so much 😄

  • @YashAndTioShow
    @YashAndTioShow Před rokem +2

    Amazing video Mo, please could you make a video on Settings up Postgres and linking to VS Code/however you set it up for workflow 🧑‍💻

    • @mo-chen
      @mo-chen  Před rokem +1

      Hi TioTheCeo, not sure when I'll get to make a video on that. For connectivity in VSC or Jupyter, you just need the SQL database information (hostname, password, username, database name, etc). Thanks so much for watching!

    • @YashAndTioShow
      @YashAndTioShow Před rokem +1

      @@mo-chen thanks Mo can't wait for the next upload 😁

  • @Andy_TKC
    @Andy_TKC Před rokem +1

    You are amazing, Mo Chen 👍🏻

    • @mo-chen
      @mo-chen  Před rokem

      I'm very glad you liked the video Andy 😄

  • @victorfonseca7258
    @victorfonseca7258 Před rokem +1

    Great content as always!! Thanks😄

    • @mo-chen
      @mo-chen  Před rokem

      Thanks a lot Victor 😄

  • @thitiboat
    @thitiboat Před rokem +2

    This is inspiring me to learn more about data sci. Thank you for sharing. I'm a complete beginner but wants to learn data engineering to break into tech. I'm feeling lost and don't know where to start.
    What kind of education / courses do you recommend? Thank you in advance for taking the time to answer.

    • @mo-chen
      @mo-chen  Před rokem +1

      Hi Dancing Pepper! I actually made a video on this czcams.com/video/d_2fGS6QVDo/video.html&ab_channel=DataWithMo. Hope this helps 😄

    • @thitiboat
      @thitiboat Před rokem +1

      @@mo-chen you just earned a new subscriber 💋

  • @ethanblackthorn3533
    @ethanblackthorn3533 Před 6 měsíci

    Thank you for the video!

  • @nyakehkallon6597
    @nyakehkallon6597 Před rokem +1

    new video yaaaah 🥰

  • @mohammedhosayn8972
    @mohammedhosayn8972 Před 6 měsíci

    Hi Mo Chen, Thanks a lot for making such an amazing very useful video. Sir, I just want to know how you create config file, because I don't understand that part. Please help me Sir that how can I create a config file in jupyter. Thanks again.

  • @prashlovessamosa
    @prashlovessamosa Před rokem +1

    Thanks mo

    • @mo-chen
      @mo-chen  Před rokem

      I'm glad you liked it 😃

  • @jamesbelk7285
    @jamesbelk7285 Před 10 měsíci

    Hello! I am getting an error when trying to iterate through the dataframe 'Perhaps you need a different "datestyle' setting. Would you happen to have any guidance on how to solve this?

  • @atharvakgb
    @atharvakgb Před rokem

    Hi i have video request for you can you make a video on remote job scenario for data analyst job role in uk companies and startups for the non uk resident

    • @mo-chen
      @mo-chen  Před rokem

      Hi Amaan, I’m not sure when I’ll get to make a video like this but if you’re looking for visa information, probably best to check the UK 🇬🇧 government website for this. As fas as I know, only very little companies sponsor for visas. Thank you so much for watching 😃

    • @atharvakgb
      @atharvakgb Před rokem

      @@mo-chen I want to know about remote jobs that one can do without travelling i have many SDE work for American startups and companies without travelling to usa wanted to know if similar kind of opportunities available in UK 🇬🇧 as well

    • @mo-chen
      @mo-chen  Před rokem

      @@atharvakgb I see. Unfortunately this is something I have no experience with 😅 Sorry I couldn’t help!

    • @atharvakgb
      @atharvakgb Před rokem

      @@mo-chen sure i completely understand but lets us know if there is anyone within your online/offline circle that might into this and can give a decent idea regarding the same

  • @katarinaoldakowski2141
    @katarinaoldakowski2141 Před 11 měsíci

    OMG I need something like this with MySQL ;(

    • @mo-chen
      @mo-chen  Před 11 měsíci

      Just Google "mysql connector python". There are many ways you can do this with mysql databases too 😁

  • @user-tv1po3uj1j
    @user-tv1po3uj1j Před 11 měsíci

    import psycopg2
    import configparser
    import pandas as pd
    #magic function that will allow us to connect the postgresql database
    %load_ext sql
    -------
    ModuleNotFoundError Traceback (most recent call last)
    in
    ----> 1 import psycopg2
    2 import configparser
    3 import pandas as pd
    4 #magic function that will allow us to connect the postgresql database
    5 get_ipython().run_line_magic('load_ext', 'sql')
    ModuleNotFoundError: No module named 'psycopg2'
    How do I resolve this?

    • @mo-chen
      @mo-chen  Před 11 měsíci

      Try this "!pip install psycopg2-binary" 😁

  • @ehrylgo1453
    @ehrylgo1453 Před rokem +1

    Clicked for a different reason

  • @Tradingwithbutimnotrader

    Bro you’re not a data analyst, this is engineering work
    I.E am a data engineer

    • @mo-chen
      @mo-chen  Před rokem +4

      Thing nowadays is that depending on the company and the specific data analyst role you go into, your job responsibilities can vary widely. You can easily be doing lots of data science / data engineering stuff! Thanks so much for watching 😃