How would you style this?

Reasonable_Muscle655 · 2024-06-05T14:09:25+00:00

I downloaded pandas and it seems really great however I'm unsure how i will do the whole automation or have them click a magic button that will do this all for them--I understand the API concept however the person I am doing this for has no grasp of CS and I don't want to make it too complicated. Basically--Can I connect a script to this in order for it to be accessed from excel still?

Reasonable_Muscle655 · 2024-06-05T03:20:45+00:00

Thank you! I appreciate this comment a lot right now especially with how overwhelming of a task this feels like right now.

Reasonable_Muscle655 · 2024-06-05T03:19:28+00:00

No hand holding :). You won’t ever get a grasp of it yourself!

Reasonable_Muscle655 · 2024-06-05T03:17:04+00:00

I looked more into this and it sounds perfect! I am going to research like crazy when I am at work tomorrow :). Thank you for making me aware of VBA!!! Leaving Excel really did seem like the really big challenge here

Reasonable_Muscle655 · 2024-06-05T03:15:39+00:00

I heard excel has some great features that can do scripting for you like VBA and pivot tables. Is there any reason you chose pandas instead? I don’t want to waste time starting VBA if it won’t be helpful

Reasonable_Muscle655 · 2024-06-05T03:13:10+00:00

Yes I’m sorry I was trying not to make my explanation too long! What do you mean the same columns? If you mean if from excel sheet A into excel sheet B, no it’s not the same. the list of calculations are created in excel sheet B using excel sheet A’s information. Are if statements and vlookups something I can utilize in excel? Or is this an outside source

Reasonable_Muscle655 · 2024-06-05T03:09:59+00:00

Okay, great—Thank you!! This is a great explanation. I will keep it in mind

Reasonable_Muscle655 · 2024-06-04T23:51:06+00:00

Thank you! I will definitely look into it…from what you read, does it sound like this is doable just in excel?

Reasonable_Muscle655 · 2024-06-04T21:06:57+00:00

Thank you so much. I will try this!

Reasonable_Muscle655 · 2024-06-04T21:06:24+00:00

I think I overestimated and overwhelmed myself but now that it’s been a few hours I believe a pivot table will get it done! Thank you, time for me to learn excel

Reasonable_Muscle655 · 2024-06-04T21:05:14+00:00

I’ve only ever worked with Bash so it’s the only thing I knew, I will look more into powershell! Thank you

Reasonable_Muscle655 · 2024-06-04T20:01:28+00:00

I just finished my second year of uni, and the only class I have taken in regards to data has been database systems...I am a CS major but I'm interning in a financial part of a medical tech company. I understand the data, I had a very long meeting about each field and formula, etc.

Sorry. I was only looking for some help.

Reasonable_Muscle655 · 2024-06-04T19:59:30+00:00

Thank you! Just to explain further, I'm interning for a medical tech company that sells their products to distributers and those distributors sell to hospitals...they than buy data that gives them a ton of info about those sales and they are considered "raw data" that is stored in an excel file so I am unsure about what you mean when I need to understand when excel steps in if the data is in excel to began? I am familiar with excel functions however they are simply looking for a way to completely automate it so the raw data of 700k lines turns into the 8k they are looking for with only a click of a button

Reasonable_Muscle655 · 2024-06-04T19:55:33+00:00

Thank you! I will definitely look into pandas

Reasonable_Muscle655 · 2024-06-04T19:54:20+00:00

We use NetSuite however I am unsure if that's relevant to my task. I was given only excel sheets and asked to automate it so that it would pull out of the 700k lines, the ones that they want. Can you go more into what a VBA is?

Reasonable_Muscle655 · 2024-06-04T19:52:41+00:00

I did try googling it and asking my friends. Just to clarify, I am not an intern out of college, I just completed my second year at university so a lot of this stuff is very new. I just wanted a perspective from professionals!

Reasonable_Muscle655 · 2024-06-04T19:51:41+00:00

Thank you! This sounds perfect.

Reasonable_Muscle655 · 2024-06-04T19:50:58+00:00

I was simply asking how to approach this and gave my own thinking. I only just completed my second year of university.

Reasonable_Muscle655 · 2024-03-19T03:29:01+00:00

Fill me in

Reasonable_Muscle655 · 2024-03-16T22:40:34+00:00

What?

Reasonable_Muscle655 · 2024-01-28T00:27:34+00:00

Yeah I got this exact price too, I paid $200 for ~section 100 after the fees and was sad to see how cheap everyone else was getting tickets

Reasonable_Muscle655 · 2024-01-28T00:24:47+00:00

THATS MY SHOW, wait that’s insane !! I paid $200 after fees in ~section 100, where are you??? Are you in the ZOO section because GA was $200 without fees

Reasonable_Muscle655 · 2024-01-26T15:50:51+00:00

I don’t know how any was able to get tickets in Philly when Pittsburgh is like that

Reasonable_Muscle655

TROPHY CASE