search for: column

...11 at yahoo.com> Sent: Friday, February 15, 2013 12:38 PM Subject: data formatting Dear Arun, [text file is also attached if format is changed] i need to data managing genius expertise on the following issue. i have data like the following table 1911.01.01?????? 7.87 ##(7 spaces between the columns) 1911.01.02?????? 9.26 ##(7 spaces between the columns) 1911.01.03?????? 8.06 ##(7 spaces between the columns) 1911.01.04?????? 8.13 ##(7 spaces between the columns) 1911.01.05????? 12.90 ##(6 spaces between the columns) 1911.02.06?????? 5.45 ##(7 spaces between the columns) 1911.02.07?????? 3.26...

i know that title sounds confusing, but here is the deal: the two columns that we are concerned with for this question are the "updated_on" column and the "views" column. the views column increases everytime a user visits a certain page. like this: @object.update_attributes(:views => @object.views + 1) the problem is that when a user visits th...

#Hello, #I have would like to paste a single column of a matrix # in pair wise fashion with other columns based upon # even and odd column numbers. # I can do it in a very clunky fashion and I know there # must be a better way. below is a sample matrix and my extremely # clunky code that gets the job done for a small matrix, but i plan to # do this...

Hi, I had another question. If you had say a vector (e.g., called data) with 235 elements and each element looked like the following data[[1]] Column A-B Column Z-S Column A-S.... 1 2 5 ....... data[[2]] Column Z-B Column A-S Column A-B.... 2 1 3 ....... Anyway, each element consists of one row that lists the names of the columns and the second r...

Dear All,   I have a matrix with 33 columns and 5000 rows. I would like to find 2 specific columns in the set: the one that holds the highest values and the one that holds the lowest values. In this case the column's mean would be apropriate to use to try to find those specific columns because each columns mean is different and they all...

...line: 46, type: !18, isLocal: false, isDefinition: true, scopeLine: 46, isOptimized: true, unit: !1, variables: !20) !17 = !DIFile(filename: "test.zig", directory: "/home/andy/dev/zig/build") !18 = !DISubroutineType(types: !19) !19 = !{!15} !20 = !{} !21 = !DILocation(line: 47, column: 16, scope: !22) !22 = distinct !DILexicalBlock(scope: !16, file: !17, line: 46, column: 29) !23 = !DILocation(line: 47, column: 36, scope: !22) !24 = !DILocation(line: 47, column: 27, scope: !22) !25 = !DILocation(line: 47, column: 5, scope: !22) !26 = distinct !DISubprogram(name: "__zig_pani...

Dear R-Helpers, I have a matrix where the first column is known. The second column is the result of multiplying this first column with a constant "const". The third column is the result of multiplying the second column with "const"..... So far, I did it like this (as a simplified example): nr.of.columns <- 4 myconstant <- 27...

...;' d:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.0/bin/rake:7 d:/ruby/bin/rake:18:in `load'' ----------------------------------------- My migration file is the following: class Realtorex < ActiveRecord::Migration def self.up create.table "pages", :force => true do |t| t.column "id", :integer t.column "name", :string t.column "title", :string t.column "body", :text t.column "body_html", :text t.column "user_id", :integer t.column "updated_at", :datetime t.column "created_...

Hello, I'm hoping that there is an easier way to rename columns in a data frame other than by using the names() assignment, which requires you to type in all the column names at once for a data.frame, in the case that I simply want to rename a single column in a data frame. Also, is there an easy way to move columns in a data frame around relative to the...

...; from old MySQL database and then use ''rake db_schema_import'' to rebuild the database in PostgreSQL. The issue here is that only some of tables can be imported successfully. For example, in the dumped schema.rb: create_table "profiles", :force => true do |t| t.column "ticker", :string, :limit => 10, :default => "", :null => false t.column "currency", :string, :limit => 10, :default => "USD", :null => false t.column "capitalization", :integer, :default => 0 t.column "performa...

When I try to use 1.6.1.1 with ODBC and MySQL, I get these: [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'name' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'ipaddr' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column...

Hi all, I'd appreciate if anyone can help me with this... I have a data frame that looks like this: 1 + name1 1 2 3 2 + name2 5 9 10 2 - name3 56 74 93 1 - name4 65 75 98 I need to rearrange this in a way so that the rows with "1" in the first column, and "-" in the second column; then columns 4 and 6 should switch places. That is, column 6 would be now column 4 and column 4 would be column 6 (column 5 should stay as column 5) In the same way, if the first column is "2" and the second is "+", then the same rearrang...

...= c(36, 38, 55, 11, 5, 18), x.1 = c(15, 21, 14, 21, 14, 38), z = c("D", "B", "A", "F", "H", "P")) > df   id  x  y    x.1 z 1  1 15 36  15 D 2  2 21 38  21 B 3  3 14 55  14 A 4  4 21 11  21 F 5  5 14  5  14 H 6  6 38 18  38 P Clearly columns x and x.1 are identical. In reality, I have a large data.frame and can't make out which columns are identical, but I am sure that column with name say x is repeated as x.1, x.2 etc. How to automatically identify and retain only one column (in this example column x) among the identical columns...

Hi, All, Suppose I have a CSV file, there is data in it. * Column 1 Column2 Column 3 Column 4 Row1 a b c Row2 a2 b2 c2* You know, the column 4 is no data Now, I would like to insert data to Column 4, after save, the CSV file will be: *...

Dear R users, sorry for a very basic question. i wanted to ask that if your column are too much in number and you want to select the remaining columns, starting from column number 117. one way is to use usual command >q[ ,(117:2300)]. is there a way by which i can select the remaining columns starting from column number 117 without using the usual command or without giving...

Hi all .., I have a large dataset of around 600,000 rows and 600 columns. The first col is codes for Meal A, the second columns is codes for Meal B. The third column is customers IDs where each customer had a combination of meals. Each column of the rest columns contains values 0,1,or 2. The dataset is organised in a way so that the first group of customers had similar...

...to rails and not sure where to check yet. Also... forgive me if this shows up twice. I tried posting first through the google groups interface and I''m not sure if it went through. I have rails 1.2.3 installed. I have a migration that looks like create_table :test_runs do |t| t.column :test_spec_id, :integer t.column :parent_id, :integer t.column :hostname, :string t.column :start_time, :datetime t.column :duration, :decimal t.column :result, :string t.column :xml_result, :text, :limit => 10.megabytes end after running "rake db:migrate"....

I am sure this is easy but I am not finding a function to do this. I have two columns in a matrix. The first column contains multiple entries of numbers from 1 to 100 (i.e. 10 ones, 8 twos etc.). The second column contains unique numbers. I want to sum the numbers in column two based on the indexed values in column one (e.g. sum of all values in column two associated with the value...

Dear useRs, I have a matrix with 38 columns and 365 rows. what i want to do is the following..... 1. subtracting from each column, first itself and then all the remaining columns. More precisely, from column number 1, i will first subtract itself(column 1) and then the remaining 37 columns. Afterwards i will take column number 2 and do the...

I''ve gone once through the Agile book and am now attempting my own rails app. I''ve created a table named ''volunteers'' with over 15 columns. The problem is the default list.rhtml that is created with the scaffold, shows all the columns. I only want to show 4 of them with the list view. Where would I start to only return a handfull of columns to the screen? I think I do it in the view (list.rhtml - excerpted below). Does anyone...