’A’] In [17]: dfi Out[17]: A B C 0 0 1 0 1 2 3 2 2 4 5 4 [3 rows x 3 columns] This is like an append operation. In [18]: dfi.loc[3] = 5 In [19]: dfi Out[19]: A B C 0 0 1 0 1 2 3 2 2 4 5 4 3 5 fixed(f) or table(t) the same defaults as prior < 0.13.0 remain, e.g. put implies fixed format and append implies table format. This default format can be set as an option by setting io.hdf.default_format pandas: powerful Python data analysis toolkit, Release 0.13.1 In [47]: df.to_hdf(path,’df_table2’,append=True) In [48]: df.to_hdf(path,’df_fixed’) In [49]: with get_store(path) as store: ....: print(store)

’A’] In [17]: dfi Out[17]: A B C 0 0 1 0 1 2 3 2 2 4 5 4 [3 rows x 3 columns] This is like an append operation. In [18]: dfi.loc[3] = 5 In [19]: dfi Out[19]: A B C 0 0 1 0 1.3. v0.13.0 (January fixed(f) or table(t) the same defaults as prior < 0.13.0 remain, e.g. put implies fixed format and append implies table format. This default format can be set as an option by setting io.hdf.default_format DataFrame(randn(10,2)) In [46]: df.to_hdf(path,’df_table’,format=’table’) In [47]: df.to_hdf(path,’df_table2’,append=True) In [48]: df.to_hdf(path,’df_fixed’) In [49]: with get_store(path) as store: ....: print(store)

with a AttributeConflictWarning if you are attempting to append an index with a different frequency than the existing, or attempting to append an index with a different name than the existing – support unique method, can be replicated by select_column(key,column).unique() – min_itemsize parameter to append will now automatically create data_columns for passed keys 1.2.8 Enhancements • Improved performance read_csv/to_csv In [51]: df = DataFrame(dict(A=range(5), B=range(5))) In [52]: df.to_hdf(’store.h5’,’table’,append=True) In [53]: read_hdf(’store.h5’, ’table’, where = [’index>2’]) A B 3 3 3 4 4 4 – provide

the left argument (GH7737). • Previously an enlargement with a mixed-dtype frame would act unlike .append which will preserve dtypes (related GH2578, GH8176): In [108]: df = DataFrame([[True, 1],[False CustomBusinessDay.apply raiases NameError when np.datetime64 object is passed (GH7196) • Bug in MultiIndex.append, concat and pivot_table don’t preserve timezone (GH6606) • Bug in .loc with a list of indexers on ’A’] In [17]: dfi Out[17]: A B C 0 0 1 0 1 2 3 2 2 4 5 4 [3 rows x 3 columns] This is like an append operation. In [18]: dfi.loc[3] = 5 In [19]: dfi Out[19]: A B C 0 0 1 0 1.7. v0.13.0 (January

the left argument (GH7737). • Previously an enlargement with a mixed-dtype frame would act unlike .append which will preserve dtypes (related GH2578, GH8176): In [108]: df = DataFrame([[True, 1],[False CustomBusinessDay.apply raiases NameError when np.datetime64 object is passed (GH7196) • Bug in MultiIndex.append, concat and pivot_table don’t preserve timezone (GH6606) • Bug in .loc with a list of indexers on ’A’] In [17]: dfi Out[17]: A B C 0 0 1 0 1 2 3 2 2 4 5 4 [3 rows x 3 columns] This is like an append operation. In [18]: dfi.loc[3] = 5 In [19]: dfi Out[19]: A B C 0 0 1 0 1.6. v0.13.0 (January

2013-01-04 1.719177 0.223065 2013-01-05 0.031393 -2.226989 • Remove table keyword in HDFStore.put/append, in favor of using format= (GH4645) • Remove kind in read_excel/ExcelFile as its unused (GH4712) analysis toolkit, Release 0.17.0 • Previously an enlargement with a mixed-dtype frame would act unlike .append which will preserve dtypes (related GH2578, GH8176): In [103]: df = DataFrame([[True, 1],[False CustomBusinessDay.apply raiases NameError when np.datetime64 object is passed (GH7196) • Bug in MultiIndex.append, concat and pivot_table don’t preserve timezone (GH6606) • Bug in .loc with a list of indexers on

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365 6.6.3 Append . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 366 6 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 682 18.1.2 Concatenating using append . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 18.1.3 Ignoring indexes on . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1116 pandas.HDFStore.append . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1117 pandas.HDFStore.get

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 363 6.6.3 Append . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 364 6 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 680 18.1.2 Concatenating using append . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 681 18.1.3 Ignoring indexes on . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1113 pandas.HDFStore.append . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1114 pandas.HDFStore.get

performance of Series.append and DataFrame.append (GH468, GH479, GH273) • Can pass multiple DataFrames to DataFrame.append to concatenate (stack) and multiple Series to Series.append too • Can pass list data analysis toolkit, Release 0.7.1 1.3 v.0.6.1 (December 13, 2011) 1.3.1 New features • Can append single rows (as Series) to a DataFrame • Add Spearman and Kendall rank correlation options to Series DataFrame methods get_dtype_counts and property dtypes (ENHdc) • Added ignore_index option to DataFrame.append to stack DataFrames (ENH1b) • read_csv tries to sniff delimiters using csv.Sniffer (PR146) • read_csv

performance of Series.append and DataFrame.append (GH468, GH479, GH273) • Can pass multiple DataFrames to DataFrame.append to concatenate (stack) and multiple Series to Series.append too • Can pass list 5-10x in most typical use cases (GH374) 1.4 v.0.6.1 (December 13, 2011) 1.4.1 New features • Can append single rows (as Series) to a DataFrame • Add Spearman and Kendall rank correlation options to Series DataFrame methods get_dtype_counts and property dtypes (ENHdc) • Added ignore_index option to DataFrame.append to stack DataFrames (ENH1b) • read_csv tries to sniff delimiters using csv.Sniffer (PR146) • read_csv