ML in Quant Life
  • About Me
  • Search
Navigation bar avatar
✕

    Machine Learning Quantitative Developer


    This is where I post random stuff about ML and Coding
    • Efficient Data Extraction from SQL Server into Pandas DataFrame with SQLAlchemy

      Posted on May 14, 2023

      In this post, we will explore how to efficiently extract data from an MS SQL Server database into a pandas DataFrame using SQLAlchemy. [Read More]
      Tags:
      • Python
      • SQL
      • SQLAlchemy
      • Pandas
      • Data Extraction
    • Effective Strategies for Prompting ChatGPT to Write Code

      Tips, Templates, and Examples

      Posted on May 5, 2023

      When prompting ChatGPT to write code, it’s essential to provide a clear and concise description of what you need. Here are a few tips and templates to help you get the desired results: [Read More]
      Tags:
      • ChatGPT
    • How to use SQL files in Python code

      Posted on May 3, 2023

      To store SQL statement strings in separate files, you can create a new folder called sql_queries and store each SQL statement in a separate .sql file. You can use placeholders for formatted variables in these SQL files. [Read More]
      Tags:
      • python
      • sql
    • ← Newer Posts
    • Email me
    • GitHub

    ML Quant  •  2023  •  MLQuantDev.github.io  •  Edit page

    Powered by Beautiful Jekyll