Cải thiện bài viết
Lưu bài viết
Cải thiện bài viết
Lưu bài viết
Đọc
Algorithm:
- Bàn luận
- Hãy cho chúng tôi xem làm thế nào để xuất một gấu trúc DataFrame sang một tệp excel. & Nbsp;
- Tạo DataFrame.to_excel[] function with the file name to export the DataFrame.
Xác định tên của tệp Excel.
Python3
Gọi đến chức năng_excel [] với tên tệp để xuất DataFrame.
Ví dụ 1:
import
1import
2
DataFrame is written to Excel File successfully.0
import
4DataFrame is written to Excel File successfully.2
import
6DataFrame is written to Excel File successfully.0
import
8DataFrame is written to Excel File successfully.2
pandas as pd
0DataFrame is written to Excel File successfully.0
pandas as pd
2import
0import
pandas as pd
marks_data
7marks_data
8: {
0
DataFrame is written to Excel File successfully.0
=
2DataFrame is written to Excel File successfully.2
DataFrame is written to Excel File successfully.3
DataFrame is written to Excel File successfully.0
=
6import
0=
8
DataFrame is written to Excel File successfully.7
DataFrame is written to Excel File successfully.0
pd.DataFrame[{
1DataFrame is written to Excel File successfully.2
import
2DataFrame is written to Excel File successfully.0
pd.DataFrame[{
5import
0=
8import
6
DataFrame is written to Excel File successfully.0
'ID'
0DataFrame is written to Excel File successfully.2
pandas as pd
0DataFrame is written to Excel File successfully.0
'ID'
4import
0=
8pandas as pd
5
DataFrame is written to Excel File successfully.0
'ID'
9DataFrame is written to Excel File successfully.2
pandas as pd
9DataFrame is written to Excel File successfully.0
: {
3import
0Các
Các
DataFrame is written to Excel File successfully.09
import
6DataFrame is written to Excel File successfully.0
marks_data
1DataFrame is written to Excel File successfully.2
pandas as pd
0DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.16
DataFrame is written to Excel File successfully.2
pandas as pd
5DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.20
DataFrame is written to Excel File successfully.2
pandas as pd
9DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.24
import
0DataFrame is written to Excel File successfully.09
marks_data
3DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.29
marks_data
6marks_data
7
DataFrame is written to Excel File successfully.32
: {
0
DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.36
DataFrame is written to Excel File successfully.2
DataFrame is written to Excel File successfully.3
DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.40
DataFrame is written to Excel File successfully.2
DataFrame is written to Excel File successfully.7
DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.44
DataFrame is written to Excel File successfully.2
import
2DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.48
import
0DataFrame is written to Excel File successfully.09
import
6DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.53
DataFrame is written to Excel File successfully.2
pandas as pd
0DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.48
DataFrame is written to Excel File successfully.2
pandas as pd
5DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.40
DataFrame is written to Excel File successfully.2
pandas as pd
9DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.36
import
0=
8marks_data
3
DataFrame is written to Excel File successfully.0
: {
8 marks_data
6Các
DataFrame is written to Excel File successfully.75
DataFrame is written to Excel File successfully.76
DataFrame is written to Excel File successfully.77
DataFrame is written to Excel File successfully.78
DataFrame is written to Excel File successfully.79
Output:
DataFrame is written to Excel File successfully.
DataFrame is written to Excel File successfully.09
marks_data
3DataFrame is written to Excel File successfully.0
DataFrame is written to Excel File successfully.36
DataFrame is written to Excel File successfully.71
DataFrame is written to Excel File successfully.
72=
DataFrame is written to Excel File successfully.
74We can also first use the ExcelWriter[] method to save it.
Python3
Gọi đến chức năng_excel [] với tên tệp để xuất DataFrame.
Ví dụ 1:
=
8
DataFrame is written to Excel File successfully.94
DataFrame is written to Excel File successfully.2
DataFrame is written to Excel File successfully.96
DataFrame is written to Excel File successfully.97
marks_data
7
DataFrame is written to Excel File successfully.99
DataFrame is written to Excel File successfully.86
import
01DataFrame is written to Excel File successfully.2
import
03DataFrame is written to Excel File successfully.2
import
05DataFrame is written to Excel File successfully.2
import
07DataFrame is written to Excel File successfully.2
import
09DataFrame is written to Excel File successfully.97
marks_data
7import
12
DataFrame is written to Excel File successfully.86
import
14DataFrame is written to Excel File successfully.2
import
16DataFrame is written to Excel File successfully.2
import
18DataFrame is written to Excel File successfully.92
DataFrame is written to Excel File successfully.09
import
21DataFrame is written to Excel File successfully.2
import
23import
24import
pandas as pd
import
30
import
31
Các
Output:
DataFrame is written to Excel File successfully.