print(date())
## [1] "Wed May 13 12:40:03 2015"
Distribution of packages and consultants lumping HLM, Other, and missing together into ‘Other’.
Helpfullness ratings by consultant.
Helpfullness ratings by consultant, solo consultations.
Helpfulness by package
Distribution of number of visits per client
Distribution of number of hours per client
Client status proportions
Total visits per day
Mean visits per day
## Warning: Removed 2 rows containing missing values (stat_summary).
Visits per week
Distribution of minutes per client
Distribution of minutes per client by consultant
## Warning in write.dta(both3, file = "visits_clients_plus.dta", version = ## 11): character strings of >244 bytes in column 11 will be truncated
Median minutes per client by consultant
## Median Session Minutes > 5 by Consultant
## [,1] ## alin 47.850 ## awhitworth 37.283 ## bkim 37.817 ## crw 42.292 ## ender 41.167 ## jricks 46.333
Hours with clients by consultant
## Warning: Removed 2 rows containing missing values (position_stack).
Hours with client by helpfulness rating
Super Users: All Time
## Client Name Department Minutes ## KYOKO SHIMAMOTO Public Health 5839.93 ## DEANNAH BYRD CHS 2856.00 ## OSMAN, TANER Urban Planning 2120.63 ## HAFTOGLOU, SOULTANA Community Health Sciences 1911.60 ## CARSTEN ERNER Anderson School 1669.32 ## STEY, ANNE Med-GIM & HSR 1594.60 ## FUENTES, MARCIA GSE&IS-HERI 1566.85 ## HOFFMAN, GEOFFREY JONATHAN Health Policy and Management 1406.97 ## RACHEL MANDELBAUM Head and Neck Surgery 1350.22 ## CARBINO, JESSICA Sociology 1348.92 ## CHAPMAN, AARON Molecular Toxicology 1331.25 ## GUO, SISI Psychology 1257.48 ## DELILLY, CAROL ROSE Nursing 1228.70 ## MALDONADO CHAPARRO, ADRIANA EEB 1199.95 ## DAVIS, CLAUDIA MAGGIE nursing 1170.97 ## CARPINELLA, COLLEEN Psychology 1125.23 ## JAIN, FELIPE Semel Institute 1088.35 ## PARK, HEEJUNG Psych-Dvlmt 1041.02 ## GHAVAMI, NEGIN GSE&IS-PSE 1017.10 ## BROWN, LILY ANNA Psychology 1009.22 ## TSAI, KIM Psych-Dvlmt 975.88 ## TUNG, IRENE Psych-Clin 944.27 ## GRACE, SHERRY M Health Policy and Management 938.55 ## LIZ KOFMAN Sociology 938.17 ## MOLINA, DANI GSE&IS-CRP 931.92
Super Users: Last 90 Days
## Client Name Department Minutes ## KYOKO SHIMAMOTO Public Health 964.72 ## BENSON, STEPHANIE Social Welfare 435.13 ## DEANNAH BYRD CHS 366.47 ## ALLEN, VINCENT Psych-Clin 360.75 ## CARSTEN ERNER Anderson School 358.77 ## GUO, SISI Psychology 328.38 ## THOMAS, JACOB RICHARD Sociology 301.52 ## ANNALIJN CONKLIN World Policy Analysis 287.78 ## SEAN WANG Biostatistics 282.12 ## FEHRENBACHER, ANNE ELIZABETH Community Health Sciences 245.05 ## BELL, ARIANA Psych-Soc 239.98 ## ERIC ABELSON IOES 235.23 ## FRANCES BARRY Neurology 228.27 ## MCKENNEY, JENNIE LEE Epidemiology 228.22 ## BAWEJA, SHILPA Education - HDP 226.68 ## KIM, JOANNA Psych-Clin 209.22 ## VIRK, JASVEER Pub Hlth-Epid 207.80 ## MESRI, BITA Psych-Clin 205.88 ## GASE, LAUREN NICHOL Public Health 191.07 ## KRISTEN KAO Political Science 168.00 ## DANIEL CROYMANS medical school 160.18 ## BEGENY, CHRISTOPHER Psych-Soc 157.42 ## MORDECHAY, KFIR GSE&IS-PSE 148.25 ## COLLINS, JONATHAN EDWARD Poli Sci / Stat 147.18 ## HARLEY, JASON SEAN Social Welfare 143.77
Most recent comments by consultant
## **** CONSULTANT: alin **** ## CARSTEN ERNER ## Many thanks! ## BEGENY, CHRISTOPHER ## as always, super super helpful!!! ## ## GREENE, NAOMI ## Andy and Joni were as ever awesome and so helpful and patient. ## ALLEN, VINCENT ## Andy is the best! So helpful and patient ## BEGENY, CHRISTOPHER ## EXTREMELY HELPFUL!!!! ## BELL, ARIANA ## Andy is so helpful! Thank you!!! ## KIM, EUN KYUNG ## thanks a lot ## ANNIE TRAN ## Thank you!! I understand the T tests so much better and how it applies to my project! ## PAI, JIEUN ## patient and really helpful! ## CARSTEN ERNER ## Many thanks! Very helpful as always! ## ## ## **** CONSULTANT: crw **** ## ANNALIJN CONKLIN ## got advice on two-level model with sampling weights and tested syntax on new version of STATA which was useful ## BENSON, STEPHANIE ## Amazing...explanations were so clear! ## LAM, CHRISTINE ANYEE ## Thank you so much for your excellent help! ## BENSON, STEPHANIE ## Excellent explanations! ## DOOLEY, LARISSA ## extremely helpful and informative! thank you christine! ## DIANA LIAO ## This is again a very helpful session. I appreciate Alex' calmness and patience. Both Alex and Christine are very professional! ## SOLIS, DIANA ## Very efficient service. Christine was very thorough, patient and informative in helping me solve a very unusual issue in an SPSS file. Many thanks! ## MARIA-ELENA YOUNG ## This was fantastic! So helpful! ## ROSEN, GINA L ## very informative and understanding ## HARGIS, MARY BRYCE ## Christine was great! Answered all my questions with super high knowledge and explained everything well. ## ## ## **** CONSULTANT: jricks **** ## ELIZABETH VAN DYNE ## Excellent! Thanks! ## GUO, SISI ## Again thank you for all the help on this tedious set of analyses! ## MARIA-ELENA YOUNG ## Thank you! ## HERBERT, LORNA KWAN ## helped with coding in SAS! awesome as usual ## PAMELA MILLER ## Fantastic consultation. Thanks so much! ## GASE, LAUREN NICHOL ## figured out this time!! :) ## SCELZA, BROOKE ## Got through a bunch of analyses and figured out graphs for paper. Thanks! ## NICHOLAS AU YONG ## Extremely valuable service!! Really appreciated ## ELIZABETH GARCIADUBON ## Joni was extremely helpful and patient with me. She explained everything very thoroughly and got me started on my own laptop. She was very knowledgeable and didn't waste anytime. ## Thanks!!! ## THOMAS, PATRICK SHANE ## good context for my questios. Thanks!! ## ## ## **** CONSULTANT: ender **** ## GRETHER, GREGORY F. ## Thanks!! ## PAMELA MILLER ## amazing! knowledgeable. extremely helpful! ## JAFFER KATTAN ## outstanding help! thank you! ## MCNAMARA, KATHERINE ALICE ## thanks so much! ## GUO, SISI ## Thanks for all the help in the last few weeks with this rather complicated multi-part question. Really appreciate the help and patience from Phil and others. ## REDING, MICHAEL EDWARD JAMES ## Phil was very clear and patient in explaining multilevel modeling project in SPSS! ## KAREN GUAN ## Very clear explanations - thank you! ## STAVRINOS, THEANO ## Python ## KIM, JOANNA ## great, helpfui; ## FRICKER, GEOFFREY ANDREW ## CCA PCA RandomForest help ## ## ## **** CONSULTANT: awhitworth **** ## FRANNY BROGAN ## very nice and helpful ## JAMES VU ## Extremely helpful session to see how "R" is used to show our data in a heat map. Also, consultant raised several great questions for us to look into in terms of the final set of data we would be using for data analysis. Thank you. ## ELEANOR GLEWWE ## I got some new ideas, so I'm looking forward to trying those. Overall the visit was pretty helpful. ## HERTS, KATE ## Thanks! ## RODAS, NAOMI ## very helpful and well explained ## CONNELLY, KELLY THERESA ## very helpful, thank you for your time! ## LEFKOWITZ, LEE MICHAEL ## Thanks! ## ## Using Python to construct new models / model training algorithms. ## FALES, MELISSA ## Helped with multilevel model and interpretation of time. Need to now look up new models to figure out my paper. Thanks! ## MCKENZIE, MEGHAN ## Alex was very helpful in assisting me to use cluster analysis in R. I appreciated how he explained the function of the code, so I can use it easily on my own at home. Thanks! ## VILLALOBOS, AMBER DYAN ## Alex was very helpful in walking me through graphs and interactions. ## ## ## **** CONSULTANT: bkim **** ## JUN, SUN-AH ## The consultant (Brian Kim) was very helpful and knowledgeable. He was also very patient and supportive. I really appreciate the help I got. ## MALDONADO CHAPARRO, ADRIANA ## great ## ARTHUR YULE ## Teaching of concepts and practical application was excellent and easily understood. ## FRICKER, GEOFFREY ANDREW ## randomForest help ## THOMAS, JACOB RICHARD ## great ## JASON NGUYEN ## Incredibly helpful. Thanks to Brian and Andy for helping me with this project. Could not have done it without them. ## TIEE, MADELINE SHAOYUN ## Thank you! Helped with thinking of framework of how to approach data with various models. ## HARLEY, JASON SEAN ## understanding zero inflated model ## GOLDENBERG, ELIZABETH ## All my questions were answered. ## MICKLOS, ASHLEY MICHELLE ## well informed and patient consultants