Rozdělit do sloupců excel
Příklady kódu
Rozdělit sloupec hodnoty
# make string version of original column, call it 'col'
df['col'] = df['col1'].astype(str)
# make the new columns using string indexing
df['col1'] = df['col'].str[0:2]
df['col2'] = df['col'].str[2:4]
df['col3'] = df['col'].str[4:6]
# get rid of the extra variable (if you want)
df.drop('col', axis=1, inplace=True)
Rozdělení pd datovém do souborů aplikace excel založen na sloupci hodnota
import pandas as pd
data = pd.read_excel('anyexcelfile.xlsx', engine='openpyxl') # creates a dataframe called 'data'; pick any spreadsheet you can add paths to 'x:/folder/subfolder/anyexcelfile.xlsx' to be explict.
grouped = data.groupby("Column Header Name") # change "Column Header Name" to the name of the column needed to categorise or group the rows in the dataframe,
keys = grouped.groups.keys() #create a dictionary list of the each group unique varibles in the specifed column of the dataframe.
print(keys) #a cheeky debug to check it's working
for key in keys: #looping through each key
splitdf = grouped.get_group(key) # creating a temporary dataframe with only the values of the current key.
splitdf.to_excel(str(key)+".xlsx", engine='xlsxwriter') #write the temporary dataframe called 'splitdf' to an excel file named after the key. At the end of the loop the temporary dataframe 'splitdf' is overwritten for use with the next key.
Související stránky
Související stránky s příklady
V jiných jazycích
Tato stránka je v jiných jazycích
empty row
Русский
..................................................................................................................
English
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................
Populární v této kategorii
Oblíbené stránky s příklady v kategorii
empty row