Skip to content
Data to Fish

Data to Fish

  • Home
  • Python
  • R
  • Julia
  • Batch
  • About

Batch Scripts Tutorials

Create a Batch File to Run Python Script
Run Batch File from Python
Generate Backup Files with Timestamps
Execute a Command Prompt Command from Python
Create a Batch File Directly from Python

Database Tutorials

SQL Developer

Use Spool to Export Query Results to CSV
Export Query Results to CSV in SQL Developer
Export Query Output to Excel in SQL Developer

SQL

Create or Drop a Database
Create a Table in SQL Server
Case Statement
LEFT, RIGHT and SUBSTRING in SQL Server
Get the Data Type of Columns in SQL Server
Insert Records Into a Table
Delete Records from a Table
Update Table Records
LEFT JOIN
Max Value
Create a Temporary Table in SQL Server
Join Tables from Different Databases in SQL Server
UNION and UNION ALL
Add a Column to Existing Table using ALTER TABLE
Export SQL query results

Other

String Functions
COUNTIF Function
VBA to Run a Query

Python Tutorials
Upgrade PIP

Install Package

Remove Package

Create Executable

Add to Path

Schedule Script

Copy File

Read Excel

Read CSV

Create DataFrame

Sort DataFrame

DataFrame to List

List to DataFrame

Plot DataFrame

Plot Histogram

Correlation Matrix

Line Chart

Bar Chart

R Tutorials
Install Package

Create DataFrame

Export DataFrame

Import CSV

DATA TO FISH
Privacy Policy
Cookie Policy
Terms of Service
Copyright © | All rights reserved