Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,ask:3,meta:2,projects:5,jobs:5,music:6,irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this?
[more inside]
posted by iamkimiam
on Sep 21, 2012 -
7 answers
How would you describe music like this, and can you recommend more like it? Kind of dreamy vocals and swelling strings, old-fashioned mid-20th-century feeling.
Example 1: The children's chorus from the opening to Night of the Hunter, starting about 32 seconds into
this video.
Example 2: Walt Kelly's "Willow the Wasp", 30 second sample
on amazon.
posted by moonmilk
on Jul 15, 2012 -
8 answers
Is there a name for those conspiracy maps that are so often shown in movies and TV shows? You know, the ones on cork board, with photos and index cards connected with strings.
posted by Uppity Pigeon #2
on Apr 6, 2012 -
6 answers
I was just given a 12-chord autoharp, not in great shape. How do I figure out if it's worth salvaging, and if so, what are some good resources for learning to play?
[more inside]
posted by valleys
on Oct 4, 2011 -
12 answers
Learning to play acoustic guitar: Should I wean myself off looking at the strings/fretboard while practising chords, or will this naturally come later?
[more inside]
posted by cranberrymonger
on Nov 15, 2010 -
19 answers
When I try to tune a stringed instrument (guitar, uke, autoharp), the B string always sounds off to me, no matter what I do. Why?
[more inside]
posted by Beardman
on Oct 8, 2010 -
10 answers
Should we hire a string trio or string quartet to play at our wedding (immediately pre-ceremony and during the reception)? I have no idea what difference, if any, the extra violin would make to the sound or the range of music that can be played, though I do have an idea of the difference in cost ($170-350). Is it worth it? (Bonus points if you can suggest pieces of music.)
posted by Dasein
on Apr 26, 2010 -
14 answers
I have two large (10k-100k) sets of strings. I want to match the items in the sets up in pairs based on similarity. Levenshtein looks promising but costly.
[more inside]
posted by chairface
on Feb 12, 2010 -
15 answers
Ukulele players: Is this a more finger-friendly instrument than the guitar?
[more inside]
posted by bryon
on Jan 20, 2010 -
14 answers
I want to listen to luscious old (pre 90s) music that sounds fresh and as if it could have been recorded and released today (in terms of production values, instrumentation, orchestration, etc.) Can you recommend some?
[more inside]
posted by wackybrit
on Jan 8, 2010 -
20 answers
Where should I buy high-quality acoustic guitar strings online? Also, suggestions for brands of strings?
[more inside]
posted by crookedgrin
on Oct 6, 2009 -
7 answers
I bought my partner a cheapie guitar, but fretting its strings is incredibly uncomfortable compared with my own cheapie guitar (with the same light gauge strings). What could be causing the difference, and how do I fix it?
[more inside]
posted by hayvac
on Apr 29, 2009 -
18 answers
Two questions regarding getting my acoustic guitar strings replaced at the local music shop.
[more inside]
posted by gtr
on Nov 5, 2008 -
12 answers
Can anyone recommend a cello teacher in Toronto, for an adult amateur new to cello but not to strings?
[more inside]
posted by mendel
on Sep 1, 2008 -
1 answer
Bass player. Long time pizzicato, first time arco. What do I need to know about my bow, specifically regarding rosin?
[more inside]
posted by gnutron
on Mar 17, 2008 -
14 answers
Help me identify this mystery track from my friends' mix CD, that he can't recall either. No sample available, yet! It's more than likely a movie score track. Cross between
1941, Elfman, Zimmer,
Willow, and involves kazoos in places.
[more inside]
posted by vanoakenfold
on Nov 26, 2007 -
12 answers
How and why cables/strings/hoses/lines/cords etc. become entangled? Is there any scientific explanation of the process and more generally a science studying the physical/topological properties and behaviour of string materials?
[more inside]
posted by elgilito
on Aug 27, 2007 -
6 answers
What is the piece of music used at 12:29 in the Neill Blomkamp short "Tempbot," at around 12:29? (link to the short movie within)
[more inside]
posted by lonemantis
on Jul 19, 2007 -
4 answers
Guitar Filter: Has anyone ever miked nylon strings (on an acoustic or solid body) and put it through a distortion box and/or an overdrive box? How does it sound? Pleasant or not? Does anyone know if any professional musician has experimented with that?
posted by jak68
on Jul 11, 2007 -
19 answers
Guitar Filter: On a 6 string electric guitar playing blues or rock, have you ever strung the same gauge on all three lower strings and the same gauge on all three upper strings? What did it sound like, and did you like it? How about the playability?
[more inside]
posted by jak68
on Jun 28, 2007 -
17 answers
Guitar tuning through harmonics: Could you fine fine folks explain the physical/mathematical principles behind the increased "distortion" as two guitar strings being tuned through harmonics approach being tuned?
[more inside]
posted by poweredbybeard
on May 19, 2007 -
24 answers
I'm looking for good resources for upright bass DIY education—especially regarding bowing basics and other physical/form questions.
[more inside]
posted by cortex
on May 4, 2007 -
14 answers
Two questions concerning violins (and by extension, other string instruments):
1. Mass production!
2. Strads!
[more inside]
posted by archagon
on Apr 27, 2007 -
14 answers
Help me clear up all the guitar stringing advice I've received. Should you remove all the strings from your guitar and then add the new ones, or change the strings one-by-one?
[more inside]
posted by beammeup4
on Feb 9, 2006 -
22 answers
Has anyone seen a non-Konfabulator Windows Start Menu replacement that allows the user to enter the names of programs to run?
[more inside]
posted by yclipse
on Jan 30, 2006 -
13 answers
I need some music reccomendations. I really enjoy instrumental string music, but have no idea who some of the really good performers are. In particular, I like the style presented in the theme song to "Angel" by
Darling Violetta, where strings are mixed with a modern rock sound.
So can anyone reccommend some good artists/albums to check out?
posted by aclevername
on Dec 21, 2004 -
7 answers
Jacob ter Veldhuis'
String Quartets, as far as I can tell, have been recorded only
once. That label doesn't seem to have any current contact information. I'd like to get my hands on this, and tried a bunch of the local options here in San Francisco, including Amoeba. Is there a secret place on the internet like alibris.com for books where one can go find relatively obscure Dutch string quartets?
posted by judith
on Nov 14, 2004 -
9 answers
Guitar pickers - what kind of strings do you prefer for your acoustic and more important, what kind of string treatment do you use? (more...)
[more inside]
posted by jabo
on Feb 20, 2004 -
6 answers