python - 如何在python中将多个文本文件导入一个数据框?
问题描述
我在这里找到了如何将多个文本文件导入一个数据框。但是,它给出了一个错误。文件的名称为 footballseason1、footballseason2、footballseason3 ...(直到 footballseason5000)
import pandas as pd
import datetime as dt
import os, glob
os.chdir("~/Downloads/data")
filenames = [i for i in glob.glob("*.txt")]
FileNotFoundError:[Errno 2] 没有这样的文件或目录:'~/Downloads/data'
但是,如果我尝试导入一个文件,一切正常并找到目录
df = pd.read_csv("~/Downloads/data/footballseason1.txt", sep=",")
你能帮忙解决问题吗?是否有任何方法可以在不更改目录的情况下执行此操作,只需使用所有文件所在的路径完成所有步骤?
解决方案
Python默认os
是不理解~
的,所以需要手动扩展:
filenames = [i for i in glob.glob(os.path.expanduser("~/Downloads/data/*.txt"))]
推荐阅读
- javascript - javascript react app fails to compile with generated openapi-client
- docker - No NGINX redirection towards a gunicorn dockerized flask app - Nginx + Docker + Flask + Gunicorn
- arm - How to show all printed values when using arm-none-eabi-gdb?
- javascript - Javascript json object reduction by multiple keys?
- python - Softban command(discord.py)
- unity3d - How to have collision detection without physics in Unity?
- c++ - Why are objects not cleared after hardware exception?
- c++ - 为什么 cuda-gdb 显示意外的内存值?
- java - Resize JTable size
- shopify-app - AppBridgeError INVALID_CONFIG: host must be provided