Welcome to python-forum.io

Results

Search Results

Post

Author

Forum

Replies

Views

Posted [asc]

Thread: How to use the excel filename as a value to populate new column, using Pandas?
Post: RE: How to use the excel filename as a value to po...

I'll try to get started with what I know and post some sample code. Thanks.

Dequanharrison

Data Science

6,500

Jun-26-2019, 11:11 PM

Thread: How to use the excel filename as a value to populate new column, using Pandas?
Post: RE: How to use the excel filename as a value to po...

Not looking to create a datadrame with 50 columns, but rather end up with 50 dataframes/Excel files woth the additional new "date" column filled with the filename of the original file. Saved as a CSV...

Dequanharrison

Data Science

6,500

Jun-26-2019, 04:28 PM

Thread: How to use the excel filename as a value to populate new column, using Pandas?
Post: RE: How to use the excel filename as a value to po...

Thanks, but maybe I didn't explain it very well. I have 50 Excel files with a naming sequence of 012018 CBA, 022018 CBA, 032018 CBA, 042018 CBA, etc. For each file, I want to use the first 6 digits of...

Dequanharrison

Data Science

6,500

Jun-26-2019, 10:32 AM

Thread: How to use the excel filename as a value to populate new column, using Pandas?
Post: How to use the excel filename as a value to popula...

I'm new to Python. I have about 50 excel workbooks that all have different names e.g. 012018 CBA, 022018 CBA, etc. For each, I would like to insert a new column called "Date" and use the first 6 digit...

Dequanharrison

Data Science

6,500

Jun-25-2019, 10:07 PM

Thread: Manipulating Excel with Python.
Post: RE: Manipulating Excel with Python.

Import win32com.client will allow you to write VBA within Python. Check out sigma coding Youtube channel.

Dequanharrison

General Coding Help

3,633

Jun-25-2019, 01:57 AM

Results

User Panel Messages

Announcements