xxxxxxxxxx
# import des librairies dont nous aurons besoin
import pandas as pd
import numpy as np
import re
# chargement et affichage des données
data = pd.read_csv('personnes.csv')
print(data)
xxxxxxxxxx
import pandas as pd
df = pd.read_csv (r'Path where the CSV file is stored\File name.csv')
print (df)
xxxxxxxxxx
# Way 1 : Import as dataframe
import pandas as pd
data = pd.read_csv("filename.csv")
# Way 2 : Import as list of tuples
import numpy as np
data = np.recfromcsv(file)
xxxxxxxxxx
import pandas as pd # pip install pandas
#read the CSV file
data_file = =pd.read_csv('some_file.csv')
print(data_file)
xxxxxxxxxx
import pandas as pd
import io
df = pd.read_csv(io.BytesIO(uploaded['file.csv']))
print(df)
xxxxxxxxxx
if(isset($_POST["Import"])){
$filename=$_FILES["file"]["tmp_name"];
if($_FILES["file"]["size"] > 0)
{
$file = fopen($filename, "r");
// Skip the first line
fgetcsv($file);
while (($getData = fgetcsv($file, 10000, ",")) !== FALSE)
{
$firstname=addslashes($getData[1]);
$lastname=addslashes($getData[2]);
$email=addslashes($getData[3]);
$reg_date=addslashes($getData[4]);
$sql = "INSERT into employee (firstname,lastname,email,reg_date)
values ('".$firstname."','".$lastname."','".$email."','".$reg_date."')";
$result = mysqli_query($conn, $sql);
if(!isset($result))
{
echo "<script type=\"text/javascript\">
alert(\"Invalid File:Please Upload CSV File.\");
window.location = \"index.php\"
</script>";
}
else {
echo "<script type=\"text/javascript\">
alert(\"CSV File has been successfully Imported.\");
window.location = \"index.php\"
</script>";
}
}
fclose($file);
}
}
?>