Pandas统计分析基础（2）：Pandas之数据的读写（读取csv和excel文件）

✅作者简介：大家好我是Xlong，一枚正在学习COMSOL、Python的工科研究僧
📃个人主页:  Xlong的个人博客主页
🔥系列专栏:   Python大数据分析
💖如果觉得博主的文章还不错的话，请👍支持一下博主哦🤞

目录

一、数据的读写

1.1 读写csv：pd.read_csv和pd.DataFrame.to_csv

1.2 读写excel：pd.read_excel 和 pd.DataFrame.to_excel

---

一、数据的读写

1.1 读写csv：pd.read_csv和pd.DataFrame.to_csv

        注意区分pandas和numpy在读写csv方面的区别（下面代码中的‘GDP.csv’文件可私聊博主获取！！！）

（1）错误示范

import numpy as np
gdp_np=np.loadtxt('GDP.csv',delimiter=',')
print(gdp_np)

运行结果：

ValueError: could not convert string to float: ''

 显示报错了！

（2）正确操作

import numpy as np
gdp_np=np.loadtxt('GDP.csv',delimiter=',',dtype='str')
print(gdp_np)

 运行结果：

[['' '北京市' '天津市' '河北省' '山西省' '内蒙古自治区' '辽宁省' '吉林省' '黑龙江省' '上海市' '江苏省'
  '浙江省' '安徽省' '福建省' '江西省' '山东省' '河南省' '湖北省' '湖南省' '广东省' '广西壮族自治区' '海南省'
  '重庆市' '四川省' '贵州省' '云南省' '西藏自治区' '陕西省' '甘肃省' '青海省' '宁夏回族自治区' '新疆维吾尔自治区']
 ['2018年' '30319.98' '18809.64' '36010.27' '16818.11' '17289.22'
  '25315.35' '15074.62' '16361.62' '32679.87' '92595.4' '56197.15'
  '30006.82' '35804.04' '21984.78' '76469.67' '48055.86' '39366.55'
  '36425.78' '97277.77' '20352.51' '4832.05' '20363.19' '40678.13'
  '14806.45' '17881.12' '1477.63' '24438.32' '8246.07' '2865.23'
  '3705.18' '12199.08']
 ['2017年' '28014.94' '18549.19' '34016.32' '15528.42' '16096.21'
  '23409.24' '14944.53' '15902.68' '30632.99' '85869.76' '51768.26'
  '27018' '32182.09' '20006.31' '72634.15' '44552.83' '35478.09'
  '33902.96' '89705.23' '18523.26' '4462.54' '19424.73' '36980.22'
  '13540.83' '16376.34' '1310.92' '21898.81' '7459.9' '2624.83' '3443.56'
  '10881.96']
 ['2016年' '25669.13' '17885.39' '32070.45' '13050.41' '18128.1' '22246.9'
  '14776.8' '15386.09' '28178.65' '77388.28' '47251.36' '24407.62'
  '28810.58' '18499' '68024.49' '40471.79' '32665.38' '31551.37'
  '80854.91' '18317.64' '4053.2' '17740.59' '32934.54' '11776.73'
  '14788.42' '1151.41' '19399.59' '7200.37' '2572.49' '3168.59' '9649.7']
 ['2015年' '23014.59' '16538.19' '29806.11' '12766.49' '17831.51'
  '28669.02' '14063.13' '15083.67' '25123.45' '70116.38' '42886.49'
  '22005.63' '25979.82' '16723.78' '63002.33' '37002.16' '29550.19'
  '28902.21' '72812.55' '16803.12' '3702.76' '15717.27' '30053.1'
  '10502.56' '13619.17' '1026.39' '18021.86' '6790.32' '2417.05'
  '2911.77' '9324.8']
 ['2014年' '21330.83' '15726.93' '29421.15' '12761.49' '17770.19'
  '28626.58' '13803.14' '15039.38' '23567.7' '65088.32' '40173.03'
  '20848.75' '24055.76' '15714.63' '59426.59' '34938.24' '27379.22'
  '27037.32' '67809.85' '15672.89' '3500.72' '14262.6' '28536.66'
  '9266.39' '12814.59' '920.83' '17689.94' '6836.82' '2303.32' '2752.1'
  '9273.46']
 ['2013年' '19800.81' '14442.01' '28442.95' '12665.25' '16916.5'
  '27213.22' '13046.4' '14454.91' '21818.15'