# PandasVersusExcel

**Repository Path**: sweeneysw/PandasVersusExcel

## Basic Information

- **Project Name**: PandasVersusExcel
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-09-11
- **Last Updated**: 2021-09-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Learn pandas vs Excel(Python)


本笔记为 [Pandas玩转Excel - Python数据分析轻松学](http://sa.mentorx.net/course/89/tasks) 这门课程的学习笔记

## 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数据分析轻松学](http://sa.mentorx.net/course/89/notes) 讲师：[Timothy](http://sa.mentorx.net/user/25)