The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Change rows to columns		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Zisternas

11 Posts
Posted - 02/04/2010 :  10:57:14 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi everyone!


I have to import ASCII data which look like this:


----------------------------------------------
Sample File H:\Conc_measurements_09\dic09\D315_50nm_Qi1_Qa05.C25
Model 3025

Sample # 1 2 3
Start Date 12/21/09 12/21/09 12/21/09
Start Time 14:47:59 14:49:05 14:50:10
Sample Length 01:00 01:00 01:00
Averaging Interval (secs) 1 1 1
Title
Instrument ID 3025 1383 SEPT-02 3025 1383 SEPT-02 3025 1383 SEPT-02
Instrument Errors None None None

Mean 211.05 64.045 18.7683
Min 123 35.7 12.4
Max 322 111 32.4
Std. Dev. 54.6185 21.1955 5.72473

"Elapsed (s)" Concentration (#/cm³) "Elapsed (s)" Concentration (#/cm³) "Elapsed (s)" Concentration (#/cm³)
1 292 1 104 1 32.4
2 295 2 108 2 30.8
3 298 3 109 3 29
4 320 4 111 4 28.4
5 322 5 110 5 27.9
6 291 6 93 6 28.2
7 287 7 81 7 27.9
8 266 8 89 8 27.3
9 276 9 101 9 27.1
10 287 10 82 10 26.8
11 275 11 75 11 25.9


---------------------------------------------

I am only interested in the "Mean" and "standard Deviation" data. Importing only this values is not a big deal with the Import Wizard, but since I have to compare and operate with many of them I would like to have them in columns instead of rows, that is:


- This is how it looks like when I import only the desired data:

A(x) B(Y) C(Y) D(Y) F(Y) G(Y)
Mean 211.05 -- 64.045 -- -- 18.7683
Min 123 -- 35.7 -- -- 12.4
Max 322 -- 111 -- -- 32.4
Std. Dev. 54.6185 -- 21.1955 -- -- 5.72473

- I wish to arrange them in this way:

A(x) B(Y) C(Y) D(Y) F(Y) G(Y)

Mean Min Max Std. Dev.
211.05 123 322 54.6185
64.045 35.7 111 21.1955
18.7683 12.4 32.4 5.72473

(btw, removing the empty lines --, which I guess can be done with the Analysis -> Data manipulation tool, isn´t it?)



I am brand new in Origin (in fact I have started this afternoon) and may be a silly question, but it would facilitate my data analysis.

Thanks in advance!







Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8
Operating System: Windows XP

larry_lan

China
Posts
Posted - 02/04/2010 :  9:40:40 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi:

You can use import filter and add script after import to handle your issue. The script will first delete empty columns (supposed column 3 in this example); and then transpose the worksheet by wtranspose X-Function; finally, set the first row as column long name by wrow2label X-Function. The script after import can be something like:

del col(3);
wtranspose;
wrow2label l:=1;

Thanks
Larry
OriginLab Technical Services
Go to Top of Page

Zisternas

11 Posts
Posted - 02/06/2010 :  4:15:18 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you very much Larry, it works fine.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000