MLJAR logo
  • Solutions
    • Data Visualization
    • Data Analysis
    • Machine Learning
  • Docs
  • Pricing
  • Blog
  • Contact
Download
  • MLJAR Studio

    • Quick start
    • Install
    • Uninstall
    • New notebook
    • Install new packages
  • AI Assistant

    • Data Analyst
    • Teacher
    • Code Assistant
  • Code Recipes

  • Python

    • Display Python version
    • Install Package
    • Get current time
    • Get working directory
    • Get environment variable
    • Add .env variable
    • Load secrets from .env
    • Random integer
    • Time delay
    • Check if file exists
    • List files
    • Read file
    • Write to file
    • Append to file
    • Delete file
    • Copy file
    • Delete directory
    • Read JSON from file
    • Write JSON to file
    • Pretty print JSON
  • Markdown

    • Read data

      • Sample datasets
      • Read CSV
      • Read Excel
      • Read XML
      • Load Pickle
      • Read HTML
      • Read Parquet
      • Read SPSS
      • Read Stata
      • Read SAS
      • Read Kaggle
    • Write data

      • Write CSV
      • Write Parquet
      • Save to Pickle
    • Postgresql

      • Define a new connection
      • Connect to database
      • Show all tables
      • Show all columns
      • Raw query to Pandas
      • Raw query
      • Run select query
      • Run insert query
      • Update column
      • Update selected
      • Backup table
      • Create table
      • Drop table
    • Data wrangling

      • DataFrame info
      • DataFrame describe
      • Display DataFrame
      • Select X,y
      • Select Columns
      • Filter rows
      • Delete Column
      • Split to train/test
      • Check missing values
      • Drop rows with missing values
      • Fill missing values
      • Use imputer on new data
      • Categorical to integer
      • Use encoder on new data
    • Explore data

      • Pygwalker
      • Skrub
      • Profiling
    • Scikit-learn

      • Decision Tree
      • Random Forest
      • k-Nearest Neighbors
      • Train Model
      • Compute Predictions
      • Visualize Decision Tree
      • Hyper Parameters Search
      • Feature Importance
      • Compute Metric
      • Confusion Matrix
      • ROC Curve
      • Precision-Recall
      • Lift Chart
      • Calibration Plot
      • k-Means
    • LightGBM

      • LightGBM Regressor
      • LightGBM Classifier
      • Train LightGBM
      • LightGBM Predict
      • Save LightGBM
      • Load LightGBM
      • LightGBM Importance
    • MLJAR AutoML

      • Train AutoML
      • Predict with AutoML
      • AutoML report
      • Load AutoML
    • Images Operations

      • Remove background from single image
      • Remove background from multiple images
      • Show image
    • OpenAI

      • Client connection
      • Chat completions
      • Cosine similarity search
      • Embeddings
      • Files embeddings
      • AI image generator
      • Speech transcriptions
      • Speech translations
      • Text to speech
      • Vision with local images
      • Vision with URL images
    • Ollama

      • Chat completions
      • Embeddings
      • Generate text
    • PDF Operations

      • Display PDF
      • Load PDF
      • Load many PDFs
      • Search text in many PDFs
    • Google Sheets

      • Connection
      • Open spreadsheet
      • Create spreadsheet
      • Delete spreadsheet
      • Share spreadsheet
      • Open worksheet
      • Create worksheet
      • Delete worksheet
      • Read data
      • Find cell by value
      • Append rows
      • Update cell
      • Update range
    • http-requests

    Cookbooks

    Code recipes

    Code recipes were created to make your Python coding a joy. Recipes are grouped in cookbooks based on subject. They are listed below.

    • Python code snippets

    • Markdown cheatsheet

    • Read data in Python

    • Write data in Python

    • Data wrangling in Python

    • Explore data

    • Scikit-learn recipes

    • LightGBM

    • AutoML in Python

    • Postgresql recipes

    • Python images operations using AI

    • Python code recipes for OpenAI

    • Python code recipes for Ollama

    • Python code recipes for PDF operations

    • Python code recipes for operations in Google Sheets

    • Http requests

    « Previous
    AI Assistant
    Next »
    Python
    MLJAR Studio
    Become a Data Scientist, today!
    • Terms of Service
    • Privacy Policy
    • Licenses

    Resources

    • Example Python notebooks
    • Fix ModuleNotFoundError
    • Glossary
    • Brand
    • Answers
    • ML Algorithm Comparison

    Products

    • MLJAR Studio
    • AutoML
    • Mercury
    • SuperTree

    Solutions

    • AI Solutions
    • Data Visualization
    • Data Analysis
    • Machine Learning

    Open Source

    • MLJAR Studio
    • MLJAR AutoML
    • Mercury
    • More ...

    Company

    • Contact us
    • Services
    • About us
    • Blog
    Made by MLJAR. All rights reserved.
    Created in 🇵🇱 We ❤ you!