SQL with PYTHON | Manage SQL databases using PYTHON ONLY

Поделиться
HTML-код
  • Опубликовано: 14 окт 2024

Комментарии • 41

  • @oscar-8986
    @oscar-8986 Год назад +5

    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  Год назад +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 Год назад +3

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

    • @mo-chen
      @mo-chen  Год назад

      Thanks so much for watching BillyT83!

  • @hiovanycubillosgomez5901
    @hiovanycubillosgomez5901 Год назад +1

    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  Год назад

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

  • @ramprasadsomaraju3889
    @ramprasadsomaraju3889 Год назад +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  Год назад

      I'm glad you liked the content Ram 😁

  • @grapefruitomega3517
    @grapefruitomega3517 Год назад +2

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

    • @mo-chen
      @mo-chen  Год назад

      Thank you so much 😄

  • @thitiboat
    @thitiboat Год назад +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  Год назад +1

      Hi Dancing Pepper! I actually made a video on this ruclips.net/video/d_2fGS6QVDo/видео.html&ab_channel=DataWithMo. Hope this helps 😄

    • @thitiboat
      @thitiboat Год назад +1

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

  • @YashAndTioShow
    @YashAndTioShow Год назад +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  Год назад +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 Год назад +1

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

  • @Andy_TKC
    @Andy_TKC Год назад +1

    You are amazing, Mo Chen 👍🏻

    • @mo-chen
      @mo-chen  Год назад

      I'm very glad you liked the video Andy 😄

  • @victorfonseca7258
    @victorfonseca7258 Год назад +1

    Great content as always!! Thanks😄

    • @mo-chen
      @mo-chen  Год назад

      Thanks a lot Victor 😄

  • @mohammedhosayn8972
    @mohammedhosayn8972 8 месяцев назад

    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.

  • @nyakehkallon6597
    @nyakehkallon6597 Год назад +1

    new video yaaaah 🥰

    • @mo-chen
      @mo-chen  Год назад +1

      Thanks nyakeh!

  • @ethanblackthorn3533
    @ethanblackthorn3533 8 месяцев назад

    Thank you for the video!

  • @prashlovessamosa
    @prashlovessamosa Год назад +1

    Thanks mo

    • @mo-chen
      @mo-chen  Год назад

      I'm glad you liked it 😃

  • @jamesbelk7285
    @jamesbelk7285 Год назад

    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 Год назад

    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  Год назад

      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 Год назад

      @@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  Год назад

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

    • @atharvakgb
      @atharvakgb Год назад

      @@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

  • @Tradingwithbutimnotrader
    @Tradingwithbutimnotrader Год назад

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

    • @mo-chen
      @mo-chen  Год назад +6

      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 😃

  • @katarinaoldakowski2141
    @katarinaoldakowski2141 Год назад

    OMG I need something like this with MySQL ;(

    • @mo-chen
      @mo-chen  Год назад

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

  • @SumayaSultana-v8f
    @SumayaSultana-v8f Год назад

    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  Год назад

      Try this "!pip install psycopg2-binary" 😁

  • @ehrylgo1453
    @ehrylgo1453 Год назад +1

    Clicked for a different reason