Truncate table in Teradata
local_offer teradata local_offer SQL
In SQL Server, we can use TRUNCATE statement to clear all the records in a table and it usually performs better compared with DELETE statements as no transaction log for each individual row deletion. The syntax looks like the following: TRUNCATE TABLE { database_name.schema_name.tab...
local_offer python local_offer SQL Server
Python JayDeBeApi module allows you to connect from Python to databases using Java JDBC drivers.
local_offer teradata local_offer SQL
OREPLACE functions in Teradata can be used to replace or remove characters from a string. OREPACE is Teradata's extension to ASNI SQL. The usual REPLACE function is not available. ANSI SQL REPLACE function REPLACE function is commonly implemented in many other SQL databases such as ...
local_offer plot local_offer pandas local_offer jupyter-notebook local_offer python
In this article I'm going to show you some examples about plotting scatter and hexbin chart with Pandas DataFrame. I'm using Jupyter Notebook as IDE/code execution environment. Hexbin chart &nbs...
Pandas DataFrame Plot - Bar Chart
local_offer plot local_offer pandas local_offer python local_offer jupyter-notebook
Recently, I've been doing some visualization/plot with Pandas DataFrame in Jupyter notebook. In this article I'm going to show you some examples about plotting bar chart (incl. stacked bar chart with series) with Pandas DataFrame. I'm using Jupyter Notebook as IDE/code execution environmen...
Pandas DataFrame Plot - Area Chart
local_offer plot local_offer jupyter-notebook local_offer python local_offer pandas
This article provides examples about plotting area chart using pandas.DataFrame.plot or pandas.core.groupby.DataFrameGroupBy.plot function. ...
Pandas DataFrame Plot - Line Chart
local_offer plot local_offer pandas local_offer jupyter-notebook local_offer python
This article provides examples about plotting line chart using pandas.DataFrame.plot function. Prerequisites The data I'm going to use is the same as the other article ...
Pandas DataFrame Plot - Pie Chart
local_offer plot local_offer pandas local_offer jupyter-notebook local_offer python
This article provides examples about plotting pie chart using pandas.DataFrame.plot function. Prerequisites The data I'm going to use is the same as the other article ...
Convert String to Date using Python
In my previous article about Convert string to date in Python / Spark , I showed how to use Spark udf to conver...
local_offer teradata local_offer SQL
Extract sub string from a string is a common operation in data analytics. In Teradata, function SUBSTRING (SUBSTR) and REGEXP_SUBSTR are provided to achieve that. SUBSTR is used to extract string from a specified location while REGEXP_SUBSTR is used to extract string using regular expressions. ...
