(no subject)

[frenzy]

I have a few other things. but this is a bit more urgent. finally heard back about the job interview. They want me to build something from scratch as a "take home code assignment". Not just any thing though. I have to take some .jsons and parse data from it. This is pretty beyond what i got. god if this was MySQL this would be so fking easy. I was told to "not spend more than 2 hours on this" but lord knows i already have lol

I'm trying to figure out how to proceed here. I feel like I'm in way over my head. I am googling and ive pulled hte .json data into python but I keep getting an error when trying to pull specific information from the .json. I'mma keep googling and see if I can get past this. But, like,

what do I do?

1) tell the recruiter that I just cant do this

2) waste peoples time and come in with /something/.

3) something else?



In better news, I didn't have a panic attack about this. Which is wild. Proud of me.

Comments

[ioplokon]

Can you convert it to CSV? Or also, sometimes importing to RStudio makes it easier for me to handle bc I prefer data frames to jsons...

[frenzy]

I get two interviews, one where i get to ask questions for 15 minutes before i have to turn in what i have. so i'll definitely be asking that and maybe trying to attack this as a .csv or something.

[ioplokon]

Good luck!! Also, I believe jsons function as dictionaries in Python, if that helps at all? Sometimes for me the hardest part is actually just understanding how the data is structured.

[sabotabby]

Sounds like the company wants some free labour.

[frenzy]

I dont think so because 1) they definitely already have the tools that do this and 2) they specifically were like "please dont spend more than 2 hours on this". Of course i will spend way more than 2 hours on this, but idk. do I even want this at this point? I'm good at what im good at, but i'm not this good.

[symbioid]

Good job on no panic attack. don't give up. What's the error you get. Are you using a json parsing library? Did they give you an example json or tell you to use any random json?

Wish I saw this last night! Too busy playing bloodborne :(

LMK what you found, I'm curious. I still think, even if you give up on this particular job, you should still try it because I believe you can do it. Even if it's hard, you can, I know you can :)

And then it's like killing a boss in Bloodborne.

[frenzy]

they sent me a json file to pull in. i can print the data, but when i try to get anything specific, i keep getting

TypeError: list indices must be integers or slices, not str

I'm fucking trying i guess. hahaha.

[symbioid]

can you mail me the code? I'm curious symbioid@gmail.com.

(don't worry I won't do it for you and if you don't want "friendly advice" I won't offer, but I'm curious! and if you do want friendly advice of course I'll try to assist)


Are you using a library to parse it? Or are you doing it from scratch?

[frenzy]

I emailled you. dont do it for me tho! hahaha

[symbioid]

LOL I won't! But I did find a tip I can give:

lookup json.dumps - I think. I could be wrong but that appears to be the method used to pull the data out and "Dump" to a "S"string.

https://www.geeksforgeeks.org/json-dumps-in-python/
https://www.geeksforgeeks.org/json-dump-in-python/

[frenzy]

Yeah im p sure thats what I looked at to get me this far.

[frandroid]

You say you've pulled the JSON data into python--can you just return the top level of the object to see what's been pulled in?

[frenzy]

I can print the data, in its entirety, but if i try to grab a certain piece, or even just try to pull something in a position, i keep getting

TypeError: list indices must be integers or slices, not str

[symbioid]

It seems like maybe you're trying to read it as a list, not a dictionary (based on the above comment from iplokon) :

"jsons function as dictionaries in Python"

The error makes it sound like you're reading the JSON as a list, and since Python can display a whole object with print it'll render the entire object. IDK enough about JSON (which is why I asked to see your code).

It's been ages since I used Dict, I remember tuples use () and Lists use []. OK _ I had to look dicts use {} (I knew there was a different bracket type LOL)

Are you using something like jsonbobject["keyname"]
But you may need to use {} like : jsonobject{"keyname"}

Which indicates it's a dictionary and thus expecting a string.

Does this sound close to what's happening?

[frenzy]

I think so, although I dont know a lot about dictionaries yet, so I need to start googling that route.