Questions tagged [row]

A horizontal line of cells in a spreadsheet, SQL table, HTML table, or similar structure.

A row most commonly refers to a horizontal line of cells in a spreadsheet or similar structure.

6641 questions
1
vote
2 answers

R: Deleting Row doesn't shift data up for certain .csv but does for .xls file

I was interested in looking at GDP of a few states over a span of 4 years. After I imported the .csv file, I renamed the column names and then removed irrelevant rows. The result is that the data skips the 10th row when numbered. So it goes from 1…
wasd777
  • 25
  • 2
1
vote
0 answers

Row Styling React Native

Hey I'm new to React Native and currently I'm trying render custom radio buttons from API and make it into a 2x2 grid. The buttons rendered successfully but they didn't render to 2x2 grid, I'm using the push method for making rows and columns and it…
1
vote
1 answer

Error in data.frame(..., check.names = FALSE) : arguments imply differing number of rows: 18, 218

I would like to compare pulse rate with whether people are left or right handed. The problem is that in my data only 18 people are left handed, where 218 are right handed. In trying to create a data frame, this is problematic, as both columns are…
Beth
  • 11
  • 1
1
vote
2 answers

TSQL Row Number split by reference and date

Using a single table with a reference and date column example below, how could I produce the out below to split the row number. The same reference on the same day should show as the same row number. example below; MAINFRAJOB SyncDate Row…
user3306489
  • 139
  • 1
  • 7
1
vote
1 answer

Calculate the remaining stock of goods from two tables sql

I Have 2 table 1.Table transaction in: +-----+ |id_in| +-----+ | 2 | | 2 | | 1 | | 3 | | 2 | | 3 | +-----+ 2.Table transaction out: +------+ |id_out| +------+ | 2 | | 2 | | 3 | | 1 | +------+ I want to do a query so that…
1
vote
0 answers

sort row of a matrix in R

I have this matrix of distances. I want to sort the values in the rows in ascending order so row 1 should look like 388.8342 396.9244 405.8091 423.8408 480.4186 487.3038 The 2nd row also should be sorted in ascending order I tried doing nearest <-…
neogeomat
  • 342
  • 2
  • 12
1
vote
2 answers

pandas - append new row with a different number of columns

I have a dataframe (df_original) that looks like this: Year | Thing1 | Thing2 2010 | 748 | 461 2011 | 246 | 493 2012 | 394 | 731 I need to occassionally append new data. Sometimes, I get data that will have the same number of…
adin
  • 696
  • 1
  • 11
  • 26
1
vote
2 answers

sum of row values if greater than zero

I want to sum all values for each row in a pandas dataframe if they are greater than zero my dataframe looks like this: col1 col2 col3 col4 5 4 -2 1 3 6 2 -3 2 -2 1 1 and I want to add a new column with the sum of…
Tobi
  • 113
  • 2
  • 9
1
vote
1 answer

C# DataTable Show Single Row in Console

I have searched high and low for a method to show the entire row of a C# datatable, both by referencing the row number and by simply writing the row contents to a string variable and showing the string in the console. I can specify the exact row and…
sethjbr
  • 85
  • 1
  • 10
1
vote
2 answers

Keeping rows with a minimum number of observations per group

With the following data, I would like to remove all the rows either containing less than or equal to only 1, 1s or 2s. The date set contains either 1 or 2. mydata X1 X2 X3 X4 X5 X6 X7 1 1 2 2 1 1 2 2 2 2 2 2 1 2 2 2 …
Uddin
  • 658
  • 2
  • 11
1
vote
0 answers

Append Row to Google Spreadsheet-->TypeError: keys must be a string

I am trying to append a row to a google spreadsheet but get an error. Usually it works but now it says: TypeError: keys must be a string Does anyone know what it means? Here is my code and a print of all the datatypes I try to insert. Is there a…
Mauritius
  • 205
  • 5
  • 17
1
vote
1 answer

R data.table fast sum of random samples by row

I have: require(data.table) dataDT <- data.table(ID = 1:4, Num_Times = c(7, 9, 10, 13)) dataDT # the main data ID Num_Times 1: 1 7 2: 2 9 3: 3 10 4: 4 13 probabilityDT <- data.table(val = 1:3,…
LeGeniusII
  • 798
  • 1
  • 7
  • 17
1
vote
1 answer

How to match rows when one row contain string from another row?

My aim is to find City that matches row from column general_text, but the match must be exact. I was trying to use searching IN but it doesn't give me expected results, so I've tried to use str.contain but the way I try to do it shows me an error.…
KWar
  • 13
  • 3
1
vote
1 answer

Vuetify: Table rows of checkboxes

I'm using vuetify and trying to use either a data-table, or simple table to display rows of checkboxes and a couple of text fields. Like this: However, when I use v-simple-table all of the checkboxes and fields have their own lines; breaking the…
Townsfolk
  • 1,212
  • 1
  • 9
  • 20
1
vote
1 answer

How can I add a new row and fill it to an exsiting excel file using Python

I need to create an excel file which contains the output of different functions, such as dates, the number of duplicated variables... I managed to create an excel file that contains the output of the first function but when I tried to append it with…
newbie
  • 536
  • 5
  • 20
1 2 3
99
100