SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


regression to classification binary


regression to classification binary

Author
Message
mick19790
mick19790
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 13
Can anyone assist me on how i go about arranging data that i used as continous input,to data that goes through pair combos for binary output.ie

out

3 5 9 19 11

4 6 7 12 23

3 3 4 6 7 2

to something similar

3 5 9 19 1

4 6 7 12 0 etc



Thanks
Sean Lange
Sean Lange
SSC Guru
SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)

Group: General Forum Members
Points: 112411 Visits: 18282
mick19790 (8/7/2012)
Can anyone assist me on how i go about arranging data that i used as continous input,to data that goes through pair combos for binary output.ie

out

3 5 9 19 11

4 6 7 12 23

3 3 4 6 7 2

to something similar

3 5 9 19 1

4 6 7 12 0 etc



Thanks



huh?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
mick19790
mick19790
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 13
I have alot of data that has continuous outputs.
I just wanted to know how i go about permutating ever pair for classifcation.
Literally 200 000 cases.Too much to do manually.
Sean Lange
Sean Lange
SSC Guru
SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)

Group: General Forum Members
Points: 112411 Visits: 18282
mick19790 (8/7/2012)
I have alot of data that has continuous outputs.
I just wanted to know how i go about permutating ever pair for classifcation.
Literally 200 000 cases.Too much to do manually.


You should take a look at the first link in my signature about best practices when posting questions. You have not provided anywhere near enough detail for anybody to offer much in the way of help. At this point I don't even really know what the question is.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
mick19790
mick19790
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 13
I do apologise for being very unclear.

Reflecting on my thread it looks lazy and disrespectful of forum protocol.

Ive been studying horse racing and other sport events with inputs ive put together.

I have many samples of input variables for individual horses,irrespective of horse field sizes.

Desired outputs being 1 for 1st, 2 for 2nd etc.Ive normalized the inputs and ran it through PCA.

Im not getting results i'd hoped for.Noisy data also cleansed to an extent.

So i would like to delve into individual race samples and have binary outputs for every paired combo of the horses to interprate the winning horses without having to manually do this.


Horse1 output 1st - 1

horse 2 output 4th - 0


etc

I thought having thousands of horses would have rectified the race field bias.and the lenghts beaten offset.
Sean Lange
Sean Lange
SSC Guru
SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)SSC Guru (112K reputation)

Group: General Forum Members
Points: 112411 Visits: 18282
No worries. It is hard to put your thoughts on "paper" in such a way that others can understand it. It seems that perhaps you read the article I suggested. However you missed that part about providing ddl (create table script), sample data (insert statements) and desired output based on the sample data.

Without that I have no idea what your structures look like or what the data is like. Can't do much to help without some details.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search