1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
|
{{ header }}
.. _api.dataframe:
=========
DataFrame
=========
.. currentmodule:: pandas
Constructor
~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame
Attributes and underlying data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
**Axes**
.. autosummary::
:toctree: api/
DataFrame.index
DataFrame.columns
.. autosummary::
:toctree: api/
DataFrame.dtypes
DataFrame.info
DataFrame.select_dtypes
DataFrame.values
DataFrame.axes
DataFrame.ndim
DataFrame.size
DataFrame.shape
DataFrame.memory_usage
DataFrame.empty
DataFrame.set_flags
Conversion
~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.astype
DataFrame.convert_dtypes
DataFrame.infer_objects
DataFrame.copy
DataFrame.bool
Indexing, iteration
~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.head
DataFrame.at
DataFrame.iat
DataFrame.loc
DataFrame.iloc
DataFrame.insert
DataFrame.__iter__
DataFrame.items
DataFrame.iteritems
DataFrame.keys
DataFrame.iterrows
DataFrame.itertuples
DataFrame.lookup
DataFrame.pop
DataFrame.tail
DataFrame.xs
DataFrame.get
DataFrame.isin
DataFrame.where
DataFrame.mask
DataFrame.query
For more information on ``.at``, ``.iat``, ``.loc``, and
``.iloc``, see the :ref:`indexing documentation <indexing>`.
Binary operator functions
~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.add
DataFrame.sub
DataFrame.mul
DataFrame.div
DataFrame.truediv
DataFrame.floordiv
DataFrame.mod
DataFrame.pow
DataFrame.dot
DataFrame.radd
DataFrame.rsub
DataFrame.rmul
DataFrame.rdiv
DataFrame.rtruediv
DataFrame.rfloordiv
DataFrame.rmod
DataFrame.rpow
DataFrame.lt
DataFrame.gt
DataFrame.le
DataFrame.ge
DataFrame.ne
DataFrame.eq
DataFrame.combine
DataFrame.combine_first
Function application, GroupBy & window
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.apply
DataFrame.applymap
DataFrame.pipe
DataFrame.agg
DataFrame.aggregate
DataFrame.transform
DataFrame.groupby
DataFrame.rolling
DataFrame.expanding
DataFrame.ewm
.. _api.dataframe.stats:
Computations / descriptive stats
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.abs
DataFrame.all
DataFrame.any
DataFrame.clip
DataFrame.corr
DataFrame.corrwith
DataFrame.count
DataFrame.cov
DataFrame.cummax
DataFrame.cummin
DataFrame.cumprod
DataFrame.cumsum
DataFrame.describe
DataFrame.diff
DataFrame.eval
DataFrame.kurt
DataFrame.kurtosis
DataFrame.mad
DataFrame.max
DataFrame.mean
DataFrame.median
DataFrame.min
DataFrame.mode
DataFrame.pct_change
DataFrame.prod
DataFrame.product
DataFrame.quantile
DataFrame.rank
DataFrame.round
DataFrame.sem
DataFrame.skew
DataFrame.sum
DataFrame.std
DataFrame.var
DataFrame.nunique
DataFrame.value_counts
Reindexing / selection / label manipulation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.add_prefix
DataFrame.add_suffix
DataFrame.align
DataFrame.at_time
DataFrame.between_time
DataFrame.drop
DataFrame.drop_duplicates
DataFrame.duplicated
DataFrame.equals
DataFrame.filter
DataFrame.first
DataFrame.head
DataFrame.idxmax
DataFrame.idxmin
DataFrame.last
DataFrame.reindex
DataFrame.reindex_like
DataFrame.rename
DataFrame.rename_axis
DataFrame.reset_index
DataFrame.sample
DataFrame.set_axis
DataFrame.set_index
DataFrame.tail
DataFrame.take
DataFrame.truncate
.. _api.dataframe.missing:
Missing data handling
~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.backfill
DataFrame.bfill
DataFrame.dropna
DataFrame.ffill
DataFrame.fillna
DataFrame.interpolate
DataFrame.isna
DataFrame.isnull
DataFrame.notna
DataFrame.notnull
DataFrame.pad
DataFrame.replace
Reshaping, sorting, transposing
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.droplevel
DataFrame.pivot
DataFrame.pivot_table
DataFrame.reorder_levels
DataFrame.sort_values
DataFrame.sort_index
DataFrame.nlargest
DataFrame.nsmallest
DataFrame.swaplevel
DataFrame.stack
DataFrame.unstack
DataFrame.swapaxes
DataFrame.melt
DataFrame.explode
DataFrame.squeeze
DataFrame.to_xarray
DataFrame.T
DataFrame.transpose
Combining / comparing / joining / merging
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.append
DataFrame.assign
DataFrame.compare
DataFrame.join
DataFrame.merge
DataFrame.update
Time Series-related
~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.asfreq
DataFrame.asof
DataFrame.shift
DataFrame.slice_shift
DataFrame.tshift
DataFrame.first_valid_index
DataFrame.last_valid_index
DataFrame.resample
DataFrame.to_period
DataFrame.to_timestamp
DataFrame.tz_convert
DataFrame.tz_localize
.. _api.frame.flags:
Flags
~~~~~
Flags refer to attributes of the pandas object. Properties of the dataset (like
the date is was recorded, the URL it was accessed from, etc.) should be stored
in :attr:`DataFrame.attrs`.
.. autosummary::
:toctree: api/
Flags
.. _api.frame.metadata:
Metadata
~~~~~~~~
:attr:`DataFrame.attrs` is a dictionary for storing global metadata for this DataFrame.
.. warning:: ``DataFrame.attrs`` is considered experimental and may change without warning.
.. autosummary::
:toctree: api/
DataFrame.attrs
.. _api.dataframe.plotting:
Plotting
~~~~~~~~
``DataFrame.plot`` is both a callable method and a namespace attribute for
specific plotting methods of the form ``DataFrame.plot.<kind>``.
.. autosummary::
:toctree: api/
:template: autosummary/accessor_callable.rst
DataFrame.plot
.. autosummary::
:toctree: api/
:template: autosummary/accessor_method.rst
DataFrame.plot.area
DataFrame.plot.bar
DataFrame.plot.barh
DataFrame.plot.box
DataFrame.plot.density
DataFrame.plot.hexbin
DataFrame.plot.hist
DataFrame.plot.kde
DataFrame.plot.line
DataFrame.plot.pie
DataFrame.plot.scatter
.. autosummary::
:toctree: api/
DataFrame.boxplot
DataFrame.hist
.. _api.frame.sparse:
Sparse accessor
~~~~~~~~~~~~~~~
Sparse-dtype specific methods and attributes are provided under the
``DataFrame.sparse`` accessor.
.. autosummary::
:toctree: api/
:template: autosummary/accessor_attribute.rst
DataFrame.sparse.density
.. autosummary::
:toctree: api/
:template: autosummary/accessor_method.rst
DataFrame.sparse.from_spmatrix
DataFrame.sparse.to_coo
DataFrame.sparse.to_dense
Serialization / IO / conversion
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
:toctree: api/
DataFrame.from_dict
DataFrame.from_records
DataFrame.to_orc
DataFrame.to_parquet
DataFrame.to_pickle
DataFrame.to_csv
DataFrame.to_hdf
DataFrame.to_sql
DataFrame.to_dict
DataFrame.to_excel
DataFrame.to_json
DataFrame.to_html
DataFrame.to_feather
DataFrame.to_latex
DataFrame.to_stata
DataFrame.to_gbq
DataFrame.to_records
DataFrame.to_string
DataFrame.to_clipboard
DataFrame.to_markdown
DataFrame.style
DataFrame.__dataframe__
|
