All generations.
def pasar_a_excel(df, nombre):
writer = pd.ExcelWriter(nombre, engine='xlsxwriter')
df.to_excel(writer, 'Sheet1')
df.to_excel(writer, 'Sheet2')
writer.save()
import pandas as pd
df = pd.read_excel('../dummy_data/dummy.xlsx')
len(df)
df.head(5)
df_1 = df.loc[0:90000]
df_2 = df.loc[90000:]
df_1.to_excel("../dummy_data/df_1.xlsx", index = False)
df_2.to_excel("../dummy_data/df_2.xlsx", index = False)
def filter_column(dataframe, columna, tipo_dato):
return dataframe.loc[dataframe[columna].apply(type) == tipo_dato]
import pandas as pd
writer = pd.ExcelWriter('output.xlsx',engine='xlsxwriter')
df1.to_excel(writer,sheet_name='Sheet_name_1')
df2.to_excel(writer,sheet_name='Sheet_name_2')
writer.save()
import pandas as pd
def leer_excel(ruta):
return pd.read_excel(ruta)
ruta = 'C:\Users\admin\Desktop\Python-Course\data\data.xlsx'
leer_excel(ruta)
import pandas as pd
# Create a Pandas dataframe from the data.
df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')
# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Sheet1')
# Close the Pandas Excel writer and output the Excel file.
writer.save()
#
df2 = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
df2.to_excel(writer, sheet_name='Sheet2')
# Close the Pandas Excel writer and output the Excel file.
writer.save()
import pandas as pd
df=pd.read_csv('/Users/carlos/Desktop/input.csv')
def divide_data():
return 'data_1', 'data_2'
def read_excel(filename=None):
#filename = './HW1_data.xlsx'
df = pd.read_excel(filename).dropna()
df.columns = ['country', 'population', 'area', 'density']
return df
df = read_excel()
df2 = read_excel('./HW1_data2.xlsx')
pickle.dump(df, open("database.pkl", "wb"))
export_excel = df.to_excel (r'Path where you want to store the exported excel file\File Name.xlsx', index = None, header=True) #Don't forget to add '.xlsx' at the end of the path
import pandas as pd
data = pd.read_excel('file.xlsx')
import pandas as pd
location = "datasets/smallgradesh.csv"
df = pd.read_csv(location)
df.head()
def create_excel_file():
print("crear archivo de excel")
def read_fwf(file_path):
return pd.read_fwf(file_path, header=None)
read_fwf('/Users/myname/Desktop/file.txt')
import pandas as pd
data = pd.read_csv('base_de_datos.csv')
data[data.columns[:5]].to_excel("hoja1.xlsx")
data[data.columns[5:]].to_excel("hoja2.xlsx")
Generate
More than just a code generator. A tool that helps you with a wide range of tasks. All in one place.
Function from Description
Text Description to SQL Command
Translate Languages
Generate HTML from Description
Code to Explanation
Fix invalid Code
Get Test for Code
Class from Description
Regex from Description
Regex to Explanation
Git Command from Description
Linux Command
Function from Docstring
Add typing to code
Get Language from Code
Time complexity
CSS from Description
Meta Tags from Description
