En Pandas, Panel es un contenedor muy importante para datos tridimensionales. Los nombres de los 3 ejes pretenden dar algún significado semántico a la descripción de operaciones que involucran datos de panel y, en particular, el análisis econométrico de datos de panel.
En Pandas, Panel.rmul()la función se usa para obtener la multiplicación de series y dataframe/Panel.
Sintaxis: Panel.rmul(otro, eje=0)
Parámetros:
otro: DataFrame o Panel
axis: Eje sobre el que transmitirDevoluciones: Panel
Código #1:
# importing pandas module
import pandas as pd
import numpy as np
df1 = pd.DataFrame({'a': ['Geeks', 'For', 'geeks', 'real'],
'b': [111, 123, 425, 1333]})
df2 = pd.DataFrame({'a': ['I', 'am', 'dataframe', 'two'],
'b': [100, 100, 100, 100]})
data = {'item1':df1, 'item2':df2}
# creating Panel
panel = pd.Panel.from_dict(data, orient ='minor')
print("panel['b'] is - \n\n", panel['b'])
print("\nMultiplying panel['b'] with df2['b'] using rmul() method - \n")
print("\n", panel['b'].rmul(df2['b'], axis = 0))
Producción:
panel['b'] is -
item1 item2
0 111 100
1 123 100
2 425 100
3 1333 100
Multiplying panel['b'] with df2['b'] using rmul() method -
item1 item2
0 11100 10000
1 12300 10000
2 42500 10000
3 133300 10000
Código #2:
# importing pandas module
import pandas as pd
import numpy as np
df1 = pd.DataFrame({'a': ['Geeks', 'For', 'geeks', 'for', 'real'],
'b': [11, 1.025, 333, 114.48, 1333]})
data = {'item1':df1, 'item2':df1}
# creating Panel
panel = pd.Panel.from_dict(data, orient ='minor')
print("panel['b'] is - \n\n", panel['b'], '\n')
# Create a 5 * 5 dataframe
df2 = pd.DataFrame(np.random.rand(5, 2), columns =['item1', 'item2'])
print("Newly create dataframe with random values is - \n\n", df2)
print("\nMultiplying panel['b'] with df2 using rmul() method - \n")
print(panel['b'].rmul(df2, axis = 0))
Producción:
panel['b'] is -
item1 item2
0 11.000 11.000
1 1.025 1.025
2 333.000 333.000
3 114.480 114.480
4 1333.000 1333.000
Newly create dataframe with random values is -
item1 item2
0 0.549490 0.658451
1 0.321557 0.139482
2 0.010817 0.775445
3 0.011675 0.333828
4 0.818014 0.462602
Multiplying panel['b'] with df2 using rmul() method -
item1 item2
0 6.044385 7.242957
1 0.329596 0.142969
2 3.602168 258.223060
3 1.336504 38.216583
4 1090.412087 616.648529
Código #3:
# importing pandas module
import pandas as pd
import numpy as np
df1 = pd.DataFrame({'a': ['Geeks', 'For', 'geeks', 'for', 'real'],
'b': [11, 1.025, 333, 114.48, 1333]})
df2 = pd.DataFrame({'a': ['I', 'am', 'DataFrame', 'number', 'two'],
'b': [10, 10, 10, 110, 110]})
data = {'item1':df1, 'item2':df2}
# creating Panel
panel = pd.Panel.from_dict(data, orient ='minor')
print("panel['b'] is - \n\n", panel['b'], '\n')
print("\nMultiplying panel['b']['item1'] with df2['b'] or panel['b']['item2'] using rmul() method - \n")
print("\n", panel['b']['item1'].rmul(df2['b'], axis = 0))
Producción:
panel['b'] is -
item1 item2
0 11.000 10
1 1.025 10
2 333.000 10
3 114.480 110
4 1333.000 110
Multiplying panel['b']['item1'] with df2['b'] or panel['b']['item2'] using rmul() method -
0 110.00
1 10.25
2 3330.00
3 12592.80
4 146630.00
dtype: float64