pandas

Question 1

read from trash

Answer 1

df=pd.read_clipboard()

Question 2

no aparezcan los titulos de las tablas

Answer 2

df1=pd.read_excel(ruta,header=None)

Question 3

drop COLUMN

Answer 3

df.drop([“column 1”,”column 2”],axis=1)

Question 4

drop ROW

Answer 4

df.drop(0)
df.drop ([1,20]) # delete only a row // you cant delete more

Question 5

iloc

Answer 5

df.iloc[0] // df.iloc[[0]]
df.iloc[0:10]
df.iloc[0:3,0:2]

Question 6

delete index

Answer 6

b.reset_index(drop=True) //

Question 7

concatenar tablas

Answer 7

pd.concat([table1,table2,table3])
pd.concat([table1,table2,table3],ignore_index=True) # ignore index

Question 8

save document

Answer 8

name_table.to_excel(“new route.xlsx”)
name_table.to_excel(“new route.xlsx”, index=False) # ignore index

Question 9

open document

Answer 9

import xlwings as sw
sw.Book(“book.xlsx”)

Question 10

python built in functions
# pd.pivot_table()
# dt=xw.view(“sadfsadjfl.xlsx”)
#grafico=td.plot(kind=”bar”)