Semua buku

Profesional

Aplikasi Tentang Pelatih Masuk Mulai membaca

Quantitative Finance · Glosarium

Apa itu Long format, wide format?

Dikenal juga sebagai: long format · wide format

Definition 10.2 Research, Data and Risk Platforms · Bab 10 — Dataframes

A table in long format has one row per observation and a column for each variable, including the keys (symbol, time, value). The same data in wide format have one row per value of one key and one column per value of another (a row per minute, a column per symbol).

The same closing prices in long format (keys as columns) and in wide format (one key as rows, the other as columns). Research code moves between the two: long for storage, joins and grouping; wide for cross-sectional arithmetic and matrices.
Figure 10.1. The same closing prices in long format (keys as columns) and in wide format (one key as rows, the other as columns). Research code moves between the two: long for storage, joins and grouping; wide for cross-sectional arithmetic and matrices.
Baca dalam konteks →