Cara menggunakan dynamic dataframe python

Pandas DataFrame is a 2-dimensional labeled data structure like any table with rows and columns. The size and values of the dataframe are mutable,i.e., can be modified. It is the most commonly used pandas object. Pandas DataFrame can be created in multiple ways. Let’s discuss different ways to create a DataFrame one by one.

DataFrame() function is used to create a dataframe in Pandas. The syntax of creating dataframe is:

pandas.DataFrame(data, index, columns)

where,

data: It is a dataset from which dataframe is to be created. It can be list, dictionary, scalar value, series, ndarrays, etc.

index: It is optional, by default the index of the dataframe starts from 0 and ends at the last data value(n-1). It defines the row label explicitly.

columns: This parameter is used to provide column names in the dataframe. If the column name is not defined by default, it will take a value from 0 to n-1.

Method #0:Creating an Empty DataFrame

Python3

# Importing Pandas to create DataFrame

import pandas as pd

# Creating Empty DataFrame and Storing it in variable df

df= pd.DataFrame()

# Importing Pandas to create DataFrame0

# Importing Pandas to create DataFrame1# Importing Pandas to create DataFrame2

Output: 

• The DataFrame() function of pandas is used to create a dataframe.
• df variable is the name of the dataframe in our example.

Output 

Method #1: Creating  Dataframe from Lists

Python3

# Importing Pandas to create DataFrame3

import pandas as pd

# Importing Pandas to create DataFrame7

# Importing Pandas to create DataFrame8= import0import1import2import3import2import5import2import7import2import9import2pandas as pd1pandas as pd2

pandas as pd4

df= pandas as pd7=import0 0 1

 3

df

Dataframe created using list

Method #2: Creating Pandas DataFrame from lists of lists.
 

Python3

# Importing Pandas to create DataFrame3

import pandas as pd

 9

# Importing Pandas to create DataFrame8= # Creating Empty DataFrame and Storing it in variable df2# Creating Empty DataFrame and Storing it in variable df3import2import1# Creating Empty DataFrame and Storing it in variable df6# Creating Empty DataFrame and Storing it in variable df7import2# Creating Empty DataFrame and Storing it in variable df9# Creating Empty DataFrame and Storing it in variable df6df1import2df3df4

df6

df= pandas as pd7=import0=2import2=4 1

 3

df

Output: 
 

Method #3: Creating DataFrame from dict of narray/lists
To create DataFrame from dict of narray/list, all the narray must be of same length. If index is passed then the length index should be equal to the length of arrays. If no index is passed, then by default, index will be range(n) where n is the array length.
 

Python3

=9

pd.DataFrame()0

pd.DataFrame()1

import pandas as pd

pd.DataFrame()6

# Importing Pandas to create DataFrame8= pd.DataFrame()9=2 1 2import2# Creating Empty DataFrame and Storing it in variable df7import2 6import2 8 9

# Importing Pandas to create DataFrame00=4 1import3import2# Importing Pandas to create DataFrame05import2# Importing Pandas to create DataFrame07import2# Importing Pandas to create DataFrame09# Importing Pandas to create DataFrame10

# Importing Pandas to create DataFrame12

df= # Importing Pandas to create DataFrame15

# Importing Pandas to create DataFrame17

df

Output: 
 

Note: While creating dataframe using dictionary, the keys of dictionary will be column name by default. We can also provide column name explicitly using column parameter.
  
Method #4: Creating a DataFrame by proving index label explicitly.
 

Python3

=9

# Importing Pandas to create DataFrame20

# Importing Pandas to create DataFrame22

import pandas as pd

pd.DataFrame()6

# Importing Pandas to create DataFrame8= pd.DataFrame()9=2 1 2import2# Importing Pandas to create DataFrame34import2# Creating Empty DataFrame and Storing it in variable df7import2df1 9

# Importing Pandas to create DataFrame00# Importing Pandas to create DataFrame41 1# Importing Pandas to create DataFrame43import2# Importing Pandas to create DataFrame45import2# Importing Pandas to create DataFrame47import2# Importing Pandas to create DataFrame49# Importing Pandas to create DataFrame10

# Importing Pandas to create DataFrame52

df= # Importing Pandas to create DataFrame55=import0# Importing Pandas to create DataFrame58import2

# Importing Pandas to create DataFrame60# Importing Pandas to create DataFrame61import2

# Importing Pandas to create DataFrame60# Importing Pandas to create DataFrame64import2

# Importing Pandas to create DataFrame60# Importing Pandas to create DataFrame67 1

# Importing Pandas to create DataFrame70

df

Output: 
 

  
Method #5: Creating Dataframe from list of dicts
Pandas DataFrame can be created by passing lists of dictionaries as a input data. By default dictionary keys will be taken as columns.
 

Python3

# Importing Pandas to create DataFrame72

# Importing Pandas to create DataFrame73

import pandas as pd

# Importing Pandas to create DataFrame77

