Reputation
Top tag
Next privilege 5 Rep.
Participate in meta
Badges
6
Newest
 Tumbleweed
Impact
~484 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Apr
6
awarded  Tumbleweed
Mar
30
asked Control Multi Monitor content per monitor, nvidia card
Sep
24
awarded  Autobiographer
Mar
3
awarded  Scholar
Mar
3
comment Transpose data at particular row w python,r,sql?
Frank, oh sorry I just got it now, and did it. I still cant give rep though :(
Mar
3
accepted Transpose data at particular row w python,r,sql?
Feb
27
comment Transpose data at particular row w python,r,sql?
Frank, wow man You nailed it. I still cant give rep but if you post an address of wished altcoin Id be glad to make a reward!
Feb
20
revised Transpose data at particular row w python,r,sql?
added 36 characters in body
Feb
20
comment Transpose data at particular row w python,r,sql?
Frank, yes, it will always start on A, and it will always end on X lets say (I've updated question again to make it more clear), but in between can be various stuff. But You sequence is correct now. Sorry if my original question was confusing.
Feb
18
revised Transpose data at particular row w python,r,sql?
added 7 characters in body
Feb
18
comment Transpose data at particular row w python,r,sql?
Frank, I think I am not following, because since 1st solution is ideal if You add F to the list of letters at the end(meaning dynamic range), the code breaks. And this is kind of data I have, first 4, then 7, then 9, then 4, then 6.. and so on. I've edited the question to make it more clear. Sorry if i wasn't.
Feb
18
awarded  Commentator
Feb
18
comment Transpose data at particular row w python,r,sql?
@nixda, nixda, thank You. But my data is dynamic in range, sometimes 4, sometimes 6.
Feb
18
comment Transpose data at particular row w python,r,sql?
Frank, thank you for effort. Ill try to dynamically figure out the length and then pass it to function. If You happen to figure out idea, how to do it based on specific string rather than number, I would be most thankful.
Feb
16
comment Transpose data at particular row w python,r,sql?
Wow, Frank, thank You so much. Its very helpful, however the only problem is that You've fixed ncol at 5, is there any way to make it dynamic and based on a string/number? Because data does not follow exact pattern.
Jan
21
comment Transpose data at particular row w python,r,sql?
Its csv so it can be anything, its one column, and many rows.
Jan
21
comment Transpose data at particular row w python,r,sql?
I've tried with Wrangler, but couldn't complete the whole dataset on it superuser.com/questions/695336/…
Jan
20
asked Transpose data at particular row w python,r,sql?
Dec
31
comment Stanford Wrangler ideal, but imposes limits, what are other options?
Above is 1 record, and I have 50k of those. File is in txt, and I want it in csv, wraped and transposed at each beginning of record. Wrangler wraps/transposes data at specific line.
Dec
31
asked Stanford Wrangler ideal, but imposes limits, what are other options?