书名如题,全书400多页,是一本Python跟SAS结合的书,数据科学工作者可以参考参考!!!
字节限制,部分目录如下:
Chapter 1: Why Python? ........................................................................................... 1
Setting Up a Python Environment ................................................................................................. 2
Anaconda3 Install Process for Windows ....................................................................................... 3
Troubleshooting Python Installation for Windows .................................................................... 9
Anaconda3 Install Process for Linux ........................................................................................... 13
Executing a Python Script on Windows ....................................................................................... 16
Case Sensitivity ........................................................................................................................... 19
Line Continuation Symbol ........................................................................................................... 19
Executing a Python Script on Linux ............................................................................................ 20
Integrated Development Environment (IDE) for Python ............................................................... 21
Jupyter Notebook ........................................................................................................................ 22
Jupyter Notebook for Linux ......................................................................................................... 24
Summary .................................................................................................................................... 25
Chapter 2: Python Types and Formatting ............................................................... 27
Numerics ..................................................................................................................................... 28
Python Operators ................................................................................................................... 30
Boolean ....................................................................................................................................... 31
Comparison Operators ........................................................................................................... 32
IN/NOT IN ............................................................................................................................... 37
AND/OR/NOT .......................................................................................................................... 38
Numerical Precision .................................................................................................................... 40
Strings ......................................................................................................................................... 44
String Slicing ......................................................................................................................... 47
Formatting ............................................................................................................................. 51
Summary .................................................................................................................................... 63
Chapter 3: pandas Library ...................................................................................... 65
Column Types .............................................................................................................................. 67
Series .......................................................................................................................................... 68
DataFrames ................................................................................................................................. 73
DataFrame Validation ............................................................................................................ 75
DataFrame Inspection ........................................................................................................... 78
Summary .................................................................................................................................. 109
Chapter 4: Indexing and GroupBy ......................................................................... 111
Create Index .............................................................................................................................. 112
Return Columns by Position ...................................................................................................... 114
Return Rows by Position ........................................................................................................... 117
Return Rows and Columns by Label ......................................................................................... 119
Conditionals ......................................................................................................................... 123
Updating .............................................................................................................................. 126
Return Rows and Columns by Position ..................................................................................... 128
MultiIndexing ............................................................................................................................ 131
Basic Subsets with MultiIndexes ......................................................................................... 137
Advanced Indexing with MultiIndexes ................................................................................. 141
Cross Sections ..................................................................................................................... 148
GroupBy .................................................................................................................................... 150
Iteration Over Groups ........................................................................................................... 155
GroupBy Summary Statistics ............................................................................................... 159
Filtering by Group ................................................................................................................ 161
Group by Column with Continuous Values ........................................................................... 162
Transform Based on Group Statistic .................................................................................... 165
Pivot .......................................................................................................................................... 168
Summary .................................................................................................................................. 176
Chapter 5: Data Management ............................................................................... 177
SAS Sort/Merge ........................................................................................................................ 181
Inner Join .................................................................................................................................. 184
Right Join .................................................................................................................................. 186
Left Join .................................................................................................................................... 189
Outer Join ................................................................................................................................. 191
Right Join Unmatched Keys ...................................................................................................... 192
Left Join Unmatched Keys ........................................................................................................ 195
Outer Join Unmatched Keys ...................................................................................................... 197
Validate Keys ........................................................ 200
Joining on an Index ................................................................................................................... 201
Join Key Column with an Index ...................................................................... 203
Update ....................................................................................................................................... 205
Conditional Update ......................................................................................... 209
Concatenation ........................................................................................................................... 213
Finding Column Min and Max Values ........................................................................................ 222
Sorting ...................................................................................................................................... 223
Finding Duplicates .................................................................................................................... 227
Dropping Duplicates .................................................................................................................. 228
Sampling ................................................................................................................................... 231
Convert Types ............................................................................................................................ 234
Rename Columns ...................................................................................................................... 235
Map Column Values ................................................................................... 235
Transpose ......................................................................................... 237
Summary .................................................................................................................................. 241
Chapter 6: pandas Readers and Writers ............................................................... 243
Reading .csv Files ..................................................................................................................... 244
Date Handling in .csv Files ................................................ 250
Read .xls Files ........................................................................................................................... 253
Write .csv Files .......................................................... 260
Write .xls Files .................................................................. 262
Read JSON ............................................................. 264
Write JSON ......................................................................... 268
Read RDBMS Tables ........................................................... 269
Query RDBMS Tables ................................................................................................................ 279
Read SAS Datasets ................................................................................................................... 286
Write RDBMS Tables ................................................................................................................. 289
Summary .................................................................................................................................. 294
附件列表