小丸子头又很大了-CSDN博客

原创计算复杂列

import pandas as pdimport numpy as npdef get_circumcircle_area(l, h): r = np.sqrt(l ** 2 + h ** 2) / 2 return r ** 2 * np.pidef wrapper(row): return get_circumcircle_area(row['Length'], row['Height'])rects = pd.read_excel('D:/Code/.vs

2021-04-13 22:46:15 132 1

原创列操作汇总

import pandas as pdimport numpy as nppage_001=pd.read_excel('D:/Code/.vscode/Students.xlsx',sheet_name='Page_001')page_002=pd.read_excel('D:/Code/.vscode/Students.xlsx',sheet_name='Page_002')students = pd.concat([page_001,page_002],axis=1)#并排放在一起pri

2021-04-12 23:01:39 124

原创行操作汇总-增加/修改/删除/筛选删除行数据

import pandas as pdfrom pandas._libs import missingpage_001 = pd.read_excel("",sheet_name="")page_002 = pd.read_excel("",sheet_name="")students = page_001.append(page_002).reset_index(drop=True)print(students)#可以将两张表上下拼接起来,reset 放弃原来的indexstu = p

2021-04-08 23:40:13 229

原创拟合线性方程分析预测

import pandas as pdimport matplotlib.pyplot as pltsales = pd.read_excel('D:/Code/.vscode/Sales.xlsx',dtype={'Month':str})print(sales)plt.bar(sales.index,sales.Revenue)plt.title('Sales')plt.xticks(sales.index,sales.Month,rotation=90)plt.tight_layou

2021-04-01 23:56:53 363 1

原创数据透视表/分组/聚合

import pandas as pdimport numpy as nppd.options.display.max_columns = 999orders = pd.read_excel('D:/Code/.vscode/Orders.xlsx')orders['Year'] = pd.DatetimeIndex(orders.Date).yeargroups = orders.groupby(['Category','Year'])s = groups['Total'].sum()c

2021-03-31 22:04:09 292

原创导入CSV等文件

import pandas as pdstudents1 = pd.read_csv('D:/Code/.vscode/Students.csv',index_col='ID')print(students1)students2 = pd.read_csv('D:/Code/.vscode/Students.tsv',sep='\t',index_col='ID')print(students2)# students3 = pd.read_csv('D:/Code/.vscode/Studen

2021-03-31 20:41:13 387

原创 duplicate去除并且找出所有重复项

import pandas as pdstudents = pd.read_excel('D:/Code/.vscode/Students_Duplicates.xlsx')dupe = students.duplicated(subset='Name')dupe = dupe[dupe==True]print(students.iloc[dupe.index]) #找出打印重复项# students.drop_duplicates(subset='Name',inplace=True,k

2021-03-29 22:37:59 664 1

原创函数调用之SUM/mean

import pandas as pdstudents = pd.read_excel('D:/Code/.vscode/Students.xlsx',index_col='ID')temp = students[['Test_1','Test_2','Test_3']]row_sum = temp.sum(axis=1)row_mean = temp.mean(axis=1)students['Total'] = row_sumstudents['Average'] =row_meanco

2021-03-24 23:01:13 228

原创 split-数据分离

import pandas as pdemployees = pd.read_excel('D:/Code/.vscode/Employees.xlsx',index_col='ID')df = employees['Full Name'].str.split(expand=True) employees['First Name'] = df[0]employees['Last Name'] = df[1].str.upper()# print(df)print(employees)df

2021-03-24 22:01:35 127

原创数据验证-之ASSER-语法错误

import pandas as pddef score_valication(row): # try: # assert 0 <= row.Score <= 100 if not 0<row.Score<=100 # except: print(f'#{row.ID}\tstudent {row.Name} has an invalid score {row.Score}.')studen

2021-03-23 22:54:26 90

原创多表联合-JOIN MERGE

```pythonimport pandas as pd# students = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Students')# scores = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Scores')# table = students.merge(scores, how='left', on='ID').fillna(0)# ta.

2021-03-22 22:44:25 138

原创 Matplotlib 可视化之图形美化

import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel('D:/Code/.vscode/Students.xlsx')students.sort_values(by = '2017',inplace = True, ascending=False)print(students)students.plot.bar(x='From',y=['2016','2017'],color=['orange','

2021-03-20 23:28:36 275

原创 Matplotlib 数据可视化

import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel('D:/Code/.vscode/Students.xlsx')students.sort_values(by='Number',inplace=True,ascending=False)print(students)# students.plot.bar(x='Field',y='Number',color='orange',title= 'i

2021-03-18 23:59:25 122

原创 VBA之批量导出图片

`Sub Rename()Application.ScreenUpdating = FalseOn Error Resume NextMkDir ThisWorkbook.Path & “\图片”For Each pic In ActiveSheet.ShapesIf pic.Type = msoPicture ThenRN = pic.TopLeftCell.Offset(0, -1).Value '重命名图片pic.CopyWith ActiveShee

2021-03-18 17:00:37 1329

原创定义函数\排序\筛选

import pandas as pdbooks = pd.read_excel('D:/Code/.vscode/Books.xlsx',index_col='ID')# books['price'] = books['ListPrice'] * books['Discount']# for i in range(5,16): # books['Price'].at[i] = books['ListPrice'].at[i] * books['Discount'].at[i]

2021-03-17 23:44:20 149 1

原创自动填充序列文字日期-pandas

import pandas as pdfrom datetime import date,timedelta# books = pd.read_excel('D:\Code\.vscode\Books.xlsx')# print(books)def add_month(d,md): yd = md // 12 m = d.month + md % 12 if m != 12: yd += m// 12 m = m % 12 retur

2021-03-16 00:32:26 241 1

weixin_48660856的博客