R help - Feb 2009 - How do I get xtabs to show missing data?

I presume the behavior below (no Connector values in the second table)
is because I have na values in my dataframe.  How do I get them to list?

 

I found references to na.action and na.pass, but I could not figure out
how I could use them with xtabs to list the na as a value.  I'm sure
there's a simple syntax I need, but it's not obvious to me.  

 

 

 

 

 
> # Weighted Data
> XTTable <- xtabs(wt_annual ~  time_strata + connector, LAWAData) 
> XTTable                                 ## List 
                                        connector

time_strata                              OD Passenger Connector

  Morning Peak - 0550 to 0959                5605.140  1234.933

  Late morning to Mid-Day - 1000 to 1359     4778.503  2516.943

  Evening Peak - 1400 to 1959                5145.730  3171.348

  Night - 2000 to 0235 (last flight)         2929.085  2567.790
> 
> XTTable <- xtabs(wt_annual ~ Mode_orig_only + connector, LAWAData) 
> XTTable                                 ## List 
                                                              connector

Mode_orig_only                                                 OD
Passenger    Connector

  Walked/Biked
17.814338     0.000000

   I flew in from another a place/connected
0.000000     0.000000

  Amtrak
49.128982     0.000000

  Bus - Chartered bus or van
525.978899     0.000000

  Bus - Hotel Courtesy van
913.295370     0.000000

  Bus - MTA (Metro) or other public transit bus
114.302764     0.000000

  Bus - Scheduled airport bus or van (e.g. Airport bus or Disn
298.151438     0.000000

  Bus - Union Station Flyaway
93.088049     0.000000

  Bus - Van Nuys Flyaway
233.794168     0.000000

  Green line/light rail
20.764539     0.000000

  Limousine/town car
424.120506     0.000000

  Metrolink
8.054528     0.000000

  Motorcycle
6.010790     0.000000

  On-call shuttle/van (e.g. Super Shuttle, Prime Time)
1832.748525     0.000000

  Car/truck/van - Private
10191.284139     0.000000

  Car/truck/van - Rental
2099.771923     0.000000

  Taxi
1630.148576     0.000000

  ..Refused
0.000000     0.000000
> 
 

 

 

Robert Farley

Metro

1 Gateway Plaza

Mail Stop 99-23-7

Los Angeles, CA 90012-2952

Voice: (213)922-2532

Fax:    (213)922-2868

www.Metro.net 

 

 


	[[alternative HTML version deleted]]

Try setting exclude=NULL if you think that the NA's need to be considered as
a value.

The default is to exclude both NaN and NA.

-- 
David Winsemius

 -------------- Original message ----------------------
From: "Farley, Robert" <FarleyR at
metro.net>
> I presume the behavior below (no Connector values in the second table)
> is because I have na values in my dataframe.  How do I get them to list?
> 
>  
> 
> I found references to na.action and na.pass, but I could not figure out
> how I could use them with xtabs to list the na as a value.  I'm sure
> there's a simple syntax I need, but it's not obvious to me.  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> > # Weighted Data
> 
> > XTTable <- xtabs(wt_annual ~  time_strata + connector, LAWAData) 
> 
> > XTTable                                 ## List 
> 
>                                         connector
> 
> time_strata                              OD Passenger Connector
> 
>   Morning Peak - 0550 to 0959                5605.140  1234.933
> 
>   Late morning to Mid-Day - 1000 to 1359     4778.503  2516.943
> 
>   Evening Peak - 1400 to 1959                5145.730  3171.348
> 
>   Night - 2000 to 0235 (last flight)         2929.085  2567.790
> 
> > 
> 
> > XTTable <- xtabs(wt_annual ~ Mode_orig_only + connector, LAWAData) 
> 
> > XTTable                                 ## List 
> 
>                                                               connector
> 
> Mode_orig_only                                                 OD
> Passenger    Connector
> 
>   Walked/Biked
> 17.814338     0.000000
> 
>    I flew in from another a place/connected
> 0.000000     0.000000
> 
>   Amtrak
> 49.128982     0.000000
> 
>   Bus - Chartered bus or van
> 525.978899     0.000000
> 
>   Bus - Hotel Courtesy van
> 913.295370     0.000000
> 
>   Bus - MTA (Metro) or other public transit bus
> 114.302764     0.000000
> 
>   Bus - Scheduled airport bus or van (e.g. Airport bus or Disn
> 298.151438     0.000000
> 
>   Bus - Union Station Flyaway
> 93.088049     0.000000
> 
>   Bus - Van Nuys Flyaway
> 233.794168     0.000000
> 
>   Green line/light rail
> 20.764539     0.000000
> 
>   Limousine/town car
> 424.120506     0.000000
> 
>   Metrolink
> 8.054528     0.000000
> 
>   Motorcycle
> 6.010790     0.000000
> 
>   On-call shuttle/van (e.g. Super Shuttle, Prime Time)
> 1832.748525     0.000000
> 
>   Car/truck/van - Private
> 10191.284139     0.000000
> 
>   Car/truck/van - Rental
> 2099.771923     0.000000
> 
>   Taxi
> 1630.148576     0.000000
> 
>   ..Refused
> 0.000000     0.000000
> 
> > 
> 
>  
> 
>  
> 
>  
> 
> Robert Farley
> 
> Metro
> 
> 1 Gateway Plaza
> 
> Mail Stop 99-23-7
> 
> Los Angeles, CA 90012-2952
> 
> Voice: (213)922-2532
> 
> Fax:    (213)922-2868
> 
> www.Metro.net 
> 
>  
> 
>  
> 
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.