Advertisement
Guest User

Untitled

a guest
Jun 28th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.92 KB | None | 0 0
  1.  
  2.  
  3. ```python
  4. # Python Change Pandas DataFrame Variables
  5.  
  6. import pandas as pd
  7.  
  8. data = [['hello', '1.222', '4', '5.22'], ['world', '66', '4', '6.33'], ['hello', '4.22', '0', '5.24']]
  9. data = pd.DataFrame(data, columns = ['a', 'b', 'c', 'd'])
  10. data
  11. ```
  12.  
  13.  
  14.  
  15.  
  16. <div>
  17. <table border="1" class="dataframe">
  18. <thead>
  19. <tr style="text-align: right;">
  20. <th></th>
  21. <th>a</th>
  22. <th>b</th>
  23. <th>c</th>
  24. <th>d</th>
  25. </tr>
  26. </thead>
  27. <tbody>
  28. <tr>
  29. <th>0</th>
  30. <td>hello</td>
  31. <td>1.222</td>
  32. <td>4</td>
  33. <td>5.22</td>
  34. </tr>
  35. <tr>
  36. <th>1</th>
  37. <td>world</td>
  38. <td>66</td>
  39. <td>4</td>
  40. <td>6.33</td>
  41. </tr>
  42. <tr>
  43. <th>2</th>
  44. <td>hello</td>
  45. <td>4.22</td>
  46. <td>0</td>
  47. <td>5.24</td>
  48. </tr>
  49. </tbody>
  50. </table>
  51. </div>
  52.  
  53.  
  54.  
  55.  
  56. ```python
  57. data.dtypes
  58. ```
  59.  
  60.  
  61.  
  62.  
  63. a object
  64. b object
  65. c object
  66. d object
  67. dtype: object
  68.  
  69.  
  70.  
  71.  
  72. ```python
  73. data.a[0] + " " + data.a[1]
  74. ```
  75.  
  76.  
  77.  
  78.  
  79. 'hello world'
  80.  
  81.  
  82.  
  83.  
  84. ```python
  85. data[['b', 'd']] = data[['b', 'd']].astype(float)
  86. data[['c']] = data[['c']].astype(int)
  87. data[['a']] = data[['a']].astype(str) # Defaults to string
  88. data
  89. ```
  90.  
  91.  
  92.  
  93.  
  94. <div>
  95. <table border="1" class="dataframe">
  96. <thead>
  97. <tr style="text-align: right;">
  98. <th></th>
  99. <th>a</th>
  100. <th>b</th>
  101. <th>c</th>
  102. <th>d</th>
  103. </tr>
  104. </thead>
  105. <tbody>
  106. <tr>
  107. <th>0</th>
  108. <td>hello</td>
  109. <td>1.222</td>
  110. <td>4</td>
  111. <td>5.22</td>
  112. </tr>
  113. <tr>
  114. <th>1</th>
  115. <td>world</td>
  116. <td>66.000</td>
  117. <td>4</td>
  118. <td>6.33</td>
  119. </tr>
  120. <tr>
  121. <th>2</th>
  122. <td>hello</td>
  123. <td>4.220</td>
  124. <td>0</td>
  125. <td>5.24</td>
  126. </tr>
  127. </tbody>
  128. </table>
  129. </div>
  130.  
  131.  
  132.  
  133.  
  134. ```python
  135. data.dtypes
  136. ```
  137.  
  138.  
  139.  
  140.  
  141. a object
  142. b float64
  143. c int32
  144. d float64
  145. dtype: object
  146.  
  147.  
  148.  
  149.  
  150. ```python
  151. data.a[0] + " " + data.a[1]
  152. ```
  153.  
  154.  
  155.  
  156.  
  157. 'hello world'
  158.  
  159.  
  160.  
  161.  
  162. ```python
  163.  
  164. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement