{"id":3069,"date":"2023-07-19T08:56:26","date_gmt":"2023-07-19T08:56:26","guid":{"rendered":"https:\/\/statorials.org\/my\/%e1%80%a1%e1%80%81%e1%80%bc%e1%80%b1%e1%80%a1%e1%80%94%e1%80%b1%e1%80%a1%e1%80%9b-%e1%80%95%e1%80%bb%e1%80%99%e1%80%ba%e1%80%b8%e1%80%99%e1%80%bb%e1%80%be-%e1%80%95%e1%80%94%e1%80%ba%e1%80%92%e1%80%ab\/"},"modified":"2023-07-19T08:56:26","modified_gmt":"2023-07-19T08:56:26","slug":"%e1%80%a1%e1%80%81%e1%80%bc%e1%80%b1%e1%80%a1%e1%80%94%e1%80%b1%e1%80%a1%e1%80%9b-%e1%80%95%e1%80%bb%e1%80%99%e1%80%ba%e1%80%b8%e1%80%99%e1%80%bb%e1%80%be-%e1%80%95%e1%80%94%e1%80%ba%e1%80%92%e1%80%ab","status":"publish","type":"post","link":"https:\/\/statorials.org\/my\/%e1%80%a1%e1%80%81%e1%80%bc%e1%80%b1%e1%80%a1%e1%80%94%e1%80%b1%e1%80%a1%e1%80%9b-%e1%80%95%e1%80%bb%e1%80%99%e1%80%ba%e1%80%b8%e1%80%99%e1%80%bb%e1%80%be-%e1%80%95%e1%80%94%e1%80%ba%e1%80%92%e1%80%ab\/","title":{"rendered":"Pandas \u1010\u103d\u1004\u103a conditional mean \u1000\u102d\u102f \u1010\u103d\u1000\u103a\u1001\u103b\u1000\u103a\u1014\u100a\u103a\u1038 (\u1025\u1015\u1019\u102c\u1019\u103b\u102c\u1038\u1016\u103c\u1004\u1037\u103a)"},"content":{"rendered":"

<\/p>\n

\n

\u1015\u1014\u103a\u1012\u102b\u1019\u103b\u102c\u1038\u1010\u103d\u1004\u103a \u1021\u1001\u103c\u1031\u1021\u1014\u1031\u1006\u102d\u102f\u1004\u103a\u101b\u102c \u1015\u103b\u1019\u103a\u1038\u1019\u103b\u103e\u1021\u102c\u1038 \u1010\u103d\u1000\u103a\u1001\u103b\u1000\u103a\u101b\u1014\u103a \u1021\u1031\u102c\u1000\u103a\u1015\u102b syntax \u1000\u102d\u102f \u101e\u1004\u103a\u101e\u102f\u1036\u1038\u1014\u102d\u102f\u1004\u103a\u101e\u100a\u103a\u104b<\/span><\/p>\n

 df. loc<\/span> [df[' team<\/span> '] == ' A<\/span> ', ' points<\/span> ']. mean<\/span> ()\n<\/strong><\/pre>\n
 \u104e\u1004\u103a\u1038\u101e\u100a\u103a “ \u1021\u1016\u103d\u1032\u1037”  \u1000\u1031\u102c\u103a\u101c\u1036 “ A”  \u1014\u103e\u1004\u1037\u103a \u100a\u102e\u1019\u103b\u103e\u101e\u100a\u1037\u103a DataFrame \u101b\u103e\u102d \u1021\u1010\u1014\u103a\u1038\u1010\u1005\u103a\u1001\u102f\u1005\u102e\u1021\u1010\u103d\u1000\u103a “ \u1021\u1019\u103e\u1010\u103a”  \u1000\u1031\u102c\u103a\u101c\u1036\u104f \u1015\u103b\u1019\u103a\u1038\u1019\u103b\u103e\u1021\u102c\u1038 \u1010\u103d\u1000\u103a\u1001\u103b\u1000\u103a\u101e\u100a\u103a\u104b<\/span><\/p>\n
 \u1021\u1031\u102c\u1000\u103a\u1016\u1031\u102c\u103a\u1015\u103c\u1015\u102b\u1014\u1019\u1030\u1014\u102c\u1019\u103b\u102c\u1038\u101e\u100a\u103a \u1021\u1031\u102c\u1000\u103a\u1015\u102b pandas DataFrame \u1014\u103e\u1004\u1037\u103a \u101c\u1000\u103a\u1010\u103d\u1031\u1037\u1010\u103d\u1004\u103a \u1024 syntax \u1000\u102d\u102f\u1019\u100a\u103a\u101e\u102d\u102f\u1037\u1021\u101e\u102f\u1036\u1038\u1015\u103c\u102f\u101b\u1019\u100a\u103a\u1000\u102d\u102f \u1015\u103c\u101e\u101e\u100a\u103a \u104b<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd<\/span>\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'B', 'B', 'B'],\n                   ' points<\/span> ': [99, 90, 93, 86, 88, 82],\n                   ' assists<\/span> ': [33, 28, 31, 39, 34, 30]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  team points assists\n0 to 99 33\n1 A 90 28\n2 A 93 31\n3 B 86 39\n4 B 88 34\n5 B 82 30<\/span><\/span><\/strong><\/pre>\n
 \u1025\u1015\u1019\u102c 1- \u1021\u1019\u103b\u102d\u102f\u1038\u1021\u1005\u102c\u1038\u1021\u101c\u102d\u102f\u1000\u103a \u1015\u103c\u1031\u102c\u1004\u103a\u1038\u101c\u103d\u1032\u1014\u102d\u102f\u1004\u103a\u101e\u1031\u102c \u1021\u1001\u103c\u1031\u1021\u1014\u1031\u1021\u1010\u103d\u1000\u103a \u101e\u1010\u103a\u1019\u103e\u1010\u103a\u1001\u103b\u1000\u103a\u1021\u1010\u102d\u102f\u1004\u103a\u1038 \u1010\u103d\u1000\u103a\u1001\u103b\u1000\u103a\u1015\u102b\u104b<\/strong><\/span><\/h3>\n
 \u1021\u1031\u102c\u1000\u103a\u1015\u102b\u1000\u102f\u1012\u103a\u101e\u100a\u103a “ \u1021\u1016\u103d\u1032\u1037”  \u1000\u1031\u102c\u103a\u101c\u1036\u1010\u103d\u1004\u103a \u1010\u1014\u103a\u1016\u102d\u102f\u1038 “ A”  \u101b\u103e\u102d\u101e\u100a\u1037\u103a DataFrame \u101b\u103e\u102d \u1021\u1010\u1014\u103a\u1038\u1019\u103b\u102c\u1038\u1021\u1010\u103d\u1000\u103a\u101e\u102c “ \u1021\u1019\u103e\u1010\u103a\u1019\u103b\u102c\u1038”  \u1000\u1031\u102c\u103a\u101c\u1036\u104f \u1015\u103b\u1019\u103a\u1038\u1019\u103b\u103e\u1021\u102c\u1038 \u1010\u103d\u1000\u103a\u1001\u103b\u1000\u103a\u1015\u102f\u1036\u1000\u102d\u102f \u1015\u103c\u101e\u1011\u102c\u1038\u101e\u100a\u103a\u104b<\/span><\/p>\n
 #calculate mean of 'points' column for rows where team equals 'A'\ndf. loc<\/span> [df[' team<\/span> '] == ' A<\/span> ', ' points<\/span> ']. mean<\/span> ()\n\n94.0<\/span>\n<\/span><\/strong><\/pre>\n
 \u201c\u1021\u1016\u103d\u1032\u1037\u201d \u1014\u103e\u1004\u1037\u103a \u201cA\u201d \u1014\u103e\u1004\u1037\u103a \u100a\u102e\u1019\u103b\u103e\u101e\u100a\u1037\u103a \u1021\u1010\u1014\u103a\u1038\u1021\u1010\u103d\u1000\u103a \u201c\u1021\u1019\u103e\u1010\u103a\u201d \u1000\u1031\u102c\u103a\u101c\u1036\u101b\u103e\u102d \u1015\u103b\u1019\u103a\u1038\u1019\u103b\u103e\u1010\u1014\u103a\u1016\u102d\u102f\u1038\u101e\u100a\u103a 94<\/strong> \u1016\u103c\u1005\u103a\u101e\u100a\u103a\u104b<\/span><\/p>\n
 “ \u1021\u1016\u103d\u1032\u1037”  \u101e\u100a\u103a “ A”  \u1014\u103e\u1004\u1037\u103a \u100a\u102e\u1019\u103b\u103e\u101e\u100a\u1037\u103a \u101c\u102d\u102f\u1004\u103a\u1038\u1019\u103b\u102c\u1038\u1021\u1010\u103d\u1000\u103a\u101e\u102c \u1021\u1019\u103e\u1010\u103a\u1010\u1014\u103a\u1016\u102d\u102f\u1038\u1019\u103b\u102c\u1038\u1000\u102d\u102f \u1015\u103b\u1019\u103a\u1038\u1019\u103b\u103e\u1021\u102c\u1038\u1016\u103c\u1004\u1037\u103a \u1000\u103b\u103d\u1014\u103a\u102f\u1015\u103a\u1010\u102d\u102f\u1037\u1000\u102d\u102f\u101a\u103a\u1010\u102d\u102f\u1004\u103a \u1005\u1005\u103a\u1006\u1031\u1038\u1014\u102d\u102f\u1004\u103a\u101e\u100a\u103a-<\/span><\/p>\n