Month: February 2020

I’ve been fortunate to have spent the last year and a half with classmates who have engineering and programming backgrounds. They taught me to persist when programming. If something doesn’t work, try again. Console.log, Google, Stackoverflow, talk out the syntax out loud are all options I practice on a daily basis these days. But when…… Continue reading Learning When to Stop

Image paths – Check. The realization my master Excel workbook (merged from multiple workbooks with multiple sheets) had a sort order different from the workbook with my image paths? Roadblock. What I thought would be a simple copy entire column A from workbook 1 (all image file paths) to column B in workbook 2 (empty…… Continue reading Match Image File Paths to Image IDs Across Excel Sheets

Note: I’m a graduate student at the University of Miami working on my capstone, a visualization of the Pictures of the Year International Archives. If you’re curious about my process, here are my posts tagged with capstone. Keep in mind, I’m learning as I go so I’m more than all ears for more efficient solutions.…… Continue reading Use R to Extract Thousands of Image File Paths and Write to CSV

This is one of the search phrases I used to figure out an efficient way to add the image paths from the thousands of images I have from the POYi archives to an Excel sheet. I searched for any combination of the following: “hyperlink to photographs”“URL”“batch processing”“image file paths” It is always hard and slightly…… Continue reading How to Add Links to Images to an Excel Sheet

From Wikipedia: Data wrangling, sometimes referred to as data munging, is the process of transforming and mapping data from one “raw” data form into another format with the intent of making it more appropriate and valuable for a variety of downstream purposes such as analytics. A data wrangler is a person who performs these transformation…… Continue reading Learning How to Wrangle Data with R