-
Notifications
You must be signed in to change notification settings - Fork 0
/
pandas-operations.py
45 lines (35 loc) · 1.1 KB
/
pandas-operations.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
import pandas as pd
import numpy as np
data = {
"Column1": [1,2,3,4,5],
"Column2": [10,20,13,20,25],
"Column3": ["abc","bcaa","ade","cb","dea"]
}
df = pd.DataFrame(data)
def kareal(x):
return x * x
kareal2 = lambda x: x * x
result = df
result = df["Column2"].unique()
result = df["Column2"].nunique()
result = df["Column2"].value_counts()
result = df["Column1"] * 2
result = df["Column1"].apply(kareal)
result = df["Column1"].apply(kareal2)
result = df["Column1"].apply(lambda x: x * x)
df["Column4"] = df["Column3"].apply(len)
result = df.columns
result = len(df.columns)
result = df.index
result = len(df.index)
result = df.info
result = df.sort_values("Column2")
result = df.sort_values("Column3")
result = df.sort_values("Column3", ascending = False)
data = {
"Ay": ["Mayıs","Haziran","Nisan","Mayıs","Haziran","Nisan","Mayıs","Haziran","Nisan"],
"Kategori": ["Elektronik","Elektronik","Elektronik","Kitap","Kitap","Kitap","Giyim","Giyim","Giyim"],
"Gelir": [20,30,15,14,32,42,12,36,52]
}
df = pd.DataFrame(data)
print(df.pivot_table(index="Ay",columns= "Kategori", values= "Gelir"))