Comma-separated Value (CSV) data file

Data files prepared by BASIC programs or Spreadsheets frequently have their data values separated by commas. Each field, and each record, can be of a different length.

 

This is such a data file, CSVDAT.txt:

 

"Mike",1,2,3,4,5,6,7,8,9,1,2,3,4,5,6,9,8,7,6,5,4

"George",3,6,4,2,3,5,2,3,4

"Anne",7,4,3,2,8,5,4,1,,3,4,5

 

The test is of 21 items. Each examinee started at item 1, but stopped when time ran out.

 

The Facform keyword file, CSVkey.txt, to reformat this CSV file is:

 

; File: CSVkey.txt

; This converts a comma-separated value file

$Input = CSVDAT.txt

$Output = CSVFDT.txt

 

; if the separators are not commas, enter the separator code

; $SEP=";"  ; separators are semi-colons

; for Tab separators, use $T

 

$Facets = 2 ; children and item

 

; labels for the Facets

$Flabel = 1, "Examinees"

$Flabel = 2, "Binomial Trial Items"

 

; and let's also output the other specifications that FACETS needs:

$Spec = "Title = Nine Binomial Trials"

$Spec = "Output = csvOUT.txt ;the FACETS output file"

$Spec = "Models = ?,?,B9,1"

 

; the person label

$Label = 1,,$C1 ; first comma separated value

 

; reset item numbering

Item = 1   ; point to first item

Datum = $C(Item+1) ; first rating in 2nd CSV field

; now go across the line until the data runs out

$Do = (Datum<>"") ; perform $Do= while ratings exist

; the ordinal number of this item

$Label = 2,Item

$Rating = Datum

Item = Item + 1  ; increment to next item

Datum = $C(Item+1) ; observation into variable called "Datum"

$Again

 

The resulting Facets specification file, CSVFDT.txt, is:

 

; FACFORM Version No. 1.20,  May 4, 1992

; Run on 05-04-1992 19:37:33

; from Keyword file: CSVkey.txt

Facets = 2

Title = Nine Binomial Trials

Output = csvOUT.txt    ;the FACETS output file

Models = ?,?,B9,1

Labels =

1,Examinees

1=Anne

2=George

3=Mike

*

2,Binomial Trial Items

1=

2=

|

20=

21=

*

Data =

3,1-21,1,2,3,4,5,6,7,8,9,1,2,3,4,5,6,9,8,7,6,5,4

2,1-9,3,6,4,2,3,5,2,3,4

1,1-8,7,4,3,2,8,5,4,1


Help for Facform Rasch Measurement Software: www.winsteps.com. Author: John Michael Linacre

For more information, contact info@winsteps.com or use the Contact Form
 

Facets Rasch measurement software. Buy for $149. & site licenses. Freeware student/evaluation download
Winsteps Rasch measurement software. Buy for $149. & site licenses. Freeware student/evaluation download

State-of-the-art : single-user and site licenses : free student/evaluation versions : download immediately : instructional PDFs : user forum : assistance by email : bugs fixed fast : free update eligibility : backwards compatible : money back if not satisfied
 
Rasch, Winsteps, Facets online Tutorials

 

Forum Rasch Measurement Forum to discuss any Rasch-related topic

Click here to add your email address to the Winsteps and Facets email list for notifications.

Click here to ask a question or make a suggestion about Winsteps and Facets software.

Rasch Publications
Rasch Measurement Transactions (free, online) Rasch Measurement research papers (free, online) Probabilistic Models for Some Intelligence and Attainment Tests, Georg Rasch Applying the Rasch Model 3rd. Ed., Bond & Fox Best Test Design, Wright & Stone
Rating Scale Analysis, Wright & Masters Introduction to Rasch Measurement, E. Smith & R. Smith Introduction to Many-Facet Rasch Measurement, Thomas Eckes Invariant Measurement with Raters and Rating Scales: Rasch Models for Rater-Mediated Assessments, George Engelhard, Jr. & Stefanie Wind Statistical Analyses for Language Testers, Rita Green
Rasch Models: Foundations, Recent Developments, and Applications, Fischer & Molenaar Journal of Applied Measurement Rasch models for measurement, David Andrich Constructing Measures, Mark Wilson Rasch Analysis in the Human Sciences, Boone, Stave, Yale
in Spanish: Análisis de Rasch para todos, Agustín Tristán Mediciones, Posicionamientos y Diagnósticos Competitivos, Juan Ramón Oreja Rodríguez
Winsteps Tutorials Facets Tutorials Rasch Discussion Groups

 

Coming Rasch-related Events
Jan. 5 - Feb. 2, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Core Topics (E. Smith, Winsteps), www.statistics.com
Jan. 10-16, 2018, Wed.-Tues. In-person workshop: Advanced Course in Rasch Measurement Theory and the application of RUMM2030, Perth, Australia (D. Andrich), Announcement
Jan. 17-19, 2018, Wed.-Fri. Rasch Conference: Seventh International Conference on Probabilistic Models for Measurement, Matilda Bay Club, Perth, Australia, Website
Jan. 22-24, 2018, Mon-Wed. In-person workshop: Rasch Measurement for Everybody en español (A. Tristan, Winsteps), San Luis Potosi, Mexico. www.ieia.com.mx
April 10-12, 2018, Tues.-Thurs. Rasch Conference: IOMW, New York, NY, www.iomw.org
April 13-17, 2018, Fri.-Tues. AERA, New York, NY, www.aera.net
May 22 - 24, 2018, Tues.-Thur. EALTA 2018 pre-conference workshop (Introduction to Rasch measurement using WINSTEPS and FACETS, Thomas Eckes & Frank Weiss-Motz), https://ealta2018.testdaf.de
May 25 - June 22, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Core Topics (E. Smith, Winsteps), www.statistics.com
June 27 - 29, 2018, Wed.-Fri. Measurement at the Crossroads: History, philosophy and sociology of measurement, Paris, France., https://measurement2018.sciencesconf.org
June 29 - July 27, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Further Topics (E. Smith, Winsteps), www.statistics.com
July 25 - July 27, 2018, Wed.-Fri. Pacific-Rim Objective Measurement Symposium (PROMS), (Preconference workshops July 23-24, 2018) Fudan University, Shanghai, China "Applying Rasch Measurement in Language Assessment and across the Human Sciences" www.promsociety.org
Aug. 10 - Sept. 7, 2018, Fri.-Fri. On-line workshop: Many-Facet Rasch Measurement (E. Smith, Facets), www.statistics.com
Sept. 3 - 6, 2018, Mon.-Thurs. IMEKO World Congress, Belfast, Northern Ireland www.imeko2018.org
Oct. 12 - Nov. 9, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Core Topics (E. Smith, Winsteps), www.statistics.com

 
Concerned about aches, pains, youthfulness? Mike and Jenny suggest Liquid Biocell