# Pandas玩转Excel-Python数据分析轻松学示例代码
## Contents
* [1 - 创建文件](1-CreateExcel/CreateExcel.py)
* [2 - 读取文件](2-ReadExcel/ReadExcel.py)
* [3 - 行、列、单元格](3-Rows&Clumns&Cell/Rows&Clumns&Cell.py)
* [4&5 - 数据区域的读取，填充整数、文字,填充日期序列](4%265-ReadData&BaseInput/ReadData&BaseInput.py)
* [6 - 函数填充](6-InputFunction/InputFunction.py)
* [7 - 排序，多重排序](7-Sequence/Sequence.py)
* [8 - 数据筛选、过滤](8-DataFiltering/DataFiltering.py)
* [9 - 柱状图](9-Histogram/Histogram.py)
* [10 - 绘制分组柱图，深度优化图表](10-GroupedHistogran&DepthOptimizationChart/GroupedHistogran&DepthOptimizationChart.py)
* [11 - 绘制分组柱图，深度优化图表](11-SuperimposedHistogram&HorizontalHistogram/SuperimposedHistogram&HorizontalHistogram.py)
* [12 - 绘制饼图](12-PieChart/PieChart.py)
* [13 - 绘制折线趋势图、叠加区域图](13-PolylineTrendChart&OverlayAreaMap/PolylineTrendChart&OverlayAreaMap.py)
* [14&15 - 散点图，直方图，密度图，·密度图，数据相关性](14%2615-ScatterPlot&Histogram&DensityMap/ScatterPlot&Histogram&DensityMap.py)
* [16 - 多表联合（Join）](16-Join/Join.py)
* [17 - 数据校验，轴的概念](17-DataValidation/DataValidation.py)
* [18 - 把一列数据分割成两列](18-DataSegmentation/DataSegmentation.py)
* [19 - 求和，求平均，统计导引](19-Statistics/Statistics.py)
* [20 - 定位、消除重复数据](20-DuplicateData/DuplicateData.py)
* [21 - 定位、旋转数据表（行/列转换）](21-RotateDataSet/RotateDataSet.py)
* [22 - 读取CSV、TSV、TXT文件中的数据](22-ReadData/ReadData.py)
* [23 - 透视表，分组，聚合（group by）](23-GroupBy/GroupBy.py)
* [24 - 线性回归，数据预测](24-DataPrediction/DataPrediction.py)
* [25 - 条件格式化（上）](25%2626-ConditionalFormatting/ConditionalFormatting01.py)
* [26 - 条件格式化（下）](25%2626-ConditionalFormatting/ConditionalFormatting02.py)
* [27 - 行操作集锦](27-RowOperation/RowOperation.py)
* [28 - 列操作集锦](28-ColOperation/ColOperation.py)
* [29 - 读取数据库](29-ReadDataBase/ReadDataBase.py)
* [30 - 编写复杂方程](30-WritingComplexEquations/WritingComplexEquations.py)
Pandas玩转Excel-Python数据分析轻松学示例代码.zip
需积分: 0 101 浏览量
2024-01-08
22:32:27
上传
评论
收藏 7.29MB ZIP 举报
Pandas玩转Excel-Python数据分析轻松学示例代码.zip （69个子文件） 
Pandas玩转Excel-Python数据分析轻松学示例代码 
.editorconfig 148B 27-RowOperation 
Students.xlsx 11KB RowOperation.py 2KB 21-RotateDataSet Videos.xlsx 10KB RotateDataSet.py 425B 11-SuperimposedHistogram&HorizontalHistogram SuperimposedHistogram&HorizontalHistogram.py 644B Users.xlsx 10KB 18-DataSegmentation Employees.xlsx 10KB DataSegmentation.py 822B 12-PieChart Students.xlsx 12KB PieChart.py 518B _config.yml 26B .github workflows blank.yml 764B 7-Sequence Sequence.py 827B List.xlsx 10KB 9-Histogram Students.xlsx 10KB Histogram.py 835B
Figure_1.png 41KB 28-ColOperation Students.xlsx 11KB ColOperation.py 1KB 19-Statistics Students.xlsx 11KB Statistics.py 908B 29-ReadDataBase ReadDataBase.py 823B 20-DuplicateData Students_Duplicates.xlsx 11KB DuplicateData.py 642B .idea vcs.xml 180B workspace.xml 37KB misc.xml 205B PandasVersusExcel.iml 451B modules.xml 286B 6-InputFunction InputFunction.py 780B Books.xlsx 9KB 25&26-ConditionalFormatting ConditionalFormatting02.ipynb 27KB Students.xlsx 11KB ConditionalFormatting02.py 881B .gitignore 39B ConditionalFormatting01.ipynb 28KB ConditionalFormatting01.py 840B 17-DataValidation DataValidation.py 814B Students.xlsx 10KB 16-Join Student_Score.xlsx 11KB Join.py 1KB 23-GroupBy GroupBy.py 725B Orders.xlsx 5.29MB 10-GroupedHistogran&DepthOptimizationChart GroupedHistogran&DepthOptimizationChart.py 762B Students.xlsx 10KB 13-PolylineTrendChart&OverlayAreaMap PolylineTrendChart&OverlayAreaMap.py 766B Orders.xlsx 14KB 2-ReadExcel ReadExcel.py 1KB People.xlsx 631KB 14&15-ScatterPlot&Histogram&DensityMap home_data.xlsx 1.21MB ScatterPlot&Histogram&DensityMap.py 716B 4&5-ReadData&BaseInput Books_output.xlsx 6KB Books.xlsx 9KB ReadData&BaseInput.py 1KB 3-Rows&Clumns&Cell Rows&Clumns&Cell.py 586B 24-DataPrediction DataPrediction.py 1KB Sales.xlsx 10KB 22-ReadData Students.tsv 384B
Students.txt 384B ReadData.py 586B Students.csv 384B 8-DataFiltering DataFiltering.py 1KB Students.xlsx 10KB 30-WritingComplexEquations WritingComplexEquations.py 712B Rectangles.xlsx 10KB README.md 2KB 1-CreateExcel output.xlsx 5KB CreateExcel.py 498B资源评论
