[TRU Research] Research / data analysis group

[Katie Wilson]

Hi All,

Mike merged the google forms responses with the larger data set and removed PII— I’ve uploaded the file to the wiki here <https://seattletransitpasses-research.pbworks.com/w/file/133754394/Merged%20TRU%20survey%20no%20PII.xlsx>. 

I think the main cleaning that needs to be done before we can answer most of the questions we’ve discussed so far is to remove responses from people who don’t commute to a job. I’ve described that task above the data analysis tables here <https://seattletransitpasses-research.pbworks.com/w/page/133613826/Commute%20Survey%201>. 

I listed a couple more things people could do with the data now on the Research Tasks page here <https://seattletransitpasses-research.pbworks.com/w/page/133438026/Research%20Questions>. If you’re going to work on something please put your name in the table so we don’t duplicate efforts.

I’m going to be out of town tonight through Monday night but then will be back in action.

- Katie

p.s. In case it’s not clear, this is a listserv so if you reply to research at transitriders.org <mailto:research at transitriders.org> it goes to everyone in the group.

> On May 16, 2019, at 10:41 AM, Katie Wilson <katie at transitriders.org> wrote:
> 
> Hi All,
> 
> Thanks for meeting at Optimism on Tuesday! On this email group are Mike, Harry, Stephen, Jim, and Tom. You should all have access to our wiki tool, PBworks. If you didn’t get an invitation or weren’t able to access the site, let me know.
> 
> I started making some tables that I thought might be a good way to display our survey data analysis <https://seattletransitpasses-research.pbworks.com/w/page/133613826/Commute%20Survey%201>. But, I’m not an expert on this stuff, so please take a look and let me know what you think. Mike is going to work on merging the data, removing PII, and either cleaning or identifying the cleaning tasks that need to be done.
> 
> Harry was able to scrape all the info we need and more <https://seattletransitpasses-research.pbworks.com/w/file/133642833/scraped_sbux_loc.xlsx> about Starbucks locations, so we’re good on that front!
> 
> Here’s the table for collecting info about CTR-affected employers <https://seattletransitpasses-research.pbworks.com/w/page/133437828/Potential%20CTR%20Targets> that don’t contract directly with Metro for ORCA programs. Feel free to fill stuff in. I just added a few columns that weren’t there before. Basically, we’re trying to decide whether these could be good targets. (And by the way, if you’re interested in reading about the Commute Trip Reduction law, you can do that here <https://www.seattle.gov/transportation/projects-and-programs/programs/transportation-options-program/commute-trip-reduction-program/ctr-requirements>.)
> 
> Finally, here’s where we can list tasks that need to be done <https://seattletransitpasses-research.pbworks.com/w/page/133438026/Research%20Questions:>. I’m hoping all these pages are pretty easy to navigate to and between, just wanted to send some links to start things off.
> 
> If you have some time & aren’t sure what to work on, email me and we’ll figure something out!
> 
> - Katie
> 
> Katie Wilson
> General Secretary
> Transit Riders Union
> https://transitriders.org <https://transitriders.org/>
> 206-781-7204
> 
> The Transit Riders Union is a democratic organization of working and poor people, including students, seniors, and people with disabilities, taking control over our own lives, and building up the power we need to change society for the good of humanity and of the planet. We will fight to preserve, expand, and improve the public transportation system in Seattle and beyond, so that every human being has access to safe, affordable, and reliable public transit.
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.transitriders.org/pipermail/research/attachments/20190523/35a3ea82/attachment.html>