Skip to content

Instantly share code, notes, and snippets.

@MichaelWS

MichaelWS/gist:7981451

Created December 16, 2013 02:14
Show Gist options
  • Save MichaelWS/7981451 to your computer and use it in GitHub Desktop.
Save MichaelWS/7981451 to your computer and use it in GitHub Desktop.
Download ZIP
dataframe
Raw
gistfile1.txt
In [7]: us_df.head(10)
Out[7]:
date close country currency high id \
0 1993-01-04 00:00:00 5.382715 US USD 5.432099 B00CQC-S-US
1 1993-01-04 00:00:00 10.708334 US USD 10.833334 B01573-S-US
2 1993-01-04 00:00:00 NaN US USD NaN B07H91-S-US
3 1993-01-04 00:00:00 912.500000 US USD 912.500000 B15R2H-S-US
4 1993-01-04 00:00:00 6.442701 US USD 6.735551 B28D82-S-US
5 1993-01-04 00:00:00 28.091904 US USD 28.210185 B2DTQ7-S-US
6 1993-01-04 00:00:00 12.049219 US USD 12.172170 B2F13F-S-US
7 1993-01-04 00:00:00 2.281250 US USD 2.328125 B2F49J-S-US
8 1993-01-04 00:00:00 10.120484 US USD 10.120484 B3DTVB-S-US
9 1993-01-04 00:00:00 12.867594 US USD 13.290472 B3L74D-S-US
low open volume unadj_open unadj_close unadj_high \
0 4.987655 0 1803262.786252 0 27.24999 27.500
1 10.583334 0 294000.051033 0 32.12500 32.500
2 NaN NaN NaN 0 10.00000 10.000
3 850.000000 0 3762.000000 0 18.25000 18.250
4 6.442701 0 159125.834547 0 22.00000 23.000
5 27.796199 0 788372.170791 0 59.37500 59.625
6 11.680366 0 186659.396740 0 24.50000 24.750
7 2.273438 0 8406400.000000 0 36.50000 37.250
8 9.934217 0 59189.365081 0 20.37500 20.375
9 12.867594 0 2448013.051253 0 26.62500 27.500
unadj_low unadj_volume liq adj_factor dividend
0 25.250 356200.10 NaN 0.197531 NaN
1 31.750 98000.02 NaN 0.333333 NaN
2 9.875 52000.00 NaN NaN NaN
3 17.000 188100.00 NaN 50.000000 NaN
4 22.000 46600.01 NaN 0.292850 NaN
5 58.750 373000.00 NaN 0.473127 NaN
6 23.750 91800.00 NaN 0.491805 NaN
7 36.375 525400.00 NaN 0.062500 NaN
8 20.000 29400.00 NaN 0.496711 NaN
9 26.625 1183100.00 NaN 0.483290 NaN
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment