/Python/Converting numpy array to dataframe

Converting numpy array to dataframe

Dataframe from arrays python

import pandas as pd
df=pd.DataFrame({'col1':vect1,'col2':vect2})

Convert array to dataframe python

np.random.seed(123)
e = np.random.normal(size=10)  
dataframe=pd.DataFrame(e, columns=['a']) 
print (dataframe)
          a
0 -1.085631
1  0.997345
2  0.282978
3 -1.506295
4 -0.578600
5  1.651437
6 -2.426679
7 -0.428913
8  1.265936
9 -0.866740

e_dataframe=pd.DataFrame({'a':e}) 
print (e_dataframe)
          a
0 -1.085631
1  0.997345
2  0.282978
3 -1.506295
4 -0.578600
5  1.651437
6 -2.426679
7 -0.428913
8  1.265936
9 -0.866740

Source: stackoverflow.com

Numpy arrauy to df

numpy_data = np.array([[1, 2], [3, 4]])
df = pd.DataFrame(data=numpy_data, index=["row1", "row2"], columns=["column1", "column2"])
print(df)

Convert pandas dataframe to numpy dataframe

DataFrame.to_numpy(dtype=None, copy=False, na_value=<object object>)

Converting numpy array to dataframe

import numpy as np
import pandas as pd

# Creating a 2 dimensional numpy array
>>> data = np.array([[5.8, 2.8], [6.0, 2.2]])
>>> print(data)
>>> data
array([[5.8, 2.8],
       [6. , 2.2]])

# Creating pandas dataframe from numpy array
>>> dataset = pd.DataFrame({'Column1': data[:, 0], 'Column2': data[:, 1]})
>>> print(dataset)
   Column1  Column2
0      5.8      2.8
1      6.0      2.2

Source: stackoverflow.com

Similar codes

19 votes189 views1 answer
Transform size of picture pygame
Python
0 vote204 views1 answer
Python cgi get raw post data
Python
0 vote189 views1 answer
Django database connection isn't set to UTC postgresql
Python
3 votes238 views1 answer
No module named 'django.core.urlresolvers'
Python Django
2 votes165 views2 answers
Iterate in pandas dataframe
Python
12 votes196 views2 answers
Python sort array of dictionary by value
Python
0 vote284 views1 answer
Annot identify image file '/home/ellis/CB/Django-Ecommerce/media_root/default.jpg'
Python Django
0 vote197 views1 answer
Fix the size of a deque python
Python
0 vote243 views1 answer
Perform a right outer join of self and other.
Python
0 vote202 views1 answer
Difference between calling a function and referencing a function python
Python