摘要:
import pandas as pd import matplotlib.pyplot as plt from scipy.stats import linregress if __name__ == '__main__': pd.options.display.max_columns = 999 阅读全文
摘要:
import pandas as pd if __name__ == '__main__': page_1 = pd.read_excel("C:/Users/18124/Desktop/pandas/027_行操作/Students.xlsx", sheet_name="Page_001") pa 阅读全文
摘要:
import pandas as pd import pyodbc import sqlalchemy if __name__ == '__main__': # 方法一 connection = pyodbc.connect("driver={sql server}; server=(local); 阅读全文
摘要:
/* 时间:2020/02/17 功能: 一 安装注意 二 安装过程 三 验证成功 */ 一 安装注意 /* 1 关闭安全类软件: 如杀毒软件 2 优先选择开发版: 《cn_sql_server_2012_developer_edition_with_sp1_x64_dvd_1234492》 */ 阅读全文
摘要:
import pandas as pd if __name__ == '__main__': pd.options.display.max_columns = 999 Videos = pd.read_excel("C:/Users/18124/Desktop/pandas/021_旋转数据表/Vi 阅读全文
摘要:
import pandas as pd import numpy as np if __name__ == '__main__': pd.options.display.max_columns = 999 orders = pd.read_excel("C:/Users/18124/Desktop/ 阅读全文
摘要:
import pandas as pd if __name__ == '__main__': student = pd.read_excel("C:/Users/18124/Desktop/pandas/019_求和_求平均_统计引导/Students.xlsx", \ engine="openpy 阅读全文
摘要:
import pandas as pd # 校验函数 : 校验数据; 校验数据关系 # 校验结果 : run; excel def score_validation(row): # 方法一 try: assert 0 <= row.Score <= 100 except: print(f"#{row 阅读全文
摘要:
''' 散点图: 1 下图房屋面积(sqft_basement)与价格关系(price) 直方图: 1 下图房子集中在什么价位 2 下图面积集中在什么面积 密度图: 1 下图房子多大概率70w ''' import pandas as pd import matplotlib.pyplot as p 阅读全文
摘要:
import pandas as pd import matplotlib.pyplot as plt if __name__ == '__main__': weeks = pd.read_excel("C:/Users/123/Desktop/pandas/013_折线趋势图_叠加区域图/Orde 阅读全文
摘要:
import pandas as pd import matplotlib.pyplot as plt if __name__ == '__main__': student = pd.read_excel("C:/Users/123/Desktop/pandas/012_饼图/Students.xl 阅读全文
摘要:
import pandas as pd import matplotlib.pyplot as plt if __name__ == '__main__': students = pd.read_excel("C:/Users/123/Desktop/pandas/010_叠加柱状图_水平柱状图/S 阅读全文
摘要:
import pandas as pd import numpy as np def get_circumcircle_area(l, h): r = np.sqrt(l**2 + h**2) / 2 return r**2 * np.pi def warapper(row): result = g 阅读全文
摘要:
import pandas as pd import numpy as np if __name__ == '__main__': page_1 = pd.read_excel("C:/Users/18124/Desktop/pandas/027_行操作/Students.xlsx", sheet_ 阅读全文
摘要:
import pandas as pd import seaborn as sns # 表示数值大小 - 背景颜色深浅 color_map = sns.light_palette("green", as_cmap=True) students = pd.read_excel("C:/Users/18 阅读全文
摘要:
import pandas as pd # 标记 - 不及格 def low_score_read(s): if s < 60: color = "red" else: color = "black" return f"color:{color}" # 标记 - 最高分 def highest_sc 阅读全文
摘要:
import pandas as pd if __name__ == '__main__': # 读取文件 : csv - , student_s1 = pd.read_csv("C:/Users/18124/Desktop/pandas/022_读取CSV_TSV_TXT文件中的数据/Studen 阅读全文
摘要:
import pandas as pd if __name__ == '__main__': student = pd.read_excel("C:/Users/18124/Desktop/pandas/020_定位_消除重复数据/副本Students_Duplicates.xlsx", \ eng 阅读全文
摘要:
import pandas as pd if __name__ == '__main__': employees = pd.read_excel("C:/Users/18124/Desktop/pandas/018_一列数据分割两列/Employees.xlsx") print(employees) 阅读全文
摘要:
import pandas as pd if __name__ == '__main__': pd.options.display.max_columns = 777 students = pd.read_excel("C:/Users/123/Desktop/pandas/016_多表联合/Stu 阅读全文