Skip to content

Instantly share code, notes, and snippets.

@sburns

sburns/pycap_df_long.ipynb

Created April 16, 2013 19:06
Show Gist options
  • Save sburns/5398642 to your computer and use it in GitHub Desktop.
Save sburns/5398642 to your computer and use it in GitHub Desktop.
Download ZIP
pycap and hierarchical df from longitudinal project
Display the source blob
Display the rendered blob
Raw
pycap_df_long.ipynb
{
"metadata": {
"name": "pycap_df_long"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"from redcap import Project\n",
"project = Project('https://redcap.vanderbilt.edu/api/', 'XXX')"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df = project.export_records(event_name=\"raw\", format='df')\n",
"df"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>redcap_event_name</th>\n",
" <th>first_name</th>\n",
" <th>last_name</th>\n",
" <th>dob</th>\n",
" <th>sex</th>\n",
" <th>address</th>\n",
" <th>phone_number</th>\n",
" <th>demographics_complete</th>\n",
" </tr>\n",
" <tr>\n",
" <th>study_id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Amie</td>\n",
" <td> Fang</td>\n",
" <td> 1964-04-08</td>\n",
" <td> 0</td>\n",
" <td> 123 Main Street\\r\\nAnywhere, ST 12345</td>\n",
" <td> (415) 555-1212</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> second_arm_1</td>\n",
" <td> blah blah</td>\n",
" <td> foo bar</td>\n",
" <td> 2013-04-16</td>\n",
" <td> 1</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Christian</td>\n",
" <td> Croghan</td>\n",
" <td> 1965-09-27</td>\n",
" <td> 1</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Allan</td>\n",
" <td> Behringer</td>\n",
" <td> 1977-02-28</td>\n",
" <td> 1</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Noemi</td>\n",
" <td> Poitras</td>\n",
" <td> 1988-05-01</td>\n",
" <td> 0</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Clinton</td>\n",
" <td> Mcglasson</td>\n",
" <td> 1991-03-14</td>\n",
" <td> 1</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Hugh</td>\n",
" <td> Brightwell</td>\n",
" <td> 1992-03-12</td>\n",
" <td> 1</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Hugh</td>\n",
" <td> Ducasse</td>\n",
" <td> 1995-01-28</td>\n",
" <td> 1</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Nelson</td>\n",
" <td> Stickel</td>\n",
" <td> 1998-02-09</td>\n",
" <td> 1</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Jerri</td>\n",
" <td> Preas</td>\n",
" <td> 2003-03-13</td>\n",
" <td> 0</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> visit_1_arm_1</td>\n",
" <td> Kelly</td>\n",
" <td> Eichner</td>\n",
" <td> 2012-11-15</td>\n",
" <td> 0</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 12,
"text": [
" redcap_event_name first_name last_name dob sex \\\n",
"study_id \n",
"1 visit_1_arm_1 Amie Fang 1964-04-08 0 \n",
"1 second_arm_1 blah blah foo bar 2013-04-16 1 \n",
"2 visit_1_arm_1 Christian Croghan 1965-09-27 1 \n",
"3 visit_1_arm_1 Allan Behringer 1977-02-28 1 \n",
"4 visit_1_arm_1 Noemi Poitras 1988-05-01 0 \n",
"5 visit_1_arm_1 Clinton Mcglasson 1991-03-14 1 \n",
"6 visit_1_arm_1 Hugh Brightwell 1992-03-12 1 \n",
"7 visit_1_arm_1 Hugh Ducasse 1995-01-28 1 \n",
"8 visit_1_arm_1 Nelson Stickel 1998-02-09 1 \n",
"9 visit_1_arm_1 Jerri Preas 2003-03-13 0 \n",
"10 visit_1_arm_1 Kelly Eichner 2012-11-15 0 \n",
"\n",
" address phone_number \\\n",
"study_id \n",
"1 123 Main Street\\r\\nAnywhere, ST 12345 (415) 555-1212 \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 NaN NaN \n",
"4 NaN NaN \n",
"5 NaN NaN \n",
"6 NaN NaN \n",
"7 NaN NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"\n",
" demographics_complete \n",
"study_id \n",
"1 2 \n",
"1 2 \n",
"2 0 \n",
"3 0 \n",
"4 0 \n",
"5 0 \n",
"6 0 \n",
"7 0 \n",
"8 0 \n",
"9 0 \n",
"10 0 "
]
}
],
"prompt_number": 12
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment