import pandas as pd
# 보기
def show(member):
print(member)
def showAll(members):
print(members)
# 추가
def add(members):
id,name,rating,phone = input('id,name,rating,phone').split()
members.loc[len(members)] = [id,name,rating,phone]
#찾기
def find(members):
id = input("id:")
if len(members[members['id']==int(id)]) != 0:
return members[members['id']==int(id)].iloc[0]
return None
#수정
def update(members):
member = find(members)
if not member.empty:
phone = input("phone:")
members.loc[member.name,'phone'] = phone
else:
print("없음")
#삭제
def delete(members):
member = find(members)
if not member.empty:
members.drop(member.name,axis=0,inplace=True)
else:
print('삭제 실패')
#실행
import pandas as pd
def run():
import pandas as pd
members = pd.DataFrame(columns=['id','name','rating','phone'])
members.to_csv('df_members.csv',index=False)
while True:
members = pd.read_csv('df_members.csv')
c = input("목록(s),추가(a),찾기(f),수정(u),삭제(d),종료(x):")
if c == 's':
showAll(members)
elif c == 'a':
add(members)
display(members)
members.to_csv('df_members.csv',index=False)
elif c == 'f':
show(find(members))
elif c == 'u':
update(members)
members.to_csv('df_members.csv',index=False)
elif c == 'd':
delete(members)
members.to_csv('df_members.csv',index=False)
elif c == 'x':
break;
else:
print("잘못입력")