Converting a Nested List into a Pandas DF

Question

I have a list that looks like this:

['2016-01-05', '2017-02-03', '2018-01-25', ['File_2016.csv', 'File_2017.csv', 'File_2018.csv']]

Which is an output of a user entered field, and the partition of the data, where the first set of items ('2016-01-05', '2017-02-03', '2018-01-25') are the user entered fields, and the second set ('File_2016.csv', 'File_2017.csv', 'File_2018.csv') are the corresponding files.

What I'd like to do is create a dataframe that looks like this:

Date             File
2016-01-05      File_2016.csv
2017-02-03      File_2017.csv
2018-01-25      File_2018.csv

My code looks like this:

my_list = [input('enter the start date for file %s: ' % i) for i in list(filenames)]

Where filenames is a list of the Files above, and I append filenames to the list after the above user inputs.

Is there a better way to do this?

Thank you!

Peter Leimbigler · Accepted Answer · 2018-05-22 22:08:56Z

3

Not sure if this is better than what you've got now, but here's another way of doing it:

df = pd.DataFrame(list(zip(l[:-1], l[-1])), columns=['Date', 'File'])
df
         Date           File
0  2016-01-05  File_2016.csv
1  2017-02-03  File_2017.csv
2  2018-01-25  File_2018.csv

answered May 22, 2018 at 22:08

Peter Leimbigler

11.1k1 gold badge27 silver badges39 bronze badges

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

1 Comment

Julia Over a year ago

That is perfect. Thank you!!

Collectives™ on Stack Overflow

Converting a Nested List into a Pandas DF

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related