datafile = {'filename': ['filename_01', 'filename_02'], .....: 'path': ["media/user_name/storage/folder_01/filename_01", .....: "media/user_name/storage/folder_02/filename_02"]} .....: In [127]: pd.set_option('display 30) In [128]: pd.DataFrame(datafile) Out[128]: filename path 0 filename_01 media/user_name/storage/fo... 1 filename_02 media/user_name/storage/fo... In [129]: pd.set_option('display.max_colwidth', 100) [130]: pd.DataFrame(datafile) Out[130]: filename path 0 filename_01 media/user_name/storage/folder_01/filename_01 1 filename_02 media/user_name/storage/folder_02/filename_02 You can also disable this

. . . . . . . . . . . . . . 968 Advanced Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 969 Multiple Table Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 981 25.9 SQL Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 983 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 991 25.9.10 Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 991 25.9.11 Sqlite fallback . .

. . . . . . . . . . . . . . 970 Advanced Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 971 Multiple Table Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 983 25.9 SQL Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 993 25.9.10 Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 993 25.9.11 Sqlite fallback . .

. . . . . . . . . 1074 24.8.6.6 Advanced Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1075 24.8.6.7 Multiple Table Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1087 24.10 SQL Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1089 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1096 24.10.10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1097 24.10.11Sqlite fallback . .

. . . . . . . . . 1070 24.8.6.6 Advanced Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1071 24.8.6.7 Multiple Table Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1084 24.10 SQL Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1087 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1095 24.10.10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1095 24.10.11Sqlite fallback . .

. . . . . . . . . 1109 24.8.6.6 Advanced Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1110 24.8.6.7 Multiple Table Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1122 24.11 SQL Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1124 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1131 24.11.10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1132 24.11.11Sqlite fallback . .

Indexing methods for IntervalIndex have been modified to require exact matches only for Interval queries. IntervalIndex methods previously matched on any overlapping Interval. Behavior with scalar points \\\\\\\\\\\\\\\Out[45]: False The get_loc() method now only returns locations for exact matches to Interval queries, as opposed to the previous behavior of returning locations for overlapping matches. A KeyError will get_indexer() and get_indexer_non_unique() will also only return locations for exact matches to Interval queries, with -1 denoting that an exact match was not found. These indexing changes extend to querying a

Indexing methods for IntervalIndex have been modified to require exact matches only for Interval queries. IntervalIndex methods previously matched on any overlapping Interval. Behavior with scalar points \\\\\\\\\\\\\\\Out[45]: False The get_loc() method now only returns locations for exact matches to Interval queries, as opposed to the previous behavior of returning locations for overlapping matches. A KeyError will get_indexer() and get_indexer_non_unique() will also only return locations for exact matches to Interval queries, with -1 denoting that an exact match was not found. These indexing changes extend to querying a

datafile = {'filename': ['filename_01', 'filename_02'], .....: 'path': ["media/user_name/storage/folder_01/filename_01", .....: "media/user_name/storage/folder_02/filename_02"]} .....: In [125]: pd.set_option('display 30) In [126]: pd.DataFrame(datafile) Out[126]: filename path 0 filename_01 media/user_name/storage/fo... 1 filename_02 media/user_name/storage/fo... In [127]: pd.set_option('display.max_colwidth', 100) [128]: pd.DataFrame(datafile) Out[128]: filename path 0 filename_01 media/user_name/storage/folder_01/filename_01 1 filename_02 media/user_name/storage/folder_02/filename_02 You can also disable this

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 326 2.1.14 SQL queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 326 2.1.15 datafile = {'filename': ['filename_01', 'filename_02'], .....: 'path': ["media/user_name/storage/folder_01/filename_01", .....: "media/user_name/storage/folder_02/filename_02"]} .....: In [125]: pd.set_option('display 30) In [126]: pd.DataFrame(datafile) Out[126]: filename path 0 filename_01 media/user_name/storage/fo... 1 filename_02 media/user_name/storage/fo... In [127]: pd.set_option('display.max_colwidth', 100)