HTML 5 Datalist选项(HTML 5 Datalist Option)
如何使用数据库中的数据将其放入HTML5的数据列表中
例如
<input list="browsers"> <datalist id="browsers"> <option value="Internet Explorer"> <option value="Firefox"> <option value="Chrome"> <option value="Opera"> <option value="Safari"> </datalist>
如何从数据库中检索选项? 而不是手动放置它。 我正在使用asp.net C#
How can I use data from database to place it in a datalist for HTML5
for example
<input list="browsers"> <datalist id="browsers"> <option value="Internet Explorer"> <option value="Firefox"> <option value="Chrome"> <option value="Opera"> <option value="Safari"> </datalist>
How can I retrieve options from database? Instead of placing it manually. I'm using asp.net C#
原文:https://stackoverflow.com/questions/16131946
更新时间:2024-01-28 08:01
最满意答案
这是一个基本解决方案:
> df1$seqnam <- ave(as.character(df1$name), df1$name, FUN=seq) # creates a "time" index > reshape(df1, direction="wide", timevar="seqnam", idvar=c("name", "var1", "var2") ) name var1 var2 var3.1 var3.2 var3.3 1 first 90 301 -0.5820759 NA NA 2 second 84 336 -1.1088896 -1.0149620 -0.1623095 5 fourth 18 412 -0.2823095 NA NA 6 third 22 296 0.5630558 -0.2320759 NA 8 fifth 36 357 -0.7733534 NA NA
Here's a base solution:
> df1$seqnam <- ave(as.character(df1$name), df1$name, FUN=seq) # creates a "time" index > reshape(df1, direction="wide", timevar="seqnam", idvar=c("name", "var1", "var2") ) name var1 var2 var3.1 var3.2 var3.3 1 first 90 301 -0.5820759 NA NA 2 second 84 336 -1.1088896 -1.0149620 -0.1623095 5 fourth 18 412 -0.2823095 NA NA 6 third 22 296 0.5630558 -0.2320759 NA 8 fifth 36 357 -0.7733534 NA NA
相关问答
更多-
如何在熊猫的多个数据框列中“选择不同”?(How to “select distinct” across multiple data frame columns in pandas?)[2022-03-11]
您可以使用drop_duplicates方法来获取drop_duplicates的唯一行: In [29]: df = pd.DataFrame({'a':[1,2,1,2], 'b':[3,4,3,5]}) In [30]: df Out[30]: a b 0 1 3 1 2 4 2 1 3 3 2 5 In [32]: df.drop_duplicates() Out[32]: a b 0 1 3 1 2 4 3 2 5 如果您只想使用某些列来确定唯一性 ... -
使用stringr::str_split_fixed library(stringr) str_split_fixed(before$type, "_and_", 2) Use stringr::str_split_fixed library(stringr) str_split_fixed(before$type, "_and_", 2)
-
试试这个兄弟 '(tic=="AAPL") 请注意我如何使用"不要混淆Python与' try this brother '(tic=="AAPL") note how I use " not to confuse Python with '
-
IIUC你可以这样做: df = df.drop(df.columns.filter(_.startsWith("null"))) IIUC you can do it this way: df = df.drop(df.columns.filter(_.startsWith("null")))
-
我认为这会奏效。 主要思想是我们将json_col转换为字符串,然后我们可以将其传递给fromJSON函数,该函数负责其余部分。 library(stringi) library(jsonlite) sample.df$json_col<- as.character(sample.df$json_col) json_obj<- paste(sample.df$json_col, collapse = "") json_obj<- stri_replace_all_fixed(json_obj, "][", ...
-
多列数据框(Multiple columns data frame)[2022-09-04]
您可以尝试使用tidyr::extract函数并提供regex参数,以便按预期方式从列中分隔文本。 一种这样的尝试可以是: library(tidyverse) tab %>% extract(col = c1, into = c("C1","C2","C3","C4"), regex = "([0-9.]+)\\s([A-Za-z ]+)\\s([0-9.']+)\\s(.*)") # C1 ... -
使用聚合将多个函数应用于数据框中的每个列(Applying multiple functions to each column in a data frame using aggregate)[2021-11-19]
正如@akrun所说, dplyr非常适合这项任务。 library(dplyr) npk %>% group_by(N, P) %>% summarise_each(funs(foo1, foo2), yield, block) # Source: local data frame [4 x 6] # Groups: N # # N P yield_foo2 block_foo2 yield_foo1 block_foo1 # 1 0 0 2.432390 1 ... -
在基础R中,设置数据: mask <- c('term1'=1,'term2'=2,'term3'=4) df <- data.frame(id = c(letters[1:3]), bitmask = c(1,4,5)) cbind(df, sapply(mask, bitwAnd, df$bitmask) > 0) # id bitmask term1 term2 term3 # 1 a 1 TRUE FALSE FALSE # 2 b 4 FALSE FALSE ...
-
或者: val base_tbl_columns: Array[String] = ??? df.select(concat(base_tbl_columns.map(c => col(c)): _*)) 要么: df.select(expr(s"""concat(${base_tbl_columns.mkstring(",")})""")) Either: val base_tbl_columns: Array[String] = ??? df.select(concat(base_tbl_col ...
-
这是一个基本解决方案: > df1$seqnam <- ave(as.character(df1$name), df1$name, FUN=seq) # creates a "time" index > reshape(df1, direction="wide", timevar="seqnam", idvar=c("name", "var1", "var2") ) name var1 var2 var3.1 var3.2 var3.3 1 first 90 3 ...