tiny_data_frame
resource_tracker.tiny_data_frame
#
A very inefficient data-frame implementation for manipulating resource usage data.
Classes:
Name | Description |
---|---|
TinyDataFrame |
A very inefficient data-frame implementation with a few features. |
TinyDataFrame
#
A very inefficient data-frame implementation with a few features.
Supported features:
- reading CSV files from a remote URL
- reading CSV files from a local file
- converting a dictionary of lists/arrays to a data-frame
- converting a list of dictionaries to a data-frame
- slicing rows
- slicing columns
- slicing rows and columns
- printing a summary of the data-frame
- printing the data-frame as a human-readable (grid) table
- renaming columns
- writing to a CSV file
Parameters:
Name | Type | Description | Default |
---|---|---|---|
data
|
Optional[dict | list]
|
Dictionary of lists/arrays or list of dictionaries. |
None
|
csv_file_path
|
Optional[str]
|
Path to a properly quoted CSV file. |
None
|
Example:
>>> df = TinyDataFrame(csv_file_path="https://raw.githubusercontent.com/plotly/datasets/refs/heads/master/mtcars.csv")
>>> df
TinyDataFrame with 32 rows and 12 columns. First row as a dict: {'manufacturer': 'Mazda RX4', 'mpg': 21.0, 'cyl': 6.0, 'disp': 160.0, 'hp': 110.0, 'drat': 3.9, 'wt': 2.62, 'qsec': 16.46, 'vs': 0.0, 'am': 1.0, 'gear': 4.0, 'carb': 4.0}
>>> df[2:5][['manufacturer', 'hp']]
TinyDataFrame with 3 rows and 2 columns. First row as a dict: {'manufacturer': 'Datsun 710', 'hp': 93.0}
>>> print(df[2:5][['manufacturer', 'hp']]) # doctest: +NORMALIZE_WHITESPACE
TinyDataFrame with 3 rows and 2 columns:
manufacturer | hp
------------------+------
Datsun 710 | 93.0
Hornet 4 Drive | 110.0
Hornet Sportabout | 175.0
>>> print(df[2:5][['manufacturer', 'hp']].to_csv()) # doctest: +NORMALIZE_WHITESPACE
"manufacturer","hp"
"Datsun 710",93.0
"Hornet 4 Drive",110.0
"Hornet Sportabout",175.0
Methods:
Name | Description |
---|---|
__init__ |
Initialize with either: |
__len__ |
Return the number of rows in the data-frame |
__getitem__ |
Get a single column or multiple columns or a row or a slice of rows. Can be chained. |
__setitem__ |
Set a column with the given key to the provided values. |
head |
Return first n rows as a new TinyDataFrame. |
tail |
Return last n rows as a new TinyDataFrame. |
__repr__ |
Return a string representation of the data-frame. |
__str__ |
Print the first 10 rows of the data-frame in a human-readable table. |
to_csv |
Write the data-frame to a CSV file or return as string if no path is provided. |
rename |
Rename one or multiple columns. |
Source code in resource_tracker/tiny_data_frame.py
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 |
|
__init__
#
Initialize with either:
- Dictionary of lists/arrays
- List of dictionaries
- CSV file path
Source code in resource_tracker/tiny_data_frame.py
__len__
#
__getitem__
#
Get a single column or multiple columns or a row or a slice of rows. Can be chained.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
key
|
Union[str, list[str], int, slice]
|
A single column name, a list of column names, a row index, or a slice of row indexes. |
required |
Returns:
Type | Description |
---|---|
Union[list, dict, TinyDataFrame]
|
A single column as a list, a list of columns as a new TinyDataFrame, a row as a dictionary, or a slice of rows as a new TinyDataFrame. |
Source code in resource_tracker/tiny_data_frame.py
__setitem__
#
Set a column with the given key to the provided values.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
key
|
str
|
Column name (string) |
required |
value
|
list
|
List of values for the column |
required |
Raises:
Type | Description |
---|---|
TypeError
|
If key is not a string |
ValueError
|
If the length of values doesn't match the dataframe length |
Source code in resource_tracker/tiny_data_frame.py
head
#
tail
#
__repr__
#
Return a string representation of the data-frame.
__str__
#
Print the first 10 rows of the data-frame in a human-readable table.
Source code in resource_tracker/tiny_data_frame.py
to_csv
#
Write the data-frame to a CSV file or return as string if no path is provided.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
csv_file_path
|
Optional[str]
|
Path to write CSV file. If None, returns CSV as string. |
None
|
quote_strings
|
bool
|
Whether to quote strings. |
True
|
Source code in resource_tracker/tiny_data_frame.py
rename
#
Rename one or multiple columns.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
columns
|
dict
|
Dictionary mapping old column names to new column names. |
required |
Returns:
Type | Description |
---|---|
TinyDataFrame
|
Self for method chaining. |
Raises:
Type | Description |
---|---|
KeyError
|
If any old column name doesn't exist in the dataframe. |