Stargazer summary table is empty

Question

I want to make a summary-stargazer table in R, which gives me the respective number of observations N, the mean, the standard deviation, minimum and maximum for the variables "educ" and "exper". I used the following code in order to generate a table in Latex.

rm(list = ls())
wage2 <- read_csv("~/homework/wage2.txt")
library(stargazer)

stargazer(wage2[c("educ","exper")], type = "latex", digits=1,flip = TRUE)

I get the following output. As you can see the table appears, but it is empty. If I use standard R-data (for example data("mtcars")), it works. Anyone has an idea, what could be wrong with my data? The usual R command summary(wage2) works perfectly, but I can not use this in Latex. Thank you!

% Table created by stargazer v.5.2 by Marek Hlavac, Harvard University.
E-mail: hlavac at fas.harvard.edu 
% Date and time: Mo, Mai 07, 2018 - 16:40:31  
\begin{table}[!htbp] \centering  
  \caption{}  
  \label{}  
\begin{tabular}{@{\extracolsep{5pt}}lcc}  
\\[-1.8ex]\hline  
\hline \\[-1.8ex]  
Statistic \\  
\hline \\[-1.8ex]  
N \\  
Mean \\  
St. Dev. \\  
Min \\  
Max \\  
\hline \\[-1.8ex]  
\end{tabular}  
\end{table}

The data looks like this:

> str(wage2)
Classes ‘tbl_df’, ‘tbl’ and 'data.frame':   935 obs. of  17 variables:
 $ wage   : int  769 808 825 650 562 1400 600 1081 1154 1000 ...
 $ hours  : int  40 50 40 40 40 40 40 40 45 40 ...
 $ IQ     : int  93 119 108 96 74 116 91 114 111 95 ...
 $ KWW    : int  35 41 46 32 27 43 24 50 37 44 ...
 $ educ   : int  12 18 14 12 11 16 10 18 15 12 ...
 $ exper  : int  11 11 11 13 14 14 13 8 13 16 ...
  - attr(*, "spec")=List of 2
  ..$ cols   :List of 17
  .. ..$ wage   : list()
  .. .. ..- attr(*, "class")= chr  "collector_integer" "collector"
  .. ..$ hours  : list()
  .. .. ..- attr(*, "class")= chr  "collector_integer" "collector"
  .. ..$ IQ     : list()
  .. .. ..- attr(*, "class")= chr  "collector_integer" "collector"
  .. ..$ KWW    : list()
  .. .. ..- attr(*, "class")= chr  "collector_integer" "collector"
  .. ..$ educ   : list()
  .. .. ..- attr(*, "class")= chr  "collector_integer" "collector"
  .. ..$ exper  : list()
  .. .. ..- attr(*, "class")= chr  "collector_integer" "collector"
    .. .. ..- attr(*, "class")= chr  "collector_double" "collector"
  ..$ default: list()
  .. ..- attr(*, "class")= chr  "collector_guess" "collector"
  ..- attr(*, "class")= chr "col_spec"
> head(wage2)
# A tibble: 6 x 17
   wage hours    IQ   KWW  educ exper tenure   age married black south
urban  sibs brthord
  <int> <int> <int> <int> <int> <int>  <int> <int>   <int> <int> <int>
<int> <int>   <int>
1   769    40    93    35    12    11      2    31       1     0     0  
1     1       2
2   808    50   119    41    18    11     16    37       1     0     0    
1     1      NA
3   825    40   108    46    14    11      9    33       1     0     0    
1     1       2
4   650    40    96    32    12    13      7    32       1     0     0  
1     4       3
5   562    40    74    27    11    14      5    34       1     0     0    
1    10       6
6  1400    40   116    43    16    14      2    35       1     1     0    
1     1       2
# ... with 3 more variables: meduc <int>, feduc <int>, lwage <dbl>

Reductive

You would have to show the str(wage2) and the head(wage2), or if possible all the complete data, to be able to help you. – Lodi

Thanks for your hint. I edited the question and added the data. – Reductive

Answer 1

To generate a summary, stargazer requires a data.frame as input. As you are supplying a tibble, stargazer cannot produce any output.

Adding as.data.frame() should do the trick **.

stargazer(as.data.frame(wage2[c("educ","exper")]), type = "latex", digits=1,flip = TRUE)

** Disclaimer: As you are not supplying a reproduceable example I created a random tibble to reproduce your error, and tried the same code again with as.data.frame() which produced a satisfactory result. But I cannot "guarantee" that your specific example does not suffer from further specification problems.

Intellect