如何在 Dataframe 中添加一行并使用一个字符串填充它？

m1m5dgzv 于 2023-01-22 发布在其他

关注(0)|答案(1)|浏览(344)

我想在df中添加一行，并用normal字符串填充该行。

df[nrow(df) + 1,] <- "normal"

追溯：

Error in `[<-`(`*tmp*`, nrow(df) + 1, , value = "normal") : 
  subscript out of bounds

数据：

> dput(df)
structure(c(0.817235177513274, 0.842271224674921, 0.787053698556768, 
0.723253823258161, 0.330810989820991, 0.929282245774236, 0.385900089441395, 
0.580292714010189, 0.928938997366233, 0.78643829926366, 0.739342773828268, 
0.815944692823519, 0.701024754855706, 0.690557534921593, 0.292246602221495, 
0.907803873079535, 0.453213181805882, 0.550745234719392, 0.913370916956376, 
0.716310393262212, 0.765542822762287, 0.568705595673652, 0.6714274267581, 
0.531716650540856, 0.331580044004539, 0.840889607944185, 0.494640734908958, 
0.396783055306106, 0.8692727119489, 0.759022283299301, 0.787291380662438, 
0.855192302325311, 0.743632726648944, 0.710242442123609, 0.351783150991687, 
0.933702108520557, 0.410525438050587, 0.549479034093077, 0.920910305577791, 
0.812458352284617, 0.762864102512286, 0.82250047660344, 0.681146614449272, 
0.722562365641304, 0.295007368926608, 0.923671059571924, 0.379539671884597, 
0.515060486276735, 0.91767133328213, 0.79917575064228, 0.743564108418945, 
0.541783705139426, 0.675695188150901, 0.530335228219673, 0.311148090618456, 
0.888403586041492, 0.489850949026585, 0.495137719924742, 0.928270455994818, 
0.781619937522964, 0.83114689516785, 0.745890503970576, 0.819047883913701, 
0.693061612485807, 0.34437655946559, 0.925122536085658, 0.438053894428271, 
0.539601859327891, 0.930313177385918, 0.77987407757735, 0.797258263299495, 
0.539125161286865, 0.73772463742416, 0.596959758946811, 0.340833820254246, 
0.867012396000705, 0.414398893790568, 0.478458869251912, 0.9148617831338, 
0.794732448316904, 0.750972160691783, 0.421962727382347, 0.630243285799926, 
0.575866112480541, 0.331617484056072, 0.880175147517098, 0.398626259709664, 
0.453109749361369, 0.89591402846511, 0.800528147561602, 0.797443406632106, 
0.707871104991111, 0.720883316856463, 0.589889378319629, 0.349813234586068, 
0.740142906790019, 0.495298129407806, 0.389674692905969, 0.869933439187107, 
0.743658144096678), dim = c(10L, 10L), dimnames = list(c("ALDH8A1", 
"ALDOB", "ANXA9", "AQP1", "ARL4D", "BIN2", "BRF2", "BST2", "C14orf109", 
"C1QTNF3"), c("TCGA-CZ-5455-11A", "TCGA-BQ-7061-11A", "TCGA-B0-5402-11A", 
"TCGA-CZ-5469-11A", "TCGA-CZ-5465-11A", "TCGA-BQ-7051-11A", "TCGA-CZ-5454-11A", 
"TCGA-BQ-5875-11A", "TCGA-BQ-5891-11A", "TCGA-BQ-5890-11A")))

r

来源：https://stackoverflow.com/questions/75195854/how-to-add-a-row-to-a-dataframe-and-populate-it-with-a-string

1条答案

按热度按时间

k7fdbhmy1#

1.正如RicVallalba评论的那样，你的数据是matrix而不是data.frame，这通常不是问题，我们可以用任何一种方式工作，但是如果你需要一个帧，那么就用df <- as.data.frame(df)。
1.不清楚将"normal"（一个 string）追加到一个填充了numeric数据的对象中是什么意思：通过将字符串添加到任何列，通过将那些数字转换成字符串来破坏所述列，从而挫败将来可能想要对它们进行的任何数字操作。
我将推断您真正的意思是添加一个名为 * "normal"的空值行。

dfnew <- rbind(df, `rownames<-`(df[1,,drop=FALSE][NA,,drop=FALSE], "normal"))
dfnew
#           TCGA-CZ-5455-11A TCGA-BQ-7061-11A TCGA-B0-5402-11A TCGA-CZ-5469-11A TCGA-CZ-5465-11A TCGA-BQ-7051-11A TCGA-CZ-5454-11A TCGA-BQ-5875-11A TCGA-BQ-5891-11A TCGA-BQ-5890-11A
# ALDH8A1          0.8172352        0.7393428        0.7655428        0.7872914        0.7628641        0.7435641        0.8311469        0.7972583        0.7509722        0.7974434
# ALDOB            0.8422712        0.8159447        0.5687056        0.8551923        0.8225005        0.5417837        0.7458905        0.5391252        0.4219627        0.7078711
# ANXA9            0.7870537        0.7010248        0.6714274        0.7436327        0.6811466        0.6756952        0.8190479        0.7377246        0.6302433        0.7208833
# AQP1             0.7232538        0.6905575        0.5317167        0.7102424        0.7225624        0.5303352        0.6930616        0.5969598        0.5758661        0.5898894
# ARL4D            0.3308110        0.2922466        0.3315800        0.3517832        0.2950074        0.3111481        0.3443766        0.3408338        0.3316175        0.3498132
# BIN2             0.9292822        0.9078039        0.8408896        0.9337021        0.9236711        0.8884036        0.9251225        0.8670124        0.8801751        0.7401429
# BRF2             0.3859001        0.4532132        0.4946407        0.4105254        0.3795397        0.4898509        0.4380539        0.4143989        0.3986263        0.4952981
# BST2             0.5802927        0.5507452        0.3967831        0.5494790        0.5150605        0.4951377        0.5396019        0.4784589        0.4531097        0.3896747
# C14orf109        0.9289390        0.9133709        0.8692727        0.9209103        0.9176713        0.9282705        0.9303132        0.9148618        0.8959140        0.8699334
# C1QTNF3          0.7864383        0.7163104        0.7590223        0.8124584        0.7991758        0.7816199        0.7798741        0.7947324        0.8005281        0.7436581
# normal                  NA               NA               NA               NA               NA               NA               NA               NA               NA               NA

(This同时适用于框架和矩阵。）

赞(0）回复(0）举报 2023-01-22

我来回答

如何在 Dataframe 中添加一行并使用一个字符串填充它？

1条答案

相关问题

热门标签

最新问答