Questions tagged [sparktable]

11 questions
4
votes
1 answer

Plots for more than one series with "sparkTable" package

If I understand it correctly, the sparkTable package allows for multiple kinds of plots, but only on one series. So, for example, if my dataset df looks like this: variable value time Level_1 34 1947 Level_1 38 1948 Level_1 17 …
user702432
  • 11,898
  • 21
  • 55
  • 70
4
votes
1 answer

Sparklines in R for use in Latex table (using Knitr)

I would like to create a sparkline using R and include it in a Latex table (using knitr) . I have found the SparkTable package but have been unable to work out how to specify (based on my own set of rules) which data points are classified as…
user1420372
  • 2,077
  • 3
  • 25
  • 42
3
votes
1 answer

R Markdown - SparkTables not rendering

I am trying to render a sparktable using Rmarkdown. But the output always comes out in raw html or tex format. This depends on whether I am rendering a PDF or an HTML. Not sure what to do here? library(sparkTable) data("AT_Soccer") content <-…
msubbaiah
  • 350
  • 2
  • 14
3
votes
0 answers

Using sparkTable to create plots with different frequencies

I am trying to create a dashboard which looks something like the image just below: It makes a cumulative plot for indices using weekly returns. Now i want to embed a barplot as additional column which plots returns at monthly frequency (assuming…
2
votes
2 answers

How to remove blank spaces in Spark table column (Pyspark)

I would like to remove blank spaces from all values in a specific column(purch_location). I am using a spark table rather then a dataframe or SQL table (but I can use dataframe or SQL table if need be). Here is how my spark table was generated:…
Bisbot
  • 127
  • 2
  • 3
  • 9
2
votes
1 answer

How to use sparktable in knitr with rmarkdown for PDF

Just learned about sparktable and went over few documents about it. I was wondering if it can be used with knitr and rmarkdown to produce a PDF document that embed sparktable? Also, I noticed plotSparkTable() used in many examples, but it does not…
user2103970
  • 703
  • 3
  • 9
  • 15
1
vote
2 answers

Is it possible to plot histograms with sparkTable?

I can do a sparkBar, but no sparkHist. Is this possible to do? This is an example of how to create a sparkBar (from example(newSparkBar): library(sparkTable) data(pop) x <- pop[pop[,2]=="Insgesamt",3] b <-…
frankc
  • 11,290
  • 4
  • 32
  • 49
0
votes
1 answer

Databricks - converting Spark dataframe to table: is it the same data source?

You will need to perform quite some compute to make from the source dataframe, a Spark table, no? Or are dataframe and table both a pointer to the same data (i.e. when creating a table you are not creating duplicate data)? I guess what I'm trying to…
beyondtdr
  • 411
  • 6
  • 17
0
votes
1 answer

Sparktables: How can I output addition table elements?

I have a data frame (Counts of faults in MS Office over a number of years) which I am using to generate a sparktable successfully: df_Office_final_sparktable component faults time Excel 2 2001 Excel 1 2002 Excel 5 …
0
votes
2 answers

R sparkTable Formatting - Center Text

I am working with the R package "sparkTable" to create some tables in markdown for a PDF report. I have the table and the charts I want, but I don't seem to see any provisions for formatting the text inside the table. On things like kable and pander…
azdatasci
  • 801
  • 1
  • 13
  • 32
0
votes
1 answer

R Sparklines package error

I am using the Sparklines package in R and was using the reshapeExt() function to prepare a dataset, but ran into a very very strange issue. The dataset looks like this: Company time value 1 Microsoft 1990 11 2 Time Warner 1990 22 3 …
hippie_poe
  • 29
  • 5