🔒 Extract data from messy excel file.

[viral surge]

@polar ember

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[polar ember]

Hello,

I am a python newbie who started learning last week, I am trying to extract data from my broker’s multiple contract note with multiple sheets into a single csv file.

One file has multiple sheets for every day a trade happened.

Single table with multiple sections for different type of trades. I want to make it into a single csv file with different sections in a new column.

For now I have got it like this. But I want to

How can I do that? What should I read about? Honestly I am stuck at even what questions to google or read about.

[bitter canopy]

Hi can you Share Google Sheet Link with me?

@polar ember

[south creek]

@polar ember pandas can read excel https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html

[polar ember]

@bitter canopy sure here it is https://docs.google.com/spreadsheets/d/1bOTU9gUDwa5aXK5YQHnmUlNu_OyQ1BLQrkasgnLxQRs/edit?usp=sharing

[polar ember]

That's what I am doing making it a dataframe

[bitter canopy]

@polar ember you want arrange this data

[polar ember]

Yes @bitter canopy

[bitter canopy]

can you explain me Step by Step

[polar ember]

In the order no. column there is NSE-F&O I want that to be added in a new column for next rows till NSE-EQ starts. and then the next rows will be marked with with NSE-EQ in new column till BSE-EQ starts and repeat.

[bitter canopy]

Where is Category Colume?

[polar ember]

Like this

[polar ember]

I have to create a new column

[bitter canopy]

Can i give you suggestion

[polar ember]

Yes please

That's why I am here

[bitter canopy]

First you make a new Sheet with proper Data i means your current sheet many unwanted things exits so make a Proper Sheet I not Say you to original sheet but add Proper Trader name rege number digit only

[polar ember]

Privacy for the person I am doing this for.

This might be sensitive data

But the original file is exactly like this.

[bitter canopy]

I know But You make a Example Sheet like Not use them person Detail but you add some random detail like name choose wrong person not exitist name reg. no use 5564651643 random number

See this: https://docs.google.com/spreadsheets/d/1m6GtVjeV6GBGLKIOsXtDb2_E63zQ020gDyJ2MTa8-QE/edit?usp=sharing

[polar ember]

Okay

[bitter canopy]

you see this Google Sheet and Make this type Sheet so any developer easily understand and help

[polar ember]

Thanks I will dothat

[bitter canopy]

When I saw it for the first time, I thought that I should help, but I also thought that I would need help in the future.

So how do I feel if someone does not help me?

So now you arrange Sheet and After Meassage me

Thank U

[polar ember]

Hey @bitter canopy here is the sample file, this is the close to the actual data. https://docs.google.com/spreadsheets/d/1U31zgQHPMsU4bSxFCgUD42EqEuCUaYhbbefWLap0gEk/edit?usp=sharing

[bitter canopy]

oky

ok

this data you arrange

[polar ember]

Yes

[viral surge]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.