Displaying 3 results from an estimated 3 matches for "series_id".
2005 Sep 14
16
Showing database results in a grid view
...y to do what I want. Any advice on the best method would
be greatly appreciated.
Have the following database table:
CREATE TABLE datasets (
id int not null auto increment,
name varchar not null,
value varchar not null,
year varchar not null,
state varchar not null,
series_id int not null,
primary key (id)
);
In my view, I want to display the data from the datasets table as a grid
grouped by series_id. Each state should be on the x-axis (rows along
the left side) and each year should be on the y-axis (columns along the
top).
Any ideas?
Thanks.
2010 Mar 02
1
Reading data file with both fixed and tab-delimited fields
...lows.)
_*Details:*_
The U.S. Bureau of Labor Statistics provides local area unemployment
statistics at ftp://ftp.bls.gov/pub/time.series/la/, and the data are
documented in the file la.txt
<ftp://ftp.bls.gov/pub/time.series/la/la.txt>. Each data file has five
tab-delimited fields:
* series_id
* year
* period (codes for things like quarter or month of year)
* value
* footnote_codes
The series_id consists of five fixed-width subfields (length in
parentheses):
* survey abbreviation (2)
* seasonal code (1)
* area type code (2)
* area code (6)
* measure...
2024 Oct 04
1
Warning message: Removed 888 rows containing missing values or values outside the scale range (`geom_line()`)
..., -9315, -9284, -9253, -9223, -9192,
-9162, -9131, -9100, -9072, -9041, -9011, -8980, -8950, -8919,
-8888, -8858, -8827, -8797, -8766, -8735, -8707, -8676, -8646,
-8615, -8585, -8554, -8523, -8493, -8462, -8432, -8401, -8370,
-8342, -8311), class = c("yearmonth", "vctrs_vctr")), Series_ID =
c("CEU0500000001",
"CEU0500000001", "CEU0500000001", "CEU0500000001", "CEU0500000001",
"CEU0500000001", "CEU0500000001", "CEU0500000001", "CEU0500000001",
"CEU0500000001", "CEU0500000001"...