Align output data using Python Pandas

Question

I want to align and organized data on Output. I have an excel file which has 2 sheets - Students, Anime. I already extracted data on excel files but my problem now is the output. This is what i've tried

file = pd.read_excel("src/doc/x1/students.xlsx", sheet_name=None)
print(file)

Output:

{'Students':       Name        Major     Block
0     Alex     Business  20200525
1     Clay  Engineering  20200526
2  Justine      Science  20200527, 'Anime':      Anime Name             Author
0     One Piece       Eiichiro Oda
1        Naruto  Masashi Kishomoto
2  Dragon Balls     Akira Toriyama}

How do I remove the Brackets on each end and align data like this

    'Students':       Name        Major     Block
                0     Alex     Business  20200525
                1     Clay  Engineering  20200526
                2  Justine      Science  20200527 

    'Anime':        Anime Name          Author
             0     One Piece        Eiichiro Oda
             1     Naruto           Masashi Kishomoto
             2     Dragon Balls      Akira Toriyama

Your input data looks not aligned ? How does initial dataframe looks like ? — pyOliv
– pyOliv, Commented Jun 1, 2020 at 7:29

snatchysquid · Accepted Answer · 2020-06-01 07:52:57Z

1

Note that file is a dictionary where each key is the sheet's name and the value is the Dataframe from that sheet. you can use something like this and change the printing style to whatever you want:

for key, value in file.items():
    print(key + ":")
    print(value)

edited Jun 1, 2020 at 7:52

answered Jun 1, 2020 at 7:30

snatchysquid

1,38212 silver badges25 bronze badges

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

5 Comments

JBA Over a year ago

almost ok but i want to export this as text file. how do i combine the key and value on one text file if i do print(value,file = open("mytext.txt", "w"))

snatchysquid Over a year ago

When writing or reading from file please use with open(...) and then instead of printing just write it to the file

snatchysquid Over a year ago

visit this thread to find out how to write a df to a .txt file

JBA Over a year ago

I already output the Key and Value but I want to combine it on one text file. How can i do it

snatchysquid Over a year ago

visit the link I attached in the previous comment. It shows how to write a df into a .txt file. I am not sure if you can write all dataframes into one file together (if you can then great) but what you can do is write each dataframe into a temp .txt file, copy its content and write to the main .txt file from the temp one

Collectives™ on Stack Overflow

Align output data using Python Pandas

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related