PYTHON
how to create dataframe in python
import pandas as pd
# intialise data of lists.
data = {'Name':['Tom', 'nick', 'krish', 'jack'],
'Age':[20, 21, 19, 18]}
# Create DataFrame
df = pd.DataFrame(data)
# Print the output.
df
create a df in pandas
import pandas as pd
data = {'First Column Name': ['First value', 'Second value',...],
'Second Column Name': ['First value', 'Second value',...],
....
}
df = pd.DataFrame (data, columns = ['First Column Name','Second Column Name',...])
print (df)
how do we create a dataframe in python
# Import pandas library
import pandas as pd
# initialize list of lists
data = [['Group A', 85], ['Group B', 92], ['Group C', 88]]
# Create the pandas DataFrame
df = pd.DataFrame(data, columns = ['Name', 'Score'])
# print dataframe.
df
create a dataframe python
import numpy as np
import pandas as pd
vect1=np.zeros(10)
vect2=np.ones(10)
df=pd.DataFrame({'col1':vect1,'col2':vect2})
dataframe create
>>> df2 = pd.DataFrame(np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]]),
... columns=['a', 'b', 'c'])
>>> df2
a b c
0 1 2 3
1 4 5 6
2 7 8 9
creating a pandas df
>>> d = {'col1': [1, 2], 'col2': [3, 4]}
>>> df = pd.DataFrame(data=d)
>>> df
col1 col2
0 1 3
1 2 4
pandas make new dataframe
df = pd.DataFrame({'column1':[1,2,3],'column2':[4,5,6])
create panda DataFrame
import pandas as pd
data = {"Name": ['Phillip', 'Donald', 'Fankhola', 'Mixo', 'Delight', 'Vuyo'],
"Surname": ['Moyo', 'Phutiane', 'Siphotoma', 'Ngobeni', 'Chauke', 'Shabango'],
"Age": [25, 23, 24, 24, 23, 23]}
df = pd.DataFrame(data)
df
create a dataframe python
import pandas as pd
import numpy as np
df = pd.DataFrame(np.array([[1, 2, 3, 5], [4, 5, 6, 7], [7, 8, 9, 1]]),
columns=['a', 'b', 'c', 'd'])
create data frame in panda
# Python code demonstrate creating
# DataFrame from dict narray / lists
# By default addresses.
import pandas as pd
# initialize data of lists.
data = {'Name': ['Tom', 'nick', 'krish', 'jack'],
'Age': [20, 21, 19, 18]}
# Create DataFrame
df = pd.DataFrame(data)
# Print the output.
df
How to create DataFrames
import pandas as pd
data = {
"A":[1,2,3],
"B":[4,5,6],
"C":[7,8,9]
}
index = [1,2,3,4,5,6,7,8,9]
pd.DataFrame(data=data, index=index)
create panda DataFrame
import pandas as pd
data = {"Name": ['Phillip', 'Donald', 'Fankhola', 'Mixo', 'Delight', 'Vuyo'],
"Surname": ['Moyo', 'Phutiane', 'Siphotoma', 'Ngobeni', 'Chauke', 'Shabango'],
"Age": [25, 23, 24, 24, 23, 23]}
df = pd.DataFrame(data)
df
create panda DataFrame
import pandas as pd
data = {"Name": ['Phillip', 'Donald', 'Fankhola', 'Mixo', 'Delight', 'Vuyo'],
"Surname": ['Moyo', 'Phutiane', 'Siphotoma', 'Ngobeni', 'Chauke', 'Shabango'],
"Age": [25, 23, 24, 24, 23, 23]}
df = pd.DataFrame(data)
df
creating dataframe
import pandas as pd
# initialise data of lists.
data = {'Name':['Tom', 'nick', 'krish', 'jack'],
'Age':[20, 21, 19, 18]}
# Create DataFrame
df = pd.DataFrame(data)
# Print the output.
df
Create Pandas DataFrame
import pandas as pd
boxes = {'Color': ['Green','Green','Green','Blue','Blue','Red','Red','Red'],
'Shape': ['Rectangle','Rectangle','Square','Rectangle','Square','Square','Square','Rectangle']
}
df = pd.DataFrame(boxes, columns = ['Color', 'Shape'])
print(df)
create data frame in panda
# Import pandas library
import pandas as pd
# initialize list of lists
data = [['tom', 10], ['nick', 15], ['juli', 14]]
# Create the pandas DataFrame
df = pd.DataFrame(data, columns=['Name', 'Age'])
# print dataframe.
df
create python dataframe
# Python code demonstrate creating
# pandas DataFrame with indexed by
# DataFrame using arrays.
import pandas as pd
# initialize data of lists.
data = {'Name': ['Tom', 'Jack', 'nick', 'juli'],
'marks': [99, 98, 95, 90]}
# Creates pandas DataFrame.
df = pd.DataFrame(data, index=['rank1',
'rank2',
'rank3',
'rank4'])
# print the data
grouped = df.groupby(['class', 'avg calories per unit'])
grouped
How to create a new Dataframe in python
df_New = df[['MONTH','DAY', 'DAY_OF_WEEK', 'ORIGIN_AIRPORT','FLIGHT_NUMBER', 'DESTINATION_AIRPORT','DEPARTURE_TIME', 'DEPARTURE_DELAY', 'ARRIVAL_TIME', 'ARRIVAL_DELAY', 'CANCELLED', 'DIVERTED', 'DISTANCE']]
df_New.head()
create data frame in panda
# Python code demonstrate creating
# pandas DataFrame with indexed by
# DataFrame using arrays.
import pandas as pd
# initialize data of lists.
data = {'Name': ['Tom', 'Jack', 'nick', 'juli'],
'marks': [99, 98, 95, 90]}
# Creates pandas DataFrame.
df = pd.DataFrame(data, index=['rank1',
'rank2',
'rank3',
'rank4'])
# print the data
df
Create a pandas dataframe
import pandas as pd
s = pd.Series()
print(s)