How to create a DataFrame with Pandas in Python?
In Python, there are several ways to create a DataFrame with Pandas. In the following, we assume Pandas is imported according to this line:
import pandas as pd
Create an empty DataFrame
>>> df = pd.DataFrame()
Empty DataFrame
Columns: []
Index: []
Create DataFrame from lists
>>> list = [[1,2], [3,4], [4,5]]
>>> df = pd.DataFrame(list)
0 1
0 1 2
1 3 4
2 4 5
Create DataFrame from dictionaries
>>> dict={'C1': [1, 4], 'C2': [2, 5], 'C3': [3, 6] }
>>> df = pd.DataFrame(dict)
C1 C2 C3
0 1 2 3
1 4 5 6
Create DataFrame from NumPy arrays
>>> import numpy as np
>>> array =np.array([ [1,2,3] , [4,5,6] ])
>>> df = pd.DataFrame(array)
0 1 2
0 1 2 3
1 4 5 6
In Python, there are several ways to create a DataFrame with Pandas. In the following, we assume Pandas is imported according to this line:
import pandas as pd
Create an empty DataFrame
>>> df = pd.DataFrame()
Empty DataFrame
Columns: []
Index: []
Create DataFrame from lists
>>> list = [[1,2], [3,4], [4,5]]
>>> df = pd.DataFrame(list)
0 1
0 1 2
1 3 4
2 4 5
Create DataFrame from dictionaries
>>> dict={'C1': [1, 4], 'C2': [2, 5], 'C3': [3, 6] }
>>> df = pd.DataFrame(dict)
C1 C2 C3
0 1 2 3
1 4 5 6
Create DataFrame from NumPy arrays
>>> import numpy as np
>>> array =np.array([ [1,2,3] , [4,5,6] ])
>>> df = pd.DataFrame(array)
0 1 2
0 1 2 3
1 4 5 6
In Python, there are several ways to create a DataFrame with Pandas. In the following, we assume Pandas is imported according to this line:
import pandas as pd
Create an empty DataFrame
>>> df = pd.DataFrame()
Empty DataFrame
Columns: []
Index: []
Create a DataFrame from lists
>>> list = [[1,2], [3,4], [4,5]]
>>> df = pd.DataFrame(list)
0 1
0 1 2
1 3 4
2 4 5
Create DataFrame from dictionaries
>>> dict={'C1': [1, 4], 'C2': [2, 5], 'C3': [3, 6] }
>>> df = pd.DataFrame(dict)
C1 C2 C3
0 1 2 3
1 4 5 6
Create DataFrame from NumPy arrays
>>> import numpy as np
>>> array =np.array([ [1,2,3] , [4,5,6] ])
>>> df = pd.DataFrame(array)
0 1 2
0 1 2 3
1 4 5 6
| # | ID | Query | URL | Count |
|---|---|---|---|---|
| 0 | 12332 | en | https://en.ans.wiki/6960/how-to-create-a-dataframe-with-pandas-in-python | 7 |