python

Articles tagged with python.
Load Microsoft 365 SharePoint List Data in Python

local_offer Azure local_offer python

visibility 129
thumb_up 0
access_time 2 months ago

A Microsoft SharePoint list is a collection of data can be shared with team members or people who you give access to. It is commonly used to capture commonly maintained master data from manual inputs.  This article summarizes steps to create a SharePoint list and then load the data in the list ...

local_offer python local_offer python-file-operations

visibility 293
thumb_up 0
access_time 2 months ago

XML is a commonly used data exchange format in many applications and systems though JSON became more popular nowadays. Compared with JSON, XML supports schema (XSD) validation and can be easily transformed other formats using XSLT. XHTML is also a strict version of HTML that is XML based and used ...

Kafka Topic Partitions Walkthrough via Python

local_offer kafka local_offer python

visibility 173
thumb_up 0
access_time 2 months ago

Partition is the parallelism unit in a Kafka cluster. Partitions are replicated in Kafka cluster (cluster of brokers) for fault tolerant and throughput. This articles show you how to work with Kafka partitions using Python as programming language. Package kafka-python will be used in the ...

local_offer kafka local_offer python

visibility 100
thumb_up 0
access_time 2 months ago

Apache Kafka is written with Scala. Thus, the most natural way is to use Scala (or Java) to call Kafka APIs, for example, Consumer APIs and Producer APIs. For Python developers, there are open source packages available that function similar as official Java clients.  This article shows you ...

local_offer teradata local_offer python local_offer python-database

visibility 2125
thumb_up 1
access_time 7 months ago

Pandas is commonly used by Python users to perform data operations. In many scenarios, the results need to be saved to a storage like Teradata. This article shows you how to do that easily using JayDeBeApi or  sqlalchemy-teradata   package.  JayDeBeApi package and Teradata JDBC ...

local_offer python local_offer python-file-operations

visibility 1112
thumb_up 0
access_time 7 months ago

CSV is a common data format used in many applications. It's also a common task for data workers to read and parse CSV and then save it into another storage such as RDBMS (Teradata, SQL Server, MySQL). In my previous article  PySpark Read Multiple Lines Records from CSV I demonstrated how to ...

local_offer teradata local_offer python local_offer Java local_offer python-database

visibility 1171
thumb_up 0
access_time 7 months ago

Python JayDeBeApi module allows you to connect from Python to Teradata databases using Java JDBC drivers. In article Connect to Teradata database through Python , I showed how to use teradata package to connect to Teradata via Teradata ODBC driver. This article demos how to use this JayDeBeApi ...

local_offer sqlite local_offer python local_offer Java local_offer python-database

visibility 232
thumb_up 0
access_time 7 months ago

To read data from SQLite database in Python, you can use the built-in sqlite3 package . Another approach is to use SQLite JDBC driver via  JayDeBeApi  python package. Download the JAR file from one of the online repositories: Maven Repository BitBucket or any other equivalent ...

local_offer python local_offer sqlite local_offer python-database

visibility 107
thumb_up 0
access_time 7 months ago

SQLite is one of the most commonly used embedded file databases. All the mainstream programming language/framework provides APIs to interact with SQLite database. In my previous article  SQLite in .NET Core with Entity Framework Core , code snippet is provided to interact with SQLite via ...

local_offer Java local_offer python local_offer SQL Server

visibility 1861
thumb_up 0
access_time 7 months ago

In my previous article  Connect to SQL Server via JayDeBeApi in Python , I showed examples of using Python package jaydebeapi to connect to SQL Server via JDBC. The code was working properly. However after I reinstall Python 3.8.2 x64 version on Windows, I'm getting a new error ...

Read more

Find more tags on tag cloud.

launch Tag cloud