Ordinary Least Squares in Pandas
tom
Below, I read a table and I apply the ordinary least squares methode to it: import pandas as pd from sqlalchemy.engine import create_engine from sqlalchemy.engine import URL import sqlalchemy as…
Alternative way to read data from SQL server
import pandas as pd from sqlalchemy.engine import create_engine from sqlalchemy.engine import URL from sqlalchemy.types import String, Date, DateTime from sqlalchemy import text import sqlalchemy as sa import pyodbc import oracledb…
Use Python to transport data
An alternative to a previous post is the programme below. This uses Pandas dataframe to transport data. import pandas as pd from sqlalchemy.engine import create_engine from sqlalchemy.engine import URL from…
Met Python van SQL Server naar Oracle
Plse find enclosed a script to write records from SQL Server to Oracle: import pyodbc import datetime conn = pyodbc.connect('DSN=SQLServer;UID=sa;PWD=**') conntarget = pyodbc.connect('DSN=Rekendoos;UID=hr;PWD=**') table_name = 'MIGRATED_DIVORCE_SETTLEMENT__C' cursor = conn.cursor() cursortarget…
Where is a record that creates an error
It might be that you see one record in a view that generates an error somewhere but you have not clue which record might generate that error. It could then…
Closing records
In a data warehouse environment, we may have to close records when we have new records that are added to the system. Let me first provide the sql. CASE mut.etl_valid_fromWHEN…
Partitions in Oracle
Oracle has the concept of partitions: the idea that a set of records is stored in one partition, that is directly accessible. This avoids the situation that large segments of…