我如何解析 csv 文件以首先获取列名然后获取与之相关的行? [英] how do i parse a csv file to grab the column names first then the rows that relate to it?
本文介绍了我如何解析 csv 文件以首先获取列名然后获取与之相关的行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是我的 csv
column1,column2,column3,column4,column5
column1_row1,column2_row1,column3_row1,column4_row1,column5_row1
column1_row2,column2_row2,column3_row2,column4_row2,column5_row2
column1_row3,column2_row3,column3_row3,column4_row3,column5_row3
column1_row4,column2_row4,column3_row4,column4_row4,column5_row4
column1_row5,column2_row5,column3_row5,column4_row5,column5_row5
column1_row6,column2_row6,column3_row6,column4_row6,column5_row6
column1_row7,column2_row7,column3_row7,column4_row7,column5_row7
column1_row8,column2_row8,column3_row8,column4_row8,column5_row8
column1_row9,column2_row9,column3_row9,column4_row9,column5_row9
第一行当然是列名.我试过 fgetcsv() 但所做的只是显示所有行.而不是我想要的.我该怎么做?
first row is the column names of course. i tried fgetcsv() but all that would do is display all rows. rather than what i want. how can i do it?
因此,如果我最后将数据放入数组中,我将能够打印出数据的表格格式,就像在 excel 中显示的一样.
so if i were to put the data into an array at the end i would be able print out a table format of the data just like its shown in excel.
谢谢
这是我的样本:
$filename = "upload/sample.csv";
if (($handle = fopen($filename, 'r')) !== FALSE)
{
while (($row = fgetcsv($handle, 1000, ",")) !== FALSE)
{
print_r($row);
}
}
这是我的输出:(我将 $row 放入 pre 以便我可以显示它)
this is my output: (i put the $row into a pre so i can show it)
Array
(
[0] => column1
[1] => column2
[2] => column3
[3] => column4
[4] => column5
column1_row1
[5] => column2_row1
[6] => column3_row1
[7] => column4_row1
[8] => column5_row1
column1_row2
[9] => column2_row2
[10] => column3_row2
[11] => column4_row2
[12] => column5_row2
column1_row3
[13] => column2_row3
[14] => column3_row3
[15] => column4_row3
[16] => column5_row3
column1_row4
[17] => column2_row4
[18] => column3_row4
[19] => column4_row4
[20] => column5_row4
column1_row5
[21] => column2_row5
[22] => column3_row5
[23] => column4_row5
[24] => column5_row5
column1_row6
[25] => column2_row6
[26] => column3_row6
[27] => column4_row6
[28] => column5_row6
column1_row7
[29] => column2_row7
[30] => column3_row7
[31] => column4_row7
[32] => column5_row7
column1_row8
[33] => column2_row8
[34] => column3_row8
[35] => column4_row8
[36] => column5_row8
column1_row9
[37] => column2_row9
[38] => column3_row9
[39] => column4_row9
[40] => column5_row9
)
推荐答案
要一次性阅读所有内容,您可以使用:
For reading it all at once you can use:
$csv = array_map("str_getcsv", file("file1.csv",FILE_SKIP_EMPTY_LINES));
$keys = array_shift($csv);
要将所有行转换为一个不错的关联数组,您可以应用:
To turn all the rows into a nice associative array you could then apply:
foreach ($csv as $i=>$row) {
$csv[$i] = array_combine($keys, $row);
}
这篇关于我如何解析 csv 文件以首先获取列名然后获取与之相关的行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文