How can I pass R variable into sqldf? -


i have query this:

sqldf("select tenscore data state_p = 'andhrapradesh'")

but have "andhrapradesh" in variable statevalue. how can use variable in select query in r same result above.

please show me syntax.

you can use sprintf:

sqldf(sprintf("select tenscore data state_p = '%s'", statevalue))

Comments

Post a Comment

Popular posts from this blog

php - Embed BBCode within itself not working -

so working on simple php bbcode system, though doing [center][b][i]text[/i][/b][/center] doesn't parse. leaves couple out. curious if give me tip? or point me in direction learn how fix issue. sample of code: function bbcode($str) { $patterns = array(); $patterns = array( '#\[b\](.*?)\[/b\]#', '#\[i\](.*?)\[/i\]#', '#\[u\](.*?)\[/u\]#', '#\[color=(.*?)\](.*?)\[/color\]#', '#\[img\](.*?)\[/img\]#', '#\[center\](.*?)\[/center\]#', '#\n#' ); $replacements = array(); $replacements = array( '<strong>$1</strong>', '<em>$1</em>', '<u>$1</u>', '<span style="color:$1">$2</span>', '<img src="$1" style="max-width:45%;"></img>', '<center>$1</center>', '<br/>' ); return preg_replace($patterns, $re...
Read more

minify - Minimizing css files -

i want know how css files can minimized. currently, using external sites css minifier compress css files. however, after removing whitespaces, comments, etc, file sizes reduced 10-15%. how frameworks bootstrap manage make minimized versions kilobytes. as example, css is: body { background-color: #ff0; } the reduction goes 28 bytes 22 bytes other css files have lot more characters still smaller this. actually minifying code means it's remove thing code white space characters new line characters comments block delimiters it reduces amount of code has transferred on web , speed site load fastly.but unreadable format.
Read more

Connecting Spring Batch to Remote Cassandra Database -

i'm hoping read data csv file, process data, , upload remote database. i'm using spring's starter repo base . code here i tried putting information in properties file: spring.data.cassandra.contact-points=ip, ip spring.data.cassandra.port=port spring.data.cassandra.keyspace-name=keyspace_name spring.data.cassandra.username=user spring.data.cassandra.password=pass spring.data.cassandra.ssl=true however, think keeps defaulting pushing local tomcat jdbc. i'm not sure start. appreciated! thanks. your code doesn't have use cassandra. doesn't have of dependencies , itemwriter implementation jdbcbatchitemwriter don't think work cassandra. need configure application use cassandra (the spring data starter itemwriter implementation can write cassandra).
Read more