Tutorial by Topics: data

This example shows how to create a ViewModel and a View within the MVVM pattern and WPF, and how to bind the two together, so that each is updated whenever the other is changed.

How to fill your created Excel sheet with data from different sources.

The article describes the different environments in which data can reside and the characteristics of both the data and the environment at each stage of the data life cycle.

Database Transaction Units (DTU) are the unit in which the performance of Azure SQL DB is measured. DTUs make the most sense when used for comparing workloads. For example, a workload that uses 5 DTUs will consume 10 DTUs when doubled. Officialy, Microsoft has introduced the DTU as the average numb...

How to import data from an existing Excel or CSV file.

A DataFrame is an abstraction of data organized in rows and typed columns. It is similar to the data found in relational SQL-based databases. Although it has been transformed into just a type alias for Dataset[Row] in Spark 2.0, it is still widely used and useful for complex processing pipelines mak...

How to append data to an already existing Excel document.

When working with an web application it's sometimes important to access data included in the request, beyond the URL. In Flask this is stored under the global request object, which you can access in your code via from flask import request.

[TODO: This topic should be an example of all the basic CS 101 data structures along with some explanation as an overview of how data structures can be implemented in VBA. This would be a good opportunity to tie in and reinforce concepts introduced in Class-related topics in VBA documentation.] ...

From Adminer management tool it's has export to csv file option for mysql database But not available for postgresql database. Here I will show the command to export CSV for postgresql database.

This section provides an overview of what data-warehouse is, and why a developer might want to use it. It should also mention any large subjects within data-warehouse, and link out to the related topics. Since the Documentation for data-warehouse is new, you may need to create initial versions ...

You can use hierarchical queries to retrieve data based on a natural hierarchical relationship between rows in a table

Example of how to copy existing table structure with/without data CREATE TABLE schemaName.table AS (SELECT columns FROM schemaName.table) WITH DATA

The fit command can fit a user-defined function to a set of data points (x,y) or (x,y,z), using an implementation of the nonlinear least-squares (NLLS) Marquardt-Levenberg algorithm. Any user-defined variable occurring in the function body may serve as a fit parameter, but the return type of the fu...

This section shows basic code for reading, sub-setting and writing external data files using pandas.

In order to utilize a JDBC datasource, we must first set up a JNDI reference in Tomcat. After the JNDI reference is made, JDBC datasources can be used within our Tomcat server and applications using shared or independent references (Great for dev/staging/prod setup, or removing connection strings/cr...

Firebase database is a NoSQL database that stores its data in the form of hierarchal JSON objects. There are no tables or records of any form as an SQL database would normally have, just nodes that make up a key-value structure. Data Normalization In order to have a properly designed database stru...