Konvertieren Sie Pandas in Excel
Contents
[
Hide
]
Mit Aspose.Cells for Python via .NET API können Sie Pandas DataFrame in Excel, OpenOffice, PDF, Json und viele verschiedene Formate konvertieren.
Konvertieren Sie Pandas DataFrame über JSON-Daten in Excel
Hier ist ein Beispiel-Codeausschnitt, der zeigt, wie man Daten aus einem Pandas-DataFrame in eine Excel-Datei mit Aspose.Cells for Python via .NET importiert:
- Erstellen Sie Beispieldaten für Pandas DataFrame.
- Verwenden Sie die Pandas-Bibliothek, um die DataFrame-Daten in JSON-Daten zu konvertieren.
- Importieren Sie JSON-Daten mit Aspose.Cells for Python via .NET.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import pandas as pd | |
from aspose.cells.utility import JsonUtility, JsonLayoutOptions | |
from aspose.cells import Workbook, Worksheet, Cells | |
# Create a sample pandas DataFrame | |
data = {'Name': ['Alice', 'Bob', 'Charlie'], | |
'Age': [25, 30, 35], | |
'City': ['New York', 'San Francisco', 'Los Angeles']} | |
df = pd.DataFrame(data) | |
# Convert pandas DataFrame to JSON | |
json_string = df.to_json(orient='records') | |
workbook = Workbook() | |
# Get the first worksheet | |
worksheet = workbook.worksheets[0] | |
# Get the cells | |
cells = worksheet.cells | |
options = JsonLayoutOptions() | |
unit = JsonUtility() | |
# Processes as table. | |
options.array_as_table = True | |
unit.import_data(json_string, cells, 0, 0, options) | |
workbook.save("out.xlsx") |
Konvertieren Sie Pandas DataFrame direkt in Excel
Hier ist ein Beispiel-Codeausschnitt, der zeigt, wie man Daten aus einem Pandas-DataFrame in eine Excel-Datei mit Aspose.Cells for Python via .NET importiert:
- Erstellen Sie Beispieldaten für Pandas DataFrame.
- Durchlaufen Sie DataFrame und importieren Sie Daten mit Aspose.Cells for Python via .NET.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import pandas as pd | |
import aspose.cells | |
from aspose.cells import Workbook, CellsHelper, License | |
workbook = Workbook() | |
# Get the first worksheet | |
worksheet = workbook.worksheets[0] | |
# Get the cells | |
cells = worksheet.cells | |
# create a sample DataFrame | |
data = {'name': ['Alice', 'Bob', 'Charlie', 'David'], | |
'age': [25, 32, 18, 47], | |
'city': ['New York', 'Paris', 'London', 'Berlin']} | |
df = pd.DataFrame(data) | |
rowindex = 0 | |
colindex = 0 | |
for column in df: | |
cell = cells.get(rowindex, colindex) | |
cell.put_value(df[column].name) | |
colindex += 1 | |
for index, row in df.iterrows(): | |
rowindex += 1 | |
colindex = 0 | |
cell = cells.get(rowindex, colindex) | |
cell.put_value(row["name"]) | |
colindex += 1 | |
cell = cells.get(rowindex, colindex) | |
cell.put_value(row["age"]) | |
colindex += 1 | |
cell = cells.get(rowindex, colindex) | |
cell.put_value(row["city"]) | |
colindex += 1 | |
workbook.save("out.xlsx") |