Factual.com has data about cosmetic products and their ingredients, and it would be just what I need, except that the vast majority of the products listed are North American. I'm in the UK, and have tried searching for 65 products by UPC code; I found only 6 of them. Does anybody know of an equivalent site with data for UK products, that has an API for automated queries? [more inside]
How can I better track specific parts of my life with an app or spreadsheet? [more inside]
I'm writing a piece of software to go through a very large database and format last names in their correct casing (i.e., smith or SMITH or sMith to Smith.) However, I'm obviously aware some names should be kept as lowercase—but what names? [more inside]
I'm getting paid per unit rather than per hour and I think I need to re-negotiate the terms. But what do I need to ask for? [more inside]
I've been handed a massive chunk of open-ended survey data. I have a short time frame to work with it--just a few days--and I would appreciate advice on ways to analyze or mine what I have beyond the most basic approach I know for this kind of thing. Exciting details inside! [more inside]
How can I combine these two tabs of data in Excel using VLOOKUP and/or some other function? [more inside]
I'm in academia. Two related questions: 1) Can you recommend readings, forums, programs, and tools under the broad heading, "data analysis?" 2) And, what's the next job I should be looking for? [more inside]
The SSD in my Macbook Pro seems to have completely failed. I managed to install OS X onto an external drive and attempted to run DiskWarrior on it. It took almost 24 hours and in the end was not able to repair the disk. It did allow me to mount the disk as read-only, but I'm not able to copy and save 90% of the files. Is there some Windows or Linux based software I could try that might be more thorough or effective? [more inside]
I am currently a public high school teacher teaching science and would very much like to transition into data and policy analytics, with a particular bent on computer programming and economic analysis. What are ways I can transition into these fields. One thing I have found that is a fellowship program from Education Pioneers. Are there other resources like this? What routes would you advise that I take? More information inside [more inside]
Is it possible to get monthly or yearly data on the volume of incoming and outgoing mail from each US post office? [more inside]
I plugged my iPhone in to my computer and it says you need to upgrade your software. So the phone was updating to iOS 8.1.1 and it errored out. It says upgrading failed, you need to restore to factory setting and you will lose all the data. So I tried to upgrade again and it failed again. I took it to the geniuses at the apple store and they said there is no hope of recovering my data. Does the hive mind know of a way??
Just booked my int'l flight by way of Denver a little under 24 hours ago. Could anyone help me get empirical data (at least a prior probability) of flights to and fro DEN cancelled or severely delayed, compared against ones in and out of SFO around this time of year? I'm slightly concerned about my flight into DEN potentially snowed in, and wanted to get a better sense if it's worth switching to an alternative flight to the same destination via SFO on the ~same day. Thanks a lot!
I am working on SAS and the National Survey of Children's Health. I am trying to look at data just for the state of Massachusetts, and even after looking in the codebook I cannot figure out what the variable is to stratify by MA. I do not have SAS on my home computer and am looking to download this, any experience, is it just like the regular SAS? thanks http://www.sas.com/en_us/software/university-edition.html
I need help with gmail functionality. I need to figure out how many(ish) extra hours I generally work. I think an easy way to capture part of this is to check out the volume of email sent outside of my working hours. Is there a reasonably easy way to do this? [more inside]
Help maximize my small data allowance! [more inside]
Going on a loooong boat trip on one of the cruise lines in a few months. What's the current deal for taking my electronics through the inspections? [Previously from 2009] [more inside]
I'm looking for a tool to visualize activity in a network (e.g. people sending emails to each other or planes moving between airports). [more inside]
post-herald.com looks sort of like a newspaper site but has only one story, about Mike Tyson. The same domain hosts thousands of thousands of stories like "Kathleen Herald misses out on Powerball prize." Change the numbers in the URL and you'll see different people's names and cities of residence. I assume these names and cities are scraped from a database somewhere. But why do this? [more inside]
In my last question, I asked for algorithms that changed the world. Now I'd like to know, what are the data structures that changed the world? [more inside]
I am searching for a live traffic flow counter which is on the net and reachable by http, or some webpage that displays hourly or cumulative vehicle statistics. [more inside]
I'm helping an admin figure out how to grab links from an RSS feed that she can then repackage into an email, along with other content she'll add. What's the best way to do this? Skill level: novice [more inside]
I have some data, it happens to be medically-oriented but that's probably not too important. How can I structure it? It appears to be intrinsically hierarchical, but the hierarchy can be organised in various ways. Is there a design pattern for this problem? [more inside]
I've found a lot of folks that promise the opposite. What I want to do is take a csv of lat/long pairs and get back something pairing them with the corresponding city and state. (I'd even take zip codes if it came to that bit that would be somewhat less useful). Is this something easily done?
Facebook has a way to archive/download your data. However, last time I did that, I noticed that it didn't include any comments that friends had made on my posts or any of the pictures I was tagged in (that had been posted by other people), and probably a few other things in a similar vein. Is there an automated way to save those things? Perhaps a third-party product or app of some sort?
I have 4g data on my note 3 here in Australia, using yatango as my service provider. After about 20 minutes of usage of browsing web on my phone, the 4g stops working (the download signal of data stops lighting up and nothing loads) and the only way to fix it is for me to "turn off mobile data" then turn it back on, fixes it every time. Why does it stop working and how can I fix it so I don't have to turn off and then back on mobile data every 20 minutes?
This is my first year in public health. I am writing a report describing data trends and prevalence rates regarding maternal and child health issues. I am trying to be a little creative in my writing. I feel as though I keep restating the same phrases, "the rate was", "a higher percentage of Asian women" , etc. Any tips on writing about data? For example, one in 4 children, one in ten women, etc. Any resources you can point me to in this type of writing? Basically, writing about numbers and data for the non-mathematically minded :)
My wife has an iPhone 4 on a market rate plan. I have an iPhone 5 with both a grandfathered unlimited plan and a discount through my employer. Together, we fight crime. No, wait, we look for bargains on our cell plans. Can you help us figure out what's the best plan or combination of plans for us, and how actually to upgrade to iPhone 6? [more inside]
Is there an online resource that reports on lyrical content for popular music? [more inside]
I'm trying to find all the areas of the US that have my ideal climate, and I'd like to do so by playing with data. Is there an app, site, or method that can help? (Or can you?) [more inside]
Let's say I need to send some personal data (e.g., full name, DOB, SSN, address history, etc.). I already know I should never transmit that information via email, but why? What are the risks, and where and when do they occur? At what point(s) during transmission is the info in that email in danger? Hit me with every worse-case scenario you can think of. [more inside]
I accidentally ran up my phone bill to $1100. I want to know what I can say, if anything, to try to lower my bill. [more inside]
I will be traveling for 10 days in Germany (2 days), Denmark (2 days), and Sweden (6 days) at the end of this month. Voice and texting is relatively unimportant, but I do need data for maps, keeping in touch with my traveling companions, etc. What's the best way to do this, given that I'm in Greece at the moment and need the SIM card by Friday? [more inside]
I grabbed a bunch of posts off of a vBulletin forum to analyze for a research project (with permission, of course, from the forums and the users and my IRB), and I've got it all cleaned up and ready to go. I've got thousands of files in .xls (Microsoft Excel 97-2003) format. So far, so good. Now how do I get these files into a format that my analysis software will play with nicely? [more inside]
I need to get hold of datasets for online purchases, more specifically those that include product returns for a (self funded) project I'm working on. [more inside]
I'll be in Vancouver and the surrounding area next week. What's the best way for me to get data on my cellphone? Something like a prepaid mobile SIM card tied to a data plan. Just relying on wifi isn't an option as half of the time I won't be in the city. [more inside]
Can anyone suggest a good service to store data offsite, for long-term secure storage? This is as opposed to, say, minute-to-minute backups of your hard drive. [more inside]
I have thousands of records of variable length from which I need to remove the last four digits. This seems like it should be an easy job for Python, but I keep hitting a wall. [more inside]
I read a study online somewhere that physically abusive men on average wait three years before escalating to physical violence. Does anyone know the study, and can you give me a link? [more inside]
I'm based in the UK and will be spending a week somewhere that has no broadband. The reception on most networks seems to be changeable though it's strongest on Vodafone. Is there a 3G/4G wireless router that can take multiple SIM cards or dongles so that I can connect together more than one network and thus maximise my chances of getting connectivity?
I need help finding a quote from a novel, likely from a William Gibson novel, regarding how a person generates data throughout their lives. [more inside]
I'd like to compile a list of businesses in New York City—starting with Manhattan—that have been around for 100 years or more. I'd also like to include places the public can visit that aren't "businesses" per se. I'm guessing this information is publicly available, but I don't know where to start. Any guidance would be extremely helpful. Thanks!
I'd like to have a list of every US Supreme Court decision ever, including which justices voted how. I'd like the list to be easily parsable by a computer program. Details and alternatively acceptable things inside. [more inside]
I want to work with a tech company working on the design of data centers! I am very interested in the heat transfer, efficiency, environmental impacts and general mechanical design that goes into data centers. I have a few connections to a couple of the big tech companies here in Seattle and don't want to waste my opportunity. How should I shape my resume and what skills should I highlight? [more inside]
My son is going on a three-week school trip to several countries in Europe about a month. I'd like to either buy a SIM for his (out of contract, unlocked) iPhone 4s, or direct him to buy one in London, at the airport, when he lands. I'm specifically looking for decent voice rates to the US, some international texting, and data to include an available network of WiFi. [more inside]
Can anyone recommend a hard drive / data recovery service near Baltimore? Or failing that, a non-local one / a non-spammy explanation of how to find such a service that is reputable and not too expensive? Perhaps a sign of the times, but google is really being unhelpful, and mostly giving me fake local ones that seem to be aiming to SEO-trick people who are doing the obvious searches into thinking they're actually local. [more inside]
I just received a huge cellphone bill due to excessive data usage. I checked my iPhone's cellular data usage, and the IFTTT app has used 7.5GB (yes, gigabytes) of data in the last month. WTF! [more inside]
I've always backed my files on CDs and DVDs, but a few years back I decided to go for external hard disks because they seemed more practical. I would love to get SSD external hard disks, but they are very expensive. I'm currently looking at cloud-based backup solutions but I don't really know where to find something of quality that is private and relatively cheap. Any ideas? [more inside]
External HD crashed, what next? What do do before sending it to a recovery service? [more inside]
I am taking my iPhone to Europe and want to use it wifi-only. I use StraightTalk as a provider. Is there anything in particular I should know before I go? [more inside]
I am plotting a trip to a part of the US with poor internet and bad cell coverage. One location where I will be staying shows as within AT&T's 4G LTE data service area. A recent trip to SF demonstrated some limitations of my current cell data plan, which is Straight Talk month-to-month (sublease on AT&T network, shows signs of being stepped on by AT&T in terms of speed and responsiveness for data). Straight Talk excludes tethering altogether and has a non-4G data puck available. Given my negative experience with ST data in SF, I am looking askance at the ST puck. [more inside]