how to provide file name to excel using python dataset?

Question

Newbie here. I have 3 columns in my data. I am exporting the data to an excel and the file name needs to include all the 3 column names in it. Using dataframe and dataset here.
Ex- ProjectNo-Area-Division.
The problem is Area is 3 digits. Some areas are '000', '010', '020', '01A'
If i use the below line

file_name = final_dataframe['PROJECT NUMBER'].unique()[0] + '-' + str(final_dataframe['AREA'].unique()[0]) + '-' + str(dataset['DIVISION'].unique()[0]) + '.xlsx'

file_name = ProjectNo-0-DIVISION ProjectNo-10-DIVISION
ProjectNo-20-DIVISION
ProjectNo-01A-DIVISION respectively.
How can I get all 3 digits in the file name, irrespective of being 0. TIA

thanks. i tried the same and it worked

nandy
– nandy

2020-06-19 15:53:01 +00:00
Commented Jun 19, 2020 at 15:53 — nandy
– nandy, Commented Jun 19, 2020 at 15:53

Dallan · Accepted Answer · 2020-06-18 14:02:07Z

1

When you convert your areas to strings, the integer ones are losing their leading zeros. You can add them back using zfill:

file_name = final_dataframe['PROJECT NUMBER'].unique()[0] + '-' + str(final_dataframe['AREA'].unique()[0]).zfill(3) + '-' + str(dataset['DIVISION'].unique()[0]) + '.xlsx'

answered Jun 18, 2020 at 14:02

Dallan

5164 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to provide file name to excel using python dataset?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related