Better to Run than Curse the Road

原因：index不同。用df.index发现，两个dataframe一个是RangeIndex, 另一个是int64。 解决方法：# 1. 将int64的index重新设置成rangeindexdf1.reset_index(inplace=True)df1.index# 2. ignore indexdf = pd.concat([df1, df2],ignore_index=True)print(df.index)...

使用dataframe的 sort_values 多列排序，全设置降序排列import pandas as pdmedal = { "金": [8, 8, 7, 10], "银": [3, 7, 5, 7], "铜": [8, 3, 7, 3], "总数": [19, 18, 19, 20],}df = pd.DataFrame(medal)rank = df.sort_values(by=["金", "银", "铜", "总数"], ascending=.

问题：使用sys.path.append()添加路径后还是无法导包进入preferences 点击项目projects的项目结构，右边添加内容根 添加包目录 ✅

目录0. goal1. pytz2. func3. 实例0. goal将字符串类型的日期时间， 如 "2021-03-1616:05:05" 确认为某一时区时间后，转换成北京时间。（根据个人需求去掉了时间只保留日期）1. pytz可以显示所有国家地区的各个时区，通过这个确定需要的时区pytz.all_timezonesOut[5]: ['Africa/Abidjan', 'Africa/Accra', 'Africa/Addis_Ababa', ...

import smtplibfrom email.header import Headerfrom email.mime.application import MIMEApplicationfrom email.mime.multipart import MIMEMultipartfrom email.mime.text import MIMETextclass SendEmail: def __init__(self): """ 配置发件人信息 .

importzipfilefile = "文件路径"zip_file = zipfile.ZipFile(file) # 读取zip文件zipfile.is_zipfile(zip_file) # 判断是否为zipprint(zip_file.namelist()) # 获取zip文档内所有文件的名称列表zip_file.extractall('输出的路径') # 解压全部文件...

1. 由↓引出的问题pip3 install -r requirements.txt2.尝试更新pip解决python -m pip>>> 版本为2.7pip install --upgrade pip>>>Traceback (most recent call last): File "/usr/local/bin/pip", line 5, in <module> from pip._internal...

解决方法，直接在读入时变成strpd.read_excel("....", converters={u"以000之类开头的列名" : str})

# 跳过超出header字段的行，如4个字段，579行出现了 5个pd.read_table(, error_bad_lines=False)# 显示的跳过信息b'Skipping line 579: expected 4 fields, saw 5
'

1. interpreter里使用 as a particular variable>>> 5 + 49>>> _ # stores the result of the above expression9>>> _ + 615>>> _15>>> a = _ # assigning the value of _ to another variable>>> a15

import unicodedatas = 'aac1233xyz'[in]t2 = s.translate({ord('a'): 'X', ord('3'): 'Y'}) print(t2)[out] XXc12YYxyz[in]t3 = s.translate({ord('a'): None, ord('3'): None}) print(t3)[out]c12xyz

1.创建个dfdf = DataFrame({"pear": [1,2,3], "apple": [2,3,4], "orange": [3,4,5]})2.获取列名df.columns3.获取列的indexdf.columns.get_loc("pear")

参考https://www.jianshu.com/p/0ed914608a2c脚本：https://github.com/WENHUIn/python3.7/blob/main/*arg%26**kw.py

args=(i)不是tupleargs=(i,)通过添加逗号，形成tupleAdd a comma; tuples are formed by the comma, not the parentheses (although you need parentheses to disambiguate the tuple from other arguments in a call)

1. 时间戳转时间 【毫秒转】import datetimedef transfer_to_localtime(unix): localtime = datetime.datetime.fromtimestamp(unix / 1000) return localtimeEg:unix = 1605280519000date = transfer_to_localtime(unix)print(date)2020-11-13 23:15:192. 时间转时..

1. 问题：TypeError: __init__() missing 1 required positional argument: 'on_delete'classForeignKey(to,on_delete,**options)[source]¶A many-to-one relationship. Requires two positional arguments: the class to which the model is related and theon_deleteo...

1. -bash: mysql: command not foundhttps://www.jianshu.com/p/ba22165965692.django.db.utils.OperationalError: (1049, "Unknown database 'mydatabase'") 报错mysql> create database mydatabase character set uft8;https://blog.csdn.net/lo_bamboo/articl..

1.在终端里使用export PYTHONPATH="文件夹路径"2. 检查是否设置完成路径echo $PYTHONPATH

1.目标：将一串json格式字符串分列 该字符串位于dataframe的data列{"score": 527, "features": {"GD_M_103": 9.0, "GD_M_246": 70.0, "GD_M_238": 0.0, "GD_M_315": 11.0, "GD_M_107": 4.0, "GD_M_319": 6.0, "GD_M_2": 19.0, "GD_M_72": 1.0, "GD_M_60": 0.0, "GD_M_82": 1.0, "GD_M_6": 2.0.

1. 使用 literal_evalfrom ast import literal_evalpython_dict = literal_eval("{'a': 1}")2. 使用 json.loads() 【注意，字符串必须为double quotes】import jsonpython_dict = json.loads('{"a": 1}')