I could use some help walking through this: I have Excel data that means more or less depending on where it comes from. When I'm working with it, presenting it, or thinking about it, I want to treat it differently depending on origin. Example within. [more inside]
I'm trying to make sure that I'm covered if my SSD drive goes kaput. [more inside]
Issues with iPhone 6 with Sprint, Eastern USA, major metro area. [more inside]
I have over a hundred vintage sewing patterns (and about half again as many modern ones) and a fabric stash sufficient to make at least 2/3 of the patterns. I am looking for some sort of cataloging option. I'm using Excel, but it does not handle pictures well (right now, each pattern has a link to its page--assuming it has one--at vintagepatterns.wikia.com, but fabric swatches are not really archived online) and I'd like a system that's both visual and descriptive. [more inside]
I'm looking for a whimsical large data set. Something bizarrely specific, or just an area you'd never guess there was that much to measure. For example, the amount of materials used by the Teddy Bear industry or the shifting volume of animal feces at major zoos. I've been searching through the many big data set sites to no avail. The ideal set would contain around a million nodes and, if relational, a few hundred thousand connections. A factor of ten either way would be reasonable though.
I'm off to Germany in a few weeks and would like to ensure that I have available data there. What's the best way for a UK person to have a gigabyte or so mobile data for a week in Germany? [more inside]
When you are receiving updates to data or a project in rapid and unpredictable fashion, how do you keep track of these changes? [more inside]
Please give me some suggestions on a prepaid sim card (unlocked iPhone 5s) for a three month trip to Europe, based out of Germany. I need 1-2 gigs of LTE data per month and hope not to be gouged while roaming in a few other countries. Specific company suggestions would be much appreciated! [more inside]
I need a cloud storage service and I know just enough to be overwhelmed. Halp? [more inside]
I've been doing a little bit of data-wrangling at work and I've found that I enjoy it and I'm pretty good at it. What sort of jobs and training should I be researching to get out of jobs with 'admin' in the title and into more focused, longer-term work in data analysis and possibly GIS? [more inside]
Two American couples, in Europe for about a month, wondering how to optimize our cell phone coverage for the trip. What should we do in general, calling and datawise? And what is the best way for at least one person from each couple to have the best wikipedia/yelp/etc. access while we're out and about during the trip? [more inside]
I have one hard drive with some important documents on it and I'm looking to protect these contents in the event of theft. What's the best (not too difficult) way to do this? I'm on Apple OS.
I'm looking for some help cutting through the mix of crap that Google throws up and finding some quality free (or very inexpensive) resources for learning the statistical programming language R. [more inside]
What is the current best way to have a cloud backup of family pictures & videos, shared among a family? Bonus points for files besides pictures. [more inside]
I get a daily report of activity from a set of items and I want to make a automatically-updating summary sheet (I'm fine doing this in Excel, Google Sheets, or Apple Numbers). [more inside]
What tools would you recommend for creating a dynamic relationship visualisation? Thinking along the lines of They Rule. [more inside]
Is it possible in excel to create a formula that says "if a value in this column is in this range of numbers, put label x in a different column." [more inside]
I have a massive data set, 45 to 60 years of 5 different sets with each one needs several different sorting. Good automation of this would be great. [more inside]
Up until two weeks ago I had an iPhone4 and a 1GB data plan, which was just fine for what I do, namely browsing Metafilter and the New York Times. Suddenly upon acquiring a new iPhone 6, I somehow began using large amounts of data. I've already had to upgrade to a 4GB plan in order to avoid extra charges. What happened? [more inside]
Let's say someone has gotten access to your full name, date of birth, city of birth, and signature. Can someone commit fraud with these pieces of information, and if so, how? If not, I'm wondering what else they might try to get. I'm concerned I might be at risk for fraud because someone has snooped around and gotten the above data about me and I just got a bad feeling about them.
I received a box of Scotch Brand MC/ST 530 Magnetic Cards. There is probably data on them. How, if possible, do I retrieve it? [more inside]
I've got a 2011 MBP that I'd like to prep for sale. It's still running Snow Leopard (and I don't have the boot disks.) What's the easiest, most idiot-proof way to wipe it clean so I can sell it? Is it worth going to the Apple Store for this sort of thing?
I'm developing a training resource for a client and the brief requires me to provide some spreadsheets that summarise employment data for a small fictitious company. The spreadsheets must have one row per employee. I want to populate the rows as if the spreadsheet has already been sorted, for example by grouping employees by age, and then randomise the rows so students are given spreadsheets where there is no row by row pattern to the data, for example as if employees had been entered in alphabetical order. [more inside]
What's the best source to automatically pull data specific to companies, including industry, size, location, public/private, etc.? [more inside]
This seems like an obvious question but the internet is being surprisingly non-informative and what information I can find seems to be several years old. I will be travelling for about 1 month. I have a totally unlocked iPhone 6s purchased in the UK. Can I walk into a store in the US when I arrive, buy a pre-paid nano sim with a data allowance, and stick it in my phone and use it? [more inside]
know it's been asked before, but these things change constantly. I'm on a 3G plan with ATT but end up going over every month so I pay ~108 a month for nothing special. I want an iPhone 6s (not negotiable for the purpose of this post, so no Google network or whatever), solid coverage, and good international data for various travels. Does anyone have a suggestion? [more inside]
I'm a programmer with interests in game dev, data analysis and data science. It seems to me that A/B testing would be a cool thing to implement for playtesting games, along with data on in-game choices, playtime and satisfaction rankings. Is there an application/library/suite/engine that already does this? Is it free and/or open source? Or could this be a fun, albeit super-long, project for me to work on?
How can I make Excel datasets look nice without too much mucking about? [more inside]
I'm on a grandfathered unlimited data plan on Verizon. I use <1GB of data a month, and I'm paying $90/mo for it. I should go to an MVNO, right? Help me wade through the details. [more inside]
Phone screen with a social justice-oriented nonprofit next week... yay! I have never actually worked for a nonprofit full-time and it's been years since I've interned for one. I would welcome ideas on aspects to run toward/away from. [more inside]
I have a decent number of 10+ year old CD-Rs and DVD-Rs, and a few of them have started to go south. I'd like to pull off as much of the data as possible, even if it means an audio glitch or a corrupted bit of an image here and there. (Where at the moment, the OS X Finder just gives up and I don't get any part of the damaged file at all.) Is there an app or technique you would suggest for this purpose? [more inside]
Dear MeFi mechanical engineers: In the back of my car's owners manual are the engine's HP/torque/BSFC curves (god bless those data-loving Germans). Will the overall fuel economy always be optimized at the lowest point on the BSFC curve? With the gearing and wheel diameter, this point works out to be 84mph. That can't be right, right?
I have an opportunity to assist on a research project, but my background isn't very data-y. [more inside]
I'm looking for examples of well-designed scientific figures. As a materials scientist I've encountered many horrendous figures that are difficult to understand and read. I've read about collaborations between graphic design and physical science departments, which yield much more attractive and informative figures, but these examples are few and far between. I'm hoping to apply principles from good graphic design and data visualization to my own work. Are there any resources or websites where I can learn more about this?
Working on a project and I need a list of all (or a lot) of the bridges in the United States. [more inside]
I collect a lot of data about myself. I want to aggregate all this stuff in one place for personal use. [more inside]
Excel 2013 - I have no explanation for this chart behavior. Do you? [more inside]
Is there a service that pulls pictures and videos from a bunch of old phones, laptops & Macbooks? [more inside]
I've got a web page of static content that I need to make sortable by multiple columns. Essentially, it's a calendar that has these columns: date, location, event. I need to put this information onto a simple, fast-loading web page in such a fashion that I can have a primary method of sorting and then also sort things in a secondary and/or tertiary way within those results. [more inside]
I have recently picked up a couple gigs wiring small businesses. Thus discovering that cat6 and even cat5e cable and keystones are expensive. Where do you get yours? [more inside]
What is 150GB equivalent to, in terms of "things in the world"? I need a simple comparison that will help people visualize what that amount of data amounts to. [more inside]
I volunteer at an NGO that provides legal aid to asylum seekers. I'm trying to create graphs that will help us better visualize the population we serve and perhaps make connections that we haven't before. Our data points are: age, sex, nationality, arrival date in our service, length of asylum procedure, and outcome of procedure (refusal or acceptance). We have this information from every person who has used our service. What interesting and useful things can I do with this data? [more inside]
I just got an invite for the new OnePlus One X phone, and I have three days to decide. Per this article, the phone uses AT&T's HSPA network, which results in slower downloads and uploads than LTE. However, I use Cricket Wireless which is slow anyway. Would I notice the difference?
I have a rather extensive (read: physically burdensome) library of books I'd collected over the years that I'd like to digitize to take with me as I move on to my next adventure. I'm wondering what the best (most efficient, reliable, and economically efficient) way is to digitally preserve a large library of books as PDFs. I'm especially concerned to prevent files from becoming corrupted over time. [more inside]
Where do English majors go to learn key principles behind deriving mathematically sound meaning from data? I worked for years as a digital editor. Now I'm a "content strategist," which means I'm responsible for proving my new strategy increases reader engagement via different metrics like UVs, shares, attention time, average story finish rate, etc. I'm very familiar with platforms like Google Analytics and Chartbeat. But I want to learn how to see patterns in them there numbers, and I NEED to make sure my insights are mathematically accurate. How can I most efficiently do that without getting a brain transplant? (Example below.) [more inside]
I have a CSV with one column that contains User IDs. I need to make another CSV that counts how many times each User ID appears in the document, and output it to another CSV That has something like UID1 >> 3; UID4 >> 1; UID20 >> 0. There are thousands of User IDs, so I need to be able to set up a range for it to scan for. Is this possible with free software and not much programming expertise? [more inside]
How much wired data does a family of two adults and two teenagers use? [more inside]
I need to find out accurate information showing the quantity of university/tertiary/higher education students and lecturers, by age, for Australia and internationally. [more inside]
How do I get the x-axis labels on my Google Sheets-generated histogram to be centered under the bars? [more inside]
Other than disabling Google Drive and software updates, how do I limit downloads to only the stuff I want? [more inside]