48295

create a tuple from columns in a pandas DataFrame

<h3>Question</h3>

I would like to automatically create a tuple (to be passed to a scipy.stats function) from columns in a pandas dataframe, so that each row of the tuple are the values from each column of the dataframe. here is the header from my dataframe:

4_3-a-0 5_3-a-4 7_3-a-3 datetime_pac 2015-09-03 22:00:00 -100.4 -96.857143 -55.000000 2015-09-03 22:01:00 -100.5 -91.700000 -55.600000 2015-09-03 22:02:00 -100.4 -90.875000 -55.900000 2015-09-03 22:03:00 -100.4 -94.000000 -55.555556 2015-09-03 22:04:00 -100.5 -99.500000 -55.545455

I can achieve this manually like so:

from scipy import stats stats.f_oneway(df.ix[:,0], df.ix[:,1], df.ix[:,2])

But I would like to 'automate' it in cases where the number of columns in the dataframe is unknown. The following attempts (and many variations of) would not work:

stats.f_oneway(tuple(x) for x in xtmp.values) stats.f_oneway((xtmp[x]) for x in xtmp.columns)

Thanks for your help!


<h3>Answer1:</h3>

What about

tuple([tuple(df[col]) for col in df])
<h3>Answer2:</h3>

Just call apply and call tuple:

In [3]: df = pd.DataFrame(np.random.randn(5,3)) df Out[3]: 0 1 2 0 0.785562 -0.263813 2.239865 1 1.083918 0.035746 0.429111 2 1.422599 -0.818151 0.765725 3 1.022289 0.098561 -2.393095 4 -0.548451 -0.345796 0.298237 In [4]: df.apply(tuple, axis=1) Out[4]: 0 (0.785562108573, -0.263813112223, 2.23986497964) 1 (1.08391788685, 0.0357457180803, 0.429110675053) 2 (1.4225989372, -0.818150896781, 0.765724984713) 3 (1.02228880387, 0.0985610274998, -2.39309469576) 4 (-0.548450748411, -0.345796089243, 0.298237353... dtype: object

来源:https://stackoverflow.com/questions/32485488/create-a-tuple-from-columns-in-a-pandas-dataframe

Recommend

  • Docker container not starting a second time (iptables)
  • Creating my Custom Unique Key
  • Youtube API Actionscript 3 and Thumbnails
  • error while trying to install tesserocr
  • How to use MIPS load word
  • How to change the default browser in visual studio code latest released?
  • UIDatePicker crashing application
  • Select Checkbox !== Select Row Table
  • how can i open a webpage in a webview from a fragment with buttons?
  • Creating custom UTI for use with airdrop, iOS
  • Adding a delete button in PHP on each row of a MySQL table
  • Is the Windows App Store required for a UWP application?
  • about iOS target version and SDK version
  • Printing a flowdocument with dynamic data in WPF
  • How do decorators in es6 work?
  • Rails Template Error with Heroku
  • invoke-webrequest to get complete web page with images
  • Print a Form at higher dpi than screen resolution
  • search bar getting disappeared in ios UIsearchcontroller
  • Texture streaming in DirectX11, Immutable vs Dynamic
  • Need reference code for SMO in C# SQL Server 2008
  • “RepeatForUnit” item missing in Calendar entry?
  • Google Chrome compositor-driven animation affected by jam in main thread
  • AngularJS Dynamic Directives inside ng-repeat
  • PySpark: Get first Non-null value of each column in dataframe
  • Highcharts Drawing a line with chart.renderer.path
  • In Moment.js, how do you get the date of the next occurrence of a specific month (ex: 'next Jan
  • Adding custom message on Thank You page by shipping method
  • Preloading webView doesn't work - trying to reduce loading time
  • Force fading edge on TextView
  • Access to database zend framework
  • Align microsoft access queries
  • First dynamically-added TinyMCE editor displays, others do not
  • How to add html image in to velocity template file to send email?
  • getting the class name of an HTML tag using XPATH
  • How to create subsets of a single set of elements with XSLT?
  • how to run a different select statement based on condition in Hive SQL
  • Conflicting declaration using constexpr and auto in C++11
  • Cloud Code: Creating a Parse.File from URL
  • Using Service Component Runtime