# Importing Pandas to create DataFrame8= # Importing Pandas to create DataFrame80# Importing Pandas to create DataFrame81# Importing Pandas to create DataFrame82# Importing Pandas to create DataFrame83import2# Importing Pandas to create DataFrame85# Importing Pandas to create DataFrame82# Importing Pandas to create DataFrame87import2# Importing Pandas to create DataFrame89# Importing Pandas to create DataFrame82# Importing Pandas to create DataFrame91# Importing Pandas to create DataFrame92

# Importing Pandas to create DataFrame00pd.DataFrame()9# Importing Pandas to create DataFrame81# Importing Pandas to create DataFrame82import1import2# Importing Pandas to create DataFrame85# Importing Pandas to create DataFrame82import3import2# Importing Pandas to create DataFrame89# Importing Pandas to create DataFrame82import5import06

import08

df= # Importing Pandas to create DataFrame15

import13

df

Output: 
 

Another example to create pandas DataFrame by passing lists of dictionaries and row indexes.
 

Python3

import15

import16

import17

import pandas as pd

import21

# Importing Pandas to create DataFrame8= # Importing Pandas to create DataFrame80# Importing Pandas to create DataFrame85# Importing Pandas to create DataFrame82# Importing Pandas to create DataFrame87import2# Importing Pandas to create DataFrame89# Importing Pandas to create DataFrame82# Importing Pandas to create DataFrame91import32# Importing Pandas to create DataFrame81# Importing Pandas to create DataFrame82import1import2# Importing Pandas to create DataFrame85# Importing Pandas to create DataFrame82import3import2# Importing Pandas to create DataFrame89# Importing Pandas to create DataFrame82import5import06

import46

import47

df= # Importing Pandas to create DataFrame55=import0import53import2import55 1

import13

df

Output: 
 

Another example to create pandas DataFrame from lists of dictionaries with both row index as well as column index.
 

Python3

import60

import61

import62

import63

import pandas as pd

import68

# Importing Pandas to create DataFrame8= # Importing Pandas to create DataFrame80# Importing Pandas to create DataFrame81# Importing Pandas to create DataFrame82# Importing Pandas to create DataFrame83import2# Importing Pandas to create DataFrame85# Importing Pandas to create DataFrame82# Importing Pandas to create DataFrame87# Importing Pandas to create DataFrame92

# Importing Pandas to create DataFrame00pd.DataFrame()9# Importing Pandas to create DataFrame81# Importing Pandas to create DataFrame82import84import2# Importing Pandas to create DataFrame85# Importing Pandas to create DataFrame82import1import2# Importing Pandas to create DataFrame89# Importing Pandas to create DataFrame82import3import06

import95

import96

import97= # Importing Pandas to create DataFrame55=import0import53import2

pandas as pd04import55 9

pandas as pd07pandas as pd08=import0# Importing Pandas to create DataFrame81import2# Importing Pandas to create DataFrame85 1

pandas as pd16

pandas as pd17

pandas as pd18= # Importing Pandas to create DataFrame55=import0import53import2

pandas as pd04import55 9

pandas as pd07pandas as pd08=import0# Importing Pandas to create DataFrame81import2pandas as pd34 1

pandas as pd37

# Importing Pandas to create DataFrame1pandas as pd39pandas as pd40pandas as pd41

pandas as pd43

# Importing Pandas to create DataFrame1pandas as pd45

Output: 
 

  
Method #6: Creating DataFrame using zip() function.
Two lists can be merged by using list(zip()) function. Now, create the pandas DataFrame by calling pd.DataFrame() function.
 

Python3

pandas as pd46

pandas as pd47

import pandas as pd

pandas as pd52

pandas as pd53= import0# Creating Empty DataFrame and Storing it in variable df3import2 6import2# Creating Empty DataFrame and Storing it in variable df7import2df1pandas as pd2

pandas as pd65

pandas as pd66= import0pandas as pd69import2import5import2pandas as pd73import2pandas as pd75pandas as pd2

pandas as pd78

pandas as pd79

pandas as pd80= pandas as pd82pandas as pd83pandas as pd84pandas as pd85

pandas as pd87

pandas as pd80

pandas as pd91

pandas as pd92

df= pandas as pd95

pandas as pd96pandas as pd08=import0=2import2=4 1

 05

df

Output: 
 

Method#7:  Creating dataframe from series

To create a dataframe from series, we must pass series as argument to DataFrame() function.

Python3

=9

 08

import pandas as pd

 13

 14=   16import1import2import3import2import5import2import7 1

 25

df=  28

 30

df

Method #8: Creating DataFrame from Dictionary of series.
To create DataFrame from Dict of series, dictionary can be passed to form a DataFrame. The resultant index is the union of all the series of passed indexed.
 

Python3

=9

 33

import pandas as pd

 38

 14= pd.DataFrame()9 42 43import1import2import3import2import5import2import7 9

 52 53=import0# Importing Pandas to create DataFrame81import2# Importing Pandas to create DataFrame85import2# Importing Pandas to create DataFrame89import2 62 86