Stack Overflow
Stack Overflow

Questions tagged [rows]

A row is a single data item in a database, spreadsheet, table, grid or list. When using this tag, please also add additional tags to clarify your specific environment/language/use case.

A row is a single data item. In the context of a database or similar data structure, it's also known as a or and will have a well-defined structure. In the context of a dataset in data science, each row represents an observation.

Rows can also be added to a less structured data source, such as a , , grid or .

4419 questions
1
vote
2 answers

How to organize rows of a data.frame in R

I want to build a 3x3 data.frame in R by using two vectors of values: a vector of x-values (xr) and a vector of y-values (yr). xr has 3 values and yr has 9 values. Here my example: xr<-c(1,2,3) yr<-c(4,4,4,5,5,5,6,6,6) …
Charles Santana
  • 130
  • 1
  • 1
  • 12
1
vote
1 answer

Insert new row and copy formula

I have this table in Excel: and I have the following formula in column N: Under the button named Adauga, I have a subroutine that adds new rows before row 5: Sub Button3_Click() Sheets("Sheet1").Range("A5").Select …
TBogdan
  • 737
  • 7
  • 17
  • 34
1
vote
0 answers

jQuery copy cloned rows from one table to another with added td columns

Using jQuery, I need to copy, rows, one at at time, by dragging from table1 to table2, leaving the row unchanged in table1. On dropping in table2, I need to add 2 new columns to the row dropped in table2. The rows need to be drag/dropped in table2…
MaxT
  • 11
  • 2
1
vote
1 answer

MySQL: Indexing Table With 10+ Million Rows

I have a table in my database with 10+M rows. Actually I never worked with so many records and it cames across me that I need a little help on indexing / partitioning the table. The table looks like this: CREATE TABLE `stock` ( `ID` bigint(20) NOT…
Alberto Ar3s
  • 311
  • 1
  • 3
  • 14
1
vote
3 answers

SQL rows to Column values

I have a scenario where for a purchase i can be paid with either cash,card or voucher are all the above three. But i need a report to show the all the payment types in seperate lines but i captured all these value in a single row. the problem is how…
Java Learner
  • 87
  • 1
  • 2
  • 8
1
vote
5 answers

How can I update multiple rows with one query (perl-mysql)?

I need to update multiple rows with one query. For the insert we usually do something like INSERT INTO `table` (c1,c2,c3) VALUES (1,2,3), (4,5,6), .. Yet how can we do something similar for the update where each row has different values than…
Luci
  • 3,174
  • 7
  • 31
  • 36
1
vote
1 answer

How to take rows from python pandas dataframe and make into columns of one new dataframe

I have three different dataframes of economic measures. The columns are years and the rows are countries. I want to take each country's rows and form a dataframe for each country such that the columns are the three economic measures and the rows are…
JSC
  • 181
  • 2
  • 12
1
vote
1 answer

in mysql how to set a column for every row in a table from a give set of values

I have this table: id name code --------------------------- 1 n1 2 n2 3 n3 and I have these values that need to be written to the code column of every row: ('8n8kKaVu','SRE2vbpQ','Vdfb7V7s') Also, it does not matter…
dave
  • 14,991
  • 26
  • 76
  • 110
1
vote
1 answer

Excel VBA to merge data from multiple rows

I have a quite big XLS with information spread over multiple rows that looks like: TopName Name Mode Item1 Item2 Item3 Item4 ----------------------------------------------------- Foo Name1 ModeX x() Foo Name2 ModeY …
Jan
  • 43
  • 5
1
vote
0 answers

JavaFX Grid Pane - Set a row's height to be the same as a column's width?

Here is the definition for my grid pane: …
5had3sofQu4rtz
  • 504
  • 5
  • 15
1
vote
1 answer

Python pandas: Compare rows of dataframe based on some columns and drop row with lowest value

I have a data frame df: first_seen last_seen uri 0 2015-05-11 23:08:46 2015-05-11 23:08:50 http://11i-ssaintandder.com/ 1 2015-05-11 23:08:46 2015-05-11 23:08:46 http://11i-ssaintandder.com/ 2 2015-05-02…
UserYmY
  • 8,034
  • 17
  • 57
  • 71
1
vote
1 answer

VBA to Hide and Unhide Rows using an activex check box

Can someone help me make this more efficient? It is running around 10 seconds. Thanks much! I've adapted this code to hide rows that contain "Hide" as the result of a formula in column A of my worksheet. Sub Hide_Rows() Application.Calculation…
Joy
  • 11
  • 3
1
vote
1 answer

Need to disable table rows if table header is display:none using Knockout JS

I am using Knockout JS. I have list of table columns in a dropdown list, on selecting a column from the list, changing the table column header style = Display:none. I need to make the rows also to be display none on paging/sorting. Once the column…
cmayil
  • 21
  • 3
1
vote
1 answer

Drag rows in jqGrid

I want to implement draggable rows feature in jqGrid and it's working also using option $('#MyGrid').jqGrid('gridDnD', { connectWith: '#MyGrid2'}); Now, my client want to show "Drag here" text in target grid row at the position where the row will…
shanky
  • 376
  • 1
  • 18
1
vote
0 answers

How to make separatorInset of Tableview for all Rows?

My app has a tableview with separatorInset setting for all rows like this: self.tableView.separatorInset.left = 0 self.tableView.separatorInset.right = 0 But when I ran my code, all of my rows have a separatorInset good except the first row like…
Hieu Duc Pham
  • 1,074
  • 1
  • 10
  • 24
1 2 3
…
99
100