Pretty new in my current role, about 3 months, and wanted to clean up some our large data spreadsheet. I heard python integration can help do this with a script but I’ve never used it and don’t know what it can do or how it would help. Does anyone have experience with it? What do you use it for?

likesmart
Posting as :
works at
You are currently posting as works at

If you have an immediate need, Power Query can be learned much quicker than Python. Go on YouTube or Udemy, then start practicing.

like

Bumping this - agreed

You can perform a number of mass excel tasks with Python, but you need to learn how to code in Python. Stack overflow is a good resource for this, but googling/ChatGPT will also provide solid solutions. Depends on your current knowledge of Python and libraries.

like

While Python can certainly work for what you want to do, it might be worth using PowerQuery instead as it's probably more accessible in the near term. Long term, Python is a great skill to have.

like

Definitely needs to take the time to learn python

Based on your question, you're probably best not using a python script. Just manually clean up your spreadsheet.

Related Posts

Opinion on the Milton (Cambridge high) vs Suwannee (Peachtree ridge high) to buy a house? Have a 3 yr old.

like

Hi what is an acceptable salary range for an associate director in biotech( +10 y experience)

like

What is the maximum salary PepsiCo offers to their Associate manager for finance process ?

If you could change anything about the tax system what would if be? If to simplify, how so exactly?

like

Finally built my mining rig. Feels pretty god damn good. Reps till I'm out.

like

When does the firm start matching contributions to 401k?

like
like

I’m work Operations for ML and am looking at Investment Banking roles at ML in New York, any advice when applying that could help me?

anyone know where to buy disposable cameras for cheap ?

like

Hello Fishes,

I recently had a interview call with TCS technical team and the interview went well. HR asked to upload my documents in ibegin portal. But they are yet to contact me for my salary negotiation it's been three weeks since, can i know how much can I expect as compensation?

YoE :8.5 years
Current CTC: 14 LPA
Skills : information security
New salary ask :30 LPA
No other offer in hand

Hello! I have been in the job search for around 2 months and have had successful interview rounds, yet as an international student with OPT, this has become a factor not to secure several positions. Any advice moving forward or how to leverage my OPT ??

Thanks!!

like

Made it to the on-site round for a Sales S&O interview. However, both of the interviewers are Managing Directors of Sales. I thought they would be other S&O managers. How would this affect interview questions (e.g would GCA case studies be sales focused?) how can I best prepare for this given a lack of a sales background.

like

What does the pay range look like for a UX/UI Design Intern?
Background: Master’s in CS student based in NYC/NJ.

like

How does everyone feel about the online SHRM learning for SHRM-CP and SHRM-SCP for Certification?
Do you skip around? Do you follow the path? Where does one start?

like

I am rebuilding an internal function and would love to understand what minimum benchmarks everyone is using for their teams. What outputs are good and exceptional e.g reachouts to conversion, placements , SLA, average time to fill

like

Hi fishes,

I got a offer of 26lpa(23.5 fixed and 2.5 variable) from genpact and 21 lpa (20 fixed , 1 joining) from epam, not sure which one should I join. Please if someone can advice me which i should join keeping ressession in mind. Thanks in advance

I hope this is still a living bowl.

likeupliftingfunny

Leaving this here

Post Photo
funnylike

Men’s hair style/ facial hair, and interviewing at Big4 poll:
1. Ok to have longer hair
2. Only medium/short hair is professional
3. Trimmed beard & mustache ok
4. Only mustache ok
5. Long beards ok
6. Clean shaven only
7. Hair style/facial hair have no relevance

Additional Posts in Excel Genius

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Would anyone be willing to teach me vlookup?

like

How do you fix microsoft excel cannot paste data error?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal