Stock Liao information

— Basic knowledge of stocks|Introduction to basics of stocks|Stock learning|Basic knowledge of stocks
Mobile access:m.liaochihuo.com

The data of the high-yield fund list of Tiantian Fund.com is saved in Excle#python crawler small test of openpyxl

Release Time:2021-04-23 Topic:003096 Fund Net Value Everyday Fund Net Reading:75 Navigation:Stock Liao information > Health regimen > The data of the high-yield fund list of Tiantian Fund.com is saved in Excle#python crawler small test of openpyxl phone-reading

The high-yield fund list data of Tiantian Fund Network is saved in Excle

Hello! After learning openpyxl, I can’t wait to practice it, so I chose a challenging Tiantian Fund network to crawl data and save hands-on practice. Of course, I also searched for others about the process of Tiantian Fund data crawling, but basically I can’t understand it, maybe it’s because I don’t know much about it. Here I will introduce a method that novices can understand, for your reference only.

1. The resulting Excel table:

I like to save the results first. After saving the crawled data using the openpyxl module, the results are as follows:

Due to the large amount of data in the list, only a part of the screen is captured here. You can go to the Tiantian Fund website to see, the general arrangement is the same as this one. Okay, let's not talk too much nonsense, let's introduce the crawling and saving process.

2. Crawl + save:

From the title, it’s not difficult to see that we get the above results. In fact, we take two major steps. The first step is to crawl, and the second is to save. The saving process is actually relatively simple. It only involves some basic statements such as: sheet.append(header)

sheet.append(rows), the header and rows in it are closely related to our crawler part, so I will focus on it here. Let's look at the crawler part.

Many crawlers can enter this interface, which means you have found the right content to crawl, but many people are not clear enough about the content processing , Cannot fundamentally improve our cognition and knowledge. Let's copy a part and focus on analysis.

Process analysis:

Here, temporarily store the data:

var rankData = {datas:[ "002939|GF Innovation and Upgrade Hybrid|Hybrid|2020-06-23|2.6236|1.78|6.39|12.69|29.36|45.26|121.64|145.97|148.08|42.17|173.69|3|1| 1|0.15|0||211|1|1|10 yuan|1.50%|0.15%|0.15%|1","519674|Galaxy Innovation Growth Hybrid|Hybrid|2020-06-23|5.8228|0.94|9.08 |9.97|26.17|46.08|121.46|139.04|147.14|44.53|482.28|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1"," 005911|GF Dual Engine Upgrade Hybrid A|Hybrid|2020-06-23|2.8574|1.95|7.00|12.83|27.51|39.95|121.34|||37.66|199.96|3|1|1|0.15|0||211 |1|1|100 yuan|1.50%|0.15%|0.15%|1","257070|League of Nations preferred industry mixed|mixed type|2020-06-23|2.9781|2.75|8.72|12.24|31.08|54.21| 118.03|131.61|95.03|51.10|266.94|3|1|1|0.15|0||211|1|1|100 Yuan|1.50%|0.15%|0.15%|1","161903|Mixed industry preferred (LOF)|Mixed|2020-06-23|1.7767|3.18|7.40|16.19|37.49|59.99|114.48|158.19|156.76|58.31|779.80|3|1|1|0.15|0||020,211|1|1|100 yuan|1.50%|0.15%|0.15%|1","213001 |Baoying Hongli Revenue Flexible Configuration Hybrid A|Hybrid|2020-06-23|2.0280|2.17|4.81|14.38|33.07|53.60|113.01|127.66|172.88|48.57|1,004.14|3|1|1|0.15| 0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","005689|BOC Healthcare Hybrid|Mixed|2020-06-23|2.3956|2.35|4.84|19.61|42.67 |60.26|112.75|145.40||55.50|145.52|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","005176|Fuguo Precision Medical Hybrid|Hybrid|2020-06-23|2.8643|2.63|4.66|20.62|44.47|65.43|112.58|118.70||62.98|186.40|3|1|1|0.15|0||211|1|1|100 Yuan|1.50%|0.15%|0.15%|1","002408|CITIC Medical Reform Hybrid A|Mixed|2020-06-23|2.1648|3.57|4.77|23.10|45.58|68.21|110.79|81.92|107.95 |65.76|116.48|3|1|1|0.12|0||211|1|1|1000 Yuan|1.20%|0.12%|0.12%|1","320007|Nuoan Growth Hybrid| Hybrid|2020- 06-23|1.6930|0.36|9.30|9.16|33.52|38.09|110.31|130.34|68.29|36.20|152.93|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15 %|0.15%|1","162703|GF Small Cap Growth Hybrid (LOF) A|Hybrid|2020-06-23|2.9038|1.55|4.60|11.69|26.44|46.04|110.15|121.17|126.35|42.97| 1,131.50|3|1|1|0.15|0||020,211|1|1|10 yuan|1.50%|0.15%|0.15%|1" ,"519026|Hai Fortis Small and Medium-sized Disk Hybrid|Hybrid|2020-06-23|1.5470|3.62|7.65|21.05|50.49|53.78|109.91|98.08|78.43|46.64|54.70|3|1|1|0.15| 0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","000727|Rongtong Health Industry Flexible Configuration Hybrid A/B| Hybrid|2020-06-23|2.6680|1.18| 5.29|20.02|45.63|69.72|108.93|140.58|168.14|64.29|166.80|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1", "002482|Baoying Internet Shanghai-Hong Kong-Shenzhen Hybrid|Hybrid|2020-06-23|2.3670|2.16|7.35|18.71|35.80|40.64|107.45|111.53|137.65|36.98|136.70|3|1|1|0.15| 0||211|1|1|100 Yuan|1.50%|0.15%|0.15%|1","003095|China-Europe Medical and Health Mix A|Mixed|2020-06-23|2.8430|2.97|4.87|20.88| 56.04|66.65|106.76|95.40|177.98|64.05|199.66|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","000452|Southern Medical and Healthcare Flexible Configuration Mix|Mixed|2020-06-23|3.2800|3.40|5.13|23.12|54.43|66.92|106.68|99.63|115.36|62.62|290.91|3|1|1| 0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","000924|Baoying Advanced Manufacturing Hybrid A|Hybrid|2020-06-23|2.0310|2.37|4.96 |14.29|32.26|51.62|106.28|122.67|155.62|46.47|157.41|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1"," 003096|China-Europe Healthcare Hybrid C|Hybrid|2020-06-23|2.8310|2.98|4.85|20.78|55.72|65.94|106.04|94.97|177.61|63.36|198.43|3|0|1|0.00|0|| 211|1|1|100 yuan||0.00%||","000220|Phu Quoc Healthcare Industry Mixed|Mixed|2020-06-23|4.3460|3.13|5.18|17.91|46.08|63.69|105.48|102.52| 152.97|60.78|334.60|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","161616|Rongtong Healthcare Industry Hybrid A/B| Hybrid|2020-06-23|2.3610|2.79|4.93|20.21|51.93|72.34|105.48|91.02|128.12|68.40|226.74|3|1|1|0.15|0||211|1|1|100 |1.50%|0.15%|0.15%|1","000717|Rongtong transformation three-power flexible configuration hybrid|hybrid|2020-06-23|2.7460|2.12|3.35|14.37|22.64|37.09|105.08|96.70|121.45 |30.76|174.60|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","004374|Huatai Baoxingji Nianfeng mixed launch A| Hybrid|2020-06-23|1.8959|1.97|4.47|18.08|28.93|38.47|104.39|86.95|117.44|32.96|106 .07|3|1|1|0.15|0||080,211|1|1|100 yuan|1.50%|0.15%|0.15%|1","005805|Huatai Bai Rui Medical Health Mix|Mixed Type|2020- 06-23|2.3471|2.88|4.31|22.31|53.00|66.18|104.34|||62.36|134.71|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%| 0.15%|1","004375|Huatai Baoxingji Nianfeng Hybrid initiated C|Hybrid|2020-06-23|1.8803|1.96|4.46|18.06|28.87|38.32|103.91|86.04|115.78|32.84|104.41| 3|0|1|0.00|0||080,211|1|1|100 yuan||0.00%||","000404|E Funda emerging growth flexible configuration|hybrid|2020-06-23|3.9400|2.02|7.12 |18.00|33.51|41.68|102.67|94.28|107.48|34.75|294.00|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1"," 002213|Zhonghai Shunxin Flexible Configuration Hybrid|Hybrid|2020-06-23|1.7816|2.08|5.33|15.73|34.16|55.88|102.66|97.60|81.86|48.74|84.04|3|1|1|0.08|0||211|1|1|100 yuan|0.80%|0.08%|0.08%|1","007490|Southern Information Innovation Hybrid A|Mixed|2020-06-23|2.0252|1.75|7.46| 19.57|32.02|38.71|102.52|||35.00|102.52|0|1|1|0.15|0||211|0|6|100yuan|1.50%|0.15%|0.15%|1","460005|Huatai Berry Value Growth Mixed|Hybrid|2020-06-23|4.4214|2.78|4.76|14.88|32.18|45.06|101.73|98.70|112.46|42.13|738.38|3|1|1|0.15|0||211| 1|1|100 yuan|1.50%|0.15%|0.15%|1","007491|Southern Information Innovation Hybrid C| Hybrid|2020-06-23|2.0091|1.75|7.44|19.48|31.74|38.15|100.93 |||34.48|100.91|0|0|1|0.00|0||211|0|6|100yuan||0.00%||","000339|Great Wall Healthcare Hybrid|Mixed Type|2020-06-23 |3.4616|2.21|4.58|19.23|36.22|56.73|99.94|120.43|135.32|52.50|246.16|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15 %|1","002560|Nuoanhexin Flexible Configuration Hybrid|Hybrid|2020-06-23|1.4659|0.34|9.22|10.18|32.59|41.10|99.52|60.05|45.86|39.21|46.59|3|1 |1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","050026|Bosera Healthcare Industry Hybrid A|Mixed Type|2020-06-23|3.7090| 1.56|2.97|21.65|52.89|65.95|99.09|118.95|147.60|62.60|315.17|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1 ","519773|Bank of Communications Data Industry Flexible Configuration Hybrid|Hybrid|2020-06-23|1.6910|1.20|4.45|14.64|24.16|38.61|98.94|131.96|104.72|34.53|69. 10|3|1|1|0.15|0||211|1|1|100 Yuan|1.50%|0.15%|0.15%|1","270050|Guangfa New Economy Hybrid|Hybrid|2020-06-23 |3.8160|2.61|3.47|14.63|34.75|60.47|98.54|78.90|95.29|57.75|281.60|3|1|1|0.15|0||080,211|1|1|10 yuan|1.50%|0.15%|0.15 %|1","240020|Huabao Pharmaceutical and Biological Hybrid|Hybrid|2020-06-23|3.5860|3.46|5.81|20.74|48.49|59.73|97.79|88.74|120.41|56.25|347.18|3|1|1 |0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","004905|Huatai Berry Biomedical Mix|Mixed|2020-06-23|2.4287|3.21| 5.00|18.14|48.53|61.67|97.49|101.62||57.82|142.87|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1"," 000977|Great Wall Environmental Theme Hybrid|Hybrid|2020-06-23|1.8355|1.42|3.36|16.44|43.61|57.65|96.52|108.60|81.91|51.88|83.55|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","007340|Southern Technology Innovation Mix A|Hybrid|2020-06-23|1.9702|0.53|3.59|13.94|26.38 |38.52|96.51|||34.60|97.02|0|1|1|0.15|0||211,413|0|6|100 yuan|1.50%|0.15%|0.15%|1","000031|China Renaissance Mix| Hybrid|2020-06-23|2.8380|1.61|6.21|18.10|38.57|40.36|95.99|98.88|61.16|33.74|183.80|3|1|1|0.15|0||211|1|1|100 |1.50%|0.15%|0.15%|1","470006|China Universal Medical and Healthcare Mixed A|Mixed|2020-06-23|2.5800|3.16|5.35|20.73|52.12|60.95|95.50|78.49|111.37 |57.89|235.32|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","002264|China Joy Health Mix|Mixed|2020 -06-23|2.1480|1.51|1.61|13.89|23.38|55.09|95.45|77.23|99.26|50.63|114.80|3|1|1|0.15|0||211|1|1|100 yuan|1.50%| 0.15%|0.15%|1","001822|Hua Shang Smart Life Flexible Configuration Hybrid|Hybrid|2020-06-23|1.5530|1.30|3.95|14.02|36.23|52.70|95.10|83.79|85.32|48.47|55.30| 3|1|1|0.15|0||211|1|1|100yuan|1.50%|0.15%|0.15%|1","002692|Fuguo Innovation and Technology Hybrid|Mixed|2020-06-23|2.1840 |3.61|9.31|18.95|34.15|44.35|95.00|132.34|130.62|41.45|118.40|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%| 1","001069|Huatai Berry Consumption Growth Hybrid|Mixed|2020-06-23|2.1250|2.91|4.53|14.12|31.66|46.65|94.95|98.23|102.57| 43.39|112.50|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","000601|Huabao Innovation Optimal Hybrid|Mixed Type|2020- 06-23|1.8610|1.03|5.74|24.56|37.95|45.28|94.26|113.66|103.61|41.09|123.94|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15 %|0.15%|1","110023|E Funda Healthcare Industry Mixed|Hybrid|2020-06-23|3.4230|2.61|6.04|19.73|46.66|58.84|93.72|88.08|144.15|55.45|242.30|3| 1|1|0.15|0||211|1|1|100 Yuan|1.50%|0.15%|0.15%|1","161810|Yinhua Domestic Demand Selection Mixed (LOF)|Mixed Type|2020-06- 23|3.0120|-0.20|7.53|12.10|31.18|42.34|93.45|121.63|89.20|37.16|201.20|3|1|1|0.15|0||020,211|1|1|100 yuan|1.50%|0.15% |0.15%|1","002708|Damosa Health Industry Mixed|Hybrid|2020-06-23|2.4440|2.99|6.54|16.44|38.63|56.47|92.59|92.74|135.45|53.04|144.40|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","005311|Wanjia Economic New Kinetic Energy Hybrid A| Hybrid Type|2020-06-23|2.1257|2.28|8.37|12.55|33.21|62.01|92.42|112.44||55.89|112.57|3|1|1|0.15|0||211|1|1|100yuan|1.50 %|0.15%|0.15%|1","006881|Huabao Health Mix|Mixed|2020-06-23|1.8897|3.40|5.38|19.60|47.53|63.45|91.96|||59.11|88.97|3 |1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","519642|Galaxy Intelligent Manufacturing Hybrid|Hybrid|2020-06-23|2.2720| 3.18|8.09|18.64|31.94|51.47|91.57|80.32|111.15|48.79|127.20|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1 ","001210|Tianhong Internet Hybrid|Hybrid|2020-06-23|1.1440|0.47|7.88|12.13|19.12|37.63|91.43|94.13|85.14|35.56|14.40|3|1|1|0.15|0 ||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","002124|Guangfa Emerging Industries Mixed|Hybrid|2020-06-23|2.4830|1.35|3.76|14.90|39.97| 58.66|91.29|95.05|105.21|52.05|148.30|3|1|1|0.15|0||211|1|1|100yuan|1.50%|0.15%|0.15%|1","001558|Tianhong Medical Healthy Mix A|Hybrid|2020-06-23|1.6457|2.75|4.25|19.17|42.69|58.04|91.20|79.94|128.00|54.05|64.57|3|1|1|0.12|0||211|1| 1|100 Yuan|1.20%|0.12%|0.12%|1","005312|Wanjia Economic New Kinetic Energy Hybrid C|Hybrid|2020-06-23|2.0834|2.28|8.36|12.50|33.04|61.62|91.19 |1 08.19||55.52|108.34|3|0|1|0.00|0||211|1|1|100 Yuan||0.00%||","006113|China Universal Innovative Medicine Hybrid|Mixed|2020-06 -23|2.4665|3.13|5.60|19.39|49.48|57.51|91.19|||54.44|146.65|0|1|1|0.15|0||211|0|6|100 yuan|1.50%|0.15%|0.15 %|1","001513|E Funda Information Industry Mixed|Hybrid|2020-06-23|2.2600|2.26|7.47|16.32|26.40|35.57|91.04|113.21|112.01|32.01|126.00|3|1|1| 0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","519670|Galaxy Industry Hybrid|Hybrid|2020-06-23|1.9860|2.32|8.52|17.03| 50.23|52.41|90.99|78.96|78.05|48.16|528.82|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","003516|Cathay Pacific RongAn Multi-strategy Flexible Configuration Hybrid|Hybrid|2020-06-23|2.3828|2.25|1.66|14.67|32.25|41.97|90.56|123.28||37.38|138.28|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","005028|Penghua Research Selected Flexible Configuration Hybrid|Hybrid|2020-06-23|1.8986|2.20|4.00|12.74| 40.57|55.33|90.49|99.06||48.65|89.86|3|1|1|0.15|0||211|1|1|100yuan|1.50%|0.15%|0.15%|1","001559|Tenhong Healthcare Hybrid C| Hybrid|2020-06-23|1.6190|2.75|4.24|19.12|42.56|57.72|90.43|78.50|125.52|53.75|61.90|3|0|1|0.00|0||211|1 |1|100 Yuan||0.00%||","001815|Huatai Berry Excitation Power Hybrid A|Hybrid|2020-06-23|2.5590|3.14|4.66|18.47|46.65|62.58|90.12|87.06|127.31 |57.87|168.22|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","002669|China Merchants Wanzhong Innovation Mix|Hybrid|2020- 06-23|1.5530|1.70|1.97|13.86|31.95|54.22|90.09|107.90|92.92|47.90|55.30|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15 %|0.15%|1","163001|Longxin Healthcare Hybrid (LOF)|Hybrid|2020-06-23|1.8080|2.67|2.61|19.66|46.28|62.15|89.92|78.13|100.00|58.74|186.69 |3|1|1|0.15|0||020,211|1|1|100 Yuan|1.50%|0.15%|0.15%|1","270028|Guangfa Manufacturing Selected Mixed|Hybrid|2020-06- 23|4.0380|0.80|5.24|15.64|36.97|44.63|89.67|90.38|71.90|39.43|303.80|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%| 0.15%|1","003291|Cinda Australia Silver Healthy China Hybrid|Mixed|2020-06-23|1.9050|2.81|5.25|18.62|55.00|59.28|89.55|87.87||56.53 |90.50|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","000939|BOC Research Select Flexible Configuration Hybrid|Mixed Type|2020 -06-23|1.3670|3.40|6.55|17.34|43.14|46.83|89.34|88.81|90.66|44.66|67.53|3|1|1|0.15|0||211|1|1|100 yuan|1.50%| 0.15%|0.15%|1","001508|Fortune New Power Flexible Configuration Hybrid A|Hybrid|2020-06-23|3.1790|1.99|5.47|14.93|31.74|44.50|89.00|112.50|168.04|42.30|217.90 |3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","002082|Huatai Berry Excitation Power Hybrid C|Hybrid|2020-06 -23|2.8380|3.16|4.68|18.45|46.52|62.36|88.95|85.01|124.22|57.67|194.80|3|0|1|0.00|0||211|1|1|100 yuan||0.00%|| ","001510|Fortune New Power Flexible Configuration Hybrid C| Hybrid|2020-06-23|3.1220|1.96|5.44|14.86|31.56|44.07|88.07|110.66|164.80|41.97|212.20|3|0|1|0.00|0||211|1|1|100 yuan||0.00%||","213006|Baoying core advantage hybrid A|hybrid|2020-06-23|1.2506|2.56|7.05 |15.49|24.35|36.50|87.93|96.22|88.90|33.16|311.01|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1"," 001480|Caitong Growth Optimal Hybrid|Hybrid|2020-06-23|1.6640|0.73|5.79|16.77|24.36|34.85|87.81|116.95|86.76|32.91|66.40|3|1|1|0.15|0|| 211|1|1|100yuan|1.50%|0.15%|0.15%|1","006218|Fuguo Biomedical Technology Hybrid|Hybrid|2020-06-23|1.9063|2.63|5.29|21.57|45.85|60.99 |87.76|||59.63|90.63|0|1|1|0.15|0||211|0|6|100 yuan|1.50%|0.15%|0.15%|1","410003|Huafu growth trend mix| Hybrid|2020-06-23|1.6649|1.96|4.63|17.69|27.79|55.38|87.69|87.90|100.43|51.26|118.86|3|1|1|0.15|0||211|1|1|100 |1.50%|0.15%|0.15%|1","006314|Zhongrong Strategy Optimal Hybrid A|Hybrid|2020-06-23|1.9029|2.19|5.13|16.49|38.32|45.05|87.64|||39.92| 90.29|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","501046|Caitong Multi-strategy Fuxin Dingkai Hybrid|Hybrid| 2020-06-23|1.9543|0.69|5.85|17.90|25.58|35.86|87.23|117.39||33.28|95.41|0|1|1|0.15|0||070,071,080,211|0|6|1000 yuan|1.50%| 0.15%|0.15%|1","001864|Zhonghai Charm Yangtze River Delta Hybrid|Hybrid|2020-06-23|2.0510|2.29|5.83|13.31|30.80|48.30|87.14|91.15|87.99|41.74|10 5.10|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","003032|Ping An Medical Health Hybrid| Hybrid|2020-06-23 |1.8377|2.36|4.92|19.63|47.84|60.55|87.12|75.00||57.30|83.75|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15% |1","550009|Xincheng Small and Medium-sized Disk Hybrid|Mixed|2020-06-23|2.5190|1.33|6.96|13.52|24.15|37.58|87.01|83.33|77.14|32.30|184.62|3|1|1| 0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","000698|Baoying Technology 30 Hybrid|Hybrid|2020-06-23|2.5620|1.83|6.71| 15.35|30.91|31.25|87.01|81.70|77.06|27.15|156.20|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","000073 |SIIC Morgan Growth Power Hybrid|Hybrid|2020-06-23|2.0470|2.71|5.30|19.01|43.35|43.75|86.60|59.67|71.58|39.92|104.70|3|1|1|0.15|0|| twenty one1|1|1|100 Yuan|1.50%|0.15%|0.15%|1","006736|SDIC UBS Advanced Manufacturing Hybrid|Hybrid|2020-06-23|1.8218|2.03|7.44|23.18|35.50 |40.25|86.28|||32.70|82.18|0|1|1|0.15|0||211|0|6|100 yuan|1.50%|0.15%|0.15%|1","290011|Taixin Select Hybrid|Hybrid|2020-06-23|2.8850|2.23|6.61|10.28|27.60|45.34|86.25|99.38|67.93|40.39|237.52|3|1|1|0.15|0||211|1|1 |1000RMB|1.50%|0.15%|0.15%|1","720001|Caitong Value Momentum Hybrid|Mixed|2020-06-23|3.2530|0.84|6.03|15.68|23.13|35.26|86.20|117.45| 92.61|33.16|331.00|3|1|1|0.15|0||211|1|1|100yuan|1.50%|0.15%|0.15%|1","001861|Fuanda Healthy Life Mix|Mixed| 2020-06-23|2.0445|1.77|5.38|24.16|45.79|55.46|86.15|74.10|104.70|51.50|104.45|3|1|1|0.15|0||211|1|1|100 yuan|1.50% |0.15%|0.15%|1","001701|Zhongrong Industrial Upgrade Hybrid|Hybrid|2020-06-23|1.8680|2.24|5.48|17.19|37.15|50.40|86.06|88.31|91.98|43.25|86.80| 3|1|1|0.15|0||211|1|1|100 Yuan|1.50%|0.15%|0.15%|1","004895|Hua Shang Xin An Flexible Hybrid|Mixed Type|2020-06-23| 1.3530|1.88|2.50|14.27|33.56|55.71|85.98|64.29||50.18|52.13|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%| 1","002160|South Drive Hybrid|Hybrid|2020-06-23|2.3990|1.61|3.94|14.95|34.02|41.78|85.97|78.76|93.00|38.59|139.90|3|1|1|0 .15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","003581|Qianhai United Nations National Health Mix A|Mixed|2020-06-23|1.7380|2.48 |6.56|16.41|39.37|57.29|85.88|57.43|67.92|53.40|73.80|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1" ,"002446|GF Lixin Flexible Configuration Hybrid|Hybrid|2020-06-23|2.0580|1.78|3.89|15.49|43.41|55.44|85.57|92.88|99.23|49.13|105.80|3|1|1|0.10| 0||211|0|1|100 Yuan|1.00%|0.10%|0.10%|1","000362|Cathay Pacific Juxin Value Advantage Hybrid A|Hybrid|2020-06-23|2.2980|1.91|2.68| 19.44|27.81|52.79|85.47|95.57|97.08|46.93|322.36|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","006315 |Zhongrong Strategy Optimal Hybrid C|Hybrid|2020-06-23|1.8798|2.19|5.13|16.45|38.19|44.59|85.42|||39.50|87.98|3|0|1|0.00|0||211| 1|1|100 yuan||0.00%||","377240|Shanghai Investment Morgan Emerging Power Hybrid A|Hybrid|2020-06-23|4.5800|1.82|5.87|18.50|37.58|46.61|85.28|75.75|87.94|41.80|358.00| 3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","519171|PDB-AXA Medical and Health Hybrid|Mixed Type|2020-06- 23|1.4940|2.33|2.96|20.58|46.47|59.28|85.13|75.56|102.99|56.77|49.40|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%| 0.15%|1","519133|Hy Fortis Reform Drives Hybrid|Hybrid|2020-06-23|1.8860|0.75|2.61|16.13|32.91|42.13|85.08|98.32|99.71|36.08|122.08|3|1 |1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1","200012|Great Wall Small and Medium-sized Cap Growth Hybrid|Hybrid|2020-06-23|2.5804|2.49 |4.60|14.73|32.44|52.23|84.94|78.80|99.41|48.62|158.04|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1" ,"000940|Fukuo Small and Medium-sized Cap Selected Mixed|Mixed|2020-06-23|2.1950|1.06|6.14|14.50|26.51|42.16|84.76|83.99|89.88|37.70|119.50|3|1|1|0.15| 0||211|0|1|100 yuan|1.50%|0.15%|0.15%|1","000363|Cathay Pacific Juxin Value Advantage Hybrid C|Hybrid|2020-06-23|2.3160|1.94|2.66| 19.44|27.67|52.37|84.69|93.81|94.13|46.68|325.05|3|0|1|0.00|0||211|1|1|100 yuan||0.00%||","000541|Chinese business innovation growth mix Initiation|Mixed|2020-06-23|2.0480|1.84|1.99|13.59|31.45|49.16|84.50|100.39|54.57|43.52|149.38|3|1|1|0.15| 0||080,211|1|1|100 yuan|1.50%|0.15%|0.15%|1","001704|SDIC UBS Jinbao Flexible Configuration Hybrid|Hybrid|2020-06-23|1.8521|2.00| 6.88|22.07|34.01|33.84|84.31|87.55|85.37|27.44|89.82|3|1|1|0.15|0||211|1|1|100 yuan|1.50%|0.15%|0.15%|1"] ,allRecords:3440,pageIndex:1,pageNum:100,allPages:35};

At first glance, I thought it was a dictionary, so I wanted to use eval and values ​​to get the content, but then I found that I was thinking too much. We agree to this content, it is not difficult to see that it is in the form of a string. For string processing:

The following is a few steps:

1. Find the content we need: in the [Content].

2. Turn each fund into a list

3. Take the value of each fund.

Directly upload the code here:

result=resp.text#Get the number inside the curly braces {} left=result.index('[') right=result.index(' ]') content=result[ left+1:right] i = 1 a="','" weizhi = content.find(a)if weizhi: content=content.replace(content[ weizhi ],"?") #Cyclic search and replace "," i=i+1 content = content.replace(",?", "") content=content.split("|") content = str(content).replace("?", "']?['") content = content.replace("?",'","') content=content[ 6:] content=content[ :-6] contents=(eval(content)) for s in contents: results=eval(s) aa=results[ 0] bb=results[ 1] cc=results[ 4] dd=results[ 3] ee=results[ 5] ff=results[ 6] gg=results[ 7] hh=results[ 8] ii=results[ 9] jj=results[ 10] kk=results[ 11] ll=results[ 12] mm=results[ 13] nn=results[ 14] oo=results[ 18] pp=results[ 24] rows=[ aa,bb,cc,dd,ee,ff,gg,hh,ii,jj,kk,ll,mm,nn,oo,pp] sheet.append(rows)

The operation of content in the above code is the essence. You can slowly absorb the experience, and it is best to try it yourself. Only the part of crawling my content is provided here. For the header of the table, you can directly use BeautifulSoup or Xpath, or the regular can be easily done. I will not introduce it in detail here. Students who need all the source code can also send a private message.

[1] https://www.cnblogs.com/yuhoucaihong/p/10185691.html

[2] https://blog.csdn.net/weixin _ 42393585/article/details/101198125

Article Url:https://www.liaochihuo.com/info/508895.html

Label group:[fund] [hybrid fund] [Tiantian Fund

Hot topic

Health regimen recommend

Health regimen Popular