Log in
Skip to sidebar
Skip to main content
Spaces
Create
Create
Hit enter to search
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
Available Gadgets
About Confluence
Log in
People
Serena Barbieri
Blog
2022
November
15
Meeting with Catherine R. Barber, Data Services Specialist at Rice
Meeting with Catherine R. Barber, Data Services Specialist at Rice
search
attachments
weblink
advanced
image-effects
image-attributes
Paragraph
Paragraph
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Preformatted
Quote
Bold
Italic
Underline
Colour picker
More colours
Formatting
Strikethrough
Subscript
Superscript
Monospace
Clear formatting
Bullet list
Numbered list
Task list
Outdent
Indent
Align left
Align center
Align right
Page layout
Link
Table
Insert
Insert content
Files and images
Link
Markup
Horizontal rule
Task list
Date
Emoticon
Symbol
Insert macro
User mention
Info
Status
Gallery
Table of Contents
Other macros
Page layout
No layout
Two column (simple)
Two column (simple, left sidebar)
Two column (simple, right sidebar)
Three column (simple)
Two column
Two column (left sidebar)
Two column (right sidebar)
Three column
Three column (left and right sidebars)
Undo
Redo
Find/Replace
Keyboard shortcuts help
You are not logged in. Any changes you make will be marked as
anonymous
. You may want to
Log In
if you already have an account.
This page is also being edited by
. Your changes will be merged with theirs when you save.
<p>Today, I met with Catherine Barber on Zoom to</p><ul><li>discuss my project with a data specialist since I am not</li><li>understand if there are any changes I should make in the way I gather data to be able to analyze them proficiently</li><li>and see if and how Rice can support me through the process. </li></ul><p><u><span style="color: rgb(0,51,102);">THESE WERE THE QUESTIONS I BROUGHT TO THE TABLE</span></u></p><p>For the analysis, I could select different typologies of convicts to answer different questions. Just as an example: role of race in punishment and allocation of the convicts; mass escapes v. Individual escapes; the time between acts of pardon and effective discharge; change over time of type and length of convictions by county; comparison between counties in punishing crimes; assessing re-habilitative claims by looking at re-incarceration rates; etc.</p><div><span><br /></span></div><div><span><strong>These are the problems I see</strong>:</span></div><div><span>1) I have 12 Excel files, one for every ledger of the prison, for a total of about 40,000 convicts. I prefer 12 files to one file with 12 sheets just in case something bad happens. At some point, I will need to combine those spreadsheets into one with 40,000 names. I already see that Excel is lagging when I am making changes to files with only 3,000-3,500 names. Is there a better program than Excel for the scope?</span></div><div><span>2) I would benefit from some shortcuts in inserting the data. It does not seem Excel is really helpful for what I would like to automatize, but maybe it is because I do not know the program well. Some help or advice on that?</span></div><div><span>3) I would like to make the database accessible to researchers, when my dissertation is done, by uploading it (or linking it) on a dedicated website. Will it be ever possible to do so or this requires platforms too expensive for me to afford? </span></div><div>4) I want to map on GIS the location of the work camps AND their change over time. Moreover, I would like to map the convicts' birthplace, place of residence, place of conviction, and movement after discharge and represent those data in a meaningful way. Any advice?</div><div>The meeting went great, and I have now a clear path to follow.</div><div><strong>Catherine suggested</strong>:</div><div>1) continuing to keep my Excel spreadsheet in separate files with identical variables so that it will be easy to merge them when needed. Although Excel does not offer many shortcuts, it is still a pretty solid software for my needs</div><div>2) make multiple backups of my files</div><div>3) start preparing now for the time I start analyzing the data. She suggested two open-source programs for data analysis: Python or R. While R is a better tool for statistical analysis, Python is more flexible and better helps to transform, filter, select, and visualize big data. Python runs several apps and this makes it very adaptable.</div><div>4) a code in Python is shareable, thus is it possible to link the data analysis/visualization to any website/wiki page</div><div>5) start learning Python. Rice offers classes online (I already enrolled for a beginner class at the end of November; one two-days full immersion class will be available in February). She will share with me her list of resources for self-teaching.</div><div>6) when the database is ready, Fondren Library can register ut with a data object identifier that protects my intellectual property by making it easier for other researchers to cite the database</div><div>7) look into courses for learning GIS (I did a couple in the past but I did not have data ready for mapping, so I just forgot everything).</div><div>The conversation was exciting and very useful. I am really grateful for the time and this tremendous resource that Rice offers. Good to know that I am on track. </div>
If you are unable to use this CAPTCHA please <a href="administrators.action" tabindex="5">contact your administrator</a> for assistance.
Edit
Save
Close
Preview
View changes
Revert to last published version
{"serverDuration": 41, "requestCorrelationId": "fb585c07658c59ef"